« Return to Thread: ODBC Query that returns a file?
ODBC Query that returns a file?
by Marks, Jim
::
Rate this Message:
Some parts of this message have been removed.
Learn more about Nabble's security policy.
We have a database table that holds text files as one
of the columns.
When we query the database table, the file is returned as a
column. It is formatted as numeric—hex format.
GET DATA
/TYPE=ODBC
/CONNECT='valid-connection-string’
/SQL="SELECT id, SEQUENCENO, POSTTIME,
FILE_NAME, FILE_DATE, FILE_SIZE, FILE_TYPE, "+
"FILE_PATH, FILE_DATA, MACHINENAME,
UPDATEDATE, PRODUCT_TYPE FROM database1.FILE_DATA WHERE "+
"(FILE_NAME = 'sample.INI' AND id =
1000)"
/ASSUMEDSTRWIDTH=5000.
CACHE.
We need to be able to read the file into a column as a text
format—the hex only translates into the 1st 255 characters.
Any ideas/ suggestions? Or are we limited by the structure
of the database?
Jim Marks
Director, Market Research
x1616
« Return to Thread: ODBC Query that returns a file?
| Free embeddable forum powered by Nabble | Forum Help |
