Re: loadfile with quotation marks -> csv-file

Jonathan Leffler <jleffler@earthlink.net> wrote in message news:<424A4DD6.9060106@earthlink.net>... > I sent it to the IIUG, but haven't had a confirmation that it is up. > Drop me an email from the account you want me to send it too if you'd > rather have it more quickly. I get dozens "important Windows update" and other "very important" emails and you don't know my email adress ??? ;-) OK, i have received your email(s) and and I will try it out. > That is not supposed to happen. Core dumps are never supposed to > happen. This isn't because of commas in the data, is it? No (sorry). For example: sqlcmd -d testdb -e begin -e 'select count(*) from systables' Bus Error - core dumped (This is also with sqlcmd 77.05) It seems there is a problem with 'begin'/'begin work' (?). I will try this tomorrow on Linux and on an other Solaris machine. > Maybe look at Marco Greco's code? I'm very disappointed that you're > having so much trouble - but I've never really stressed CSV format; it > is very much a minority concern in the Informix world, and was added to > SQLCMD more as a challenge than because of a big perceived need. That > said, it is most certainly intended to work. Now, if the trouble is > commas within quoted strings or other ghastly CSV nonsense, I feel less > concern about it - v77.03 is known not to handle that correctly (and I > think v77.05 does handle them correctly, though I may be being too > optimistic). Should i know what you mean with "Marco Greco's code" ? 'vertmenu' ? I am very pleased over your assistance, i did not want that you are disappointed. 'sqlcmd' is a nice tool, when you could not test it on Solaris i try to test it for you. ;-) Thanks again. Regards, try_and_err