Re: loadfile with quotation marks

try_and_err wrote: > Hi, You are not being clear about what you want. Do you want to load a delimited datafile containing quoted strings into a table with the strings stripped from them? Or if not what? If the former, there's no way without preprocessing the file to strip the quotes in dbaccess. If you are using another utility like Jonathan Leffler's sqlcmd instead of dbaccess then yes, sqlcmd (and the linked name sqlload) can handle that. DELIMIDENT is different. Art S. Kagel > is there a chance to load such a line in a loadfile without scripting, > like "load from ... insert into ... ? > 123|"abc"| > > The problem is, that the quotations marks were inserted too, but i > would only have the letters. In the documentation i found the > description of DELIMIDENT: > DELIMIDENT causes the database server to interpret double quoted > (") text as identifiers rather than strings. > I have tried with DELIMIDENT=1 and DELIMIDENT=Y - no success. > Informixversion is 9.30.UC5. > Any suggestions ? > > Regards, > try_and_err