I have a table that has a field of type BLOB, with thousands of rows of data. Is there a function or a row ID that will allow me to only select the first - say - 800 rows? I want to ultimately save each BLOB to a file, but only want to take a chunk at a time. If I select the BLOB field and then save the output, is there a limit to how much the select statement will output, therefore cutting off the BLOB? Thanks. MC
If you are using Vortex you can use the MAX= parameter to <SQL>, and in tsql you can use -l to limit the number of rows, e.g.
<SQL ROW MAX=800 "select ..."></SQL>
or
tsql -l 800 "select ..."
Texis will not cut off the blob, so you will get the entire field.