LOTOFILE Utility
Posted in 2004
Jordi Tous — — source: Usenet: comp.databases.informix
Hi everybody,
I'm using the LOTOFILE function for extract to a file the contents of
a CLOB datatype in my IDS Version 9.40.FC2.
The content of the CLOB file is javascript code, not images or other
things.
The problem i've is that with the sintax :
SELECT rowid, LOTOFILE(file_data, TRIM(file_name), 'client')
FROM wic_jrep_filedb;
the name of the file generated is, for example,
cinvgast.jsp.0000000040035c0c,
where the "0000000040035c0c" is posted by IDS, so my file_name column
is only composed by cinvgast.jsp
It cause to me to work with sed to clean this extension ...
Is it posible to avoid this "extension" in the SELECT clause that
contains the LOTOFILE function ???
Thanks for advance,
Jordi