Re: LOTOFILE Utility

Jordi Tous wrote: > 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 ??? IBM Informix Guide to SQL: Syntax - http://publib.boulder.ibm.com/epubs/pdf/ct1sqna.pdf See pages 4-138 to 4-140. The documentation describes how the names are generated and how to change the default behavior. -- June Hunt

Thanks for all June ! Bye "June C. Hunt" <june_c_hunt@hotmail.com> wrote in message news:<2im00oFo90dfU1@uni-berlin.de>... > Jordi Tous wrote: > > 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 ??? > > IBM Informix Guide to SQL: Syntax - > http://publib.boulder.ibm.com/epubs/pdf/ct1sqna.pdf > See pages 4-138 to 4-140. The documentation describes how the names are > generated and how to change the default behavior.