Output BLOB to file

Post Reply
MC
Posts: 1
Joined: Tue Feb 06, 2001 2:58 pm

Output BLOB to file

Post by MC »

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
User avatar
John
Site Admin
Posts: 2622
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

Output BLOB to file

Post by John »

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.
John Turnbull
Thunderstone Software
Post Reply