Re: Load Table in ESQL/C
Posted in 1993
} } Hi Netlanders, } } I've got following problem: } With ISQL I can easily load a table with } } LOAD FROM "file_name" INSERT INTO table_name } } Now I want ESQL/C to do the same job and here is the problem. } If I prepare a cursor with the line above I got a syntax error. } I think the problem are the quotation marks. I have tried null, one, two and } three quotations marks , but nothing worked. } So, is there a way to run this thing in ESQL/C ????? } } Thanks in advance and } So long, } Klaus. } } PS: I need this, because I have to load tables in an environment where ISQL is } not installed. I have often tried to do the same thing through ESQL/C. There is no load sql statement command given in our reference of 4.0. nor listed in any reference structure or include file I can find. I'm not sure why informix did not include this sql statement as part of ESQL/C for us people who like to interactively use ESQL, but this has been a pain. For my applications I end up building a .sql load file and calling it from the ESQL/C program. For your situation not having sql installed - I say good luck!! Mike Alder Boise Hewlett Packard mikea@hpdmmfi.boi.hp.com