Re: problem with unload in esql

Peter Land (100522.3377@CompuServe.COM) wrote: : Load and unload are not really SQL - ie they are not passed to : the database engine, but are functions of a front-end tools : such as isql or 4GL. With all versions of ESQL that I have tried : so far you have to write your own equivalent ESQL/C or ESQL/COBOL : code - a loop which fetches rows using a cursor and writes them : to a file, or a loop which reads records from a file and inserts : them into a table. Looks like 2 C functions handle load/unload: _ffload( char* filename , char *delimeiter , char *insert_stmt ); _ffunload( char* filename , char *delimeiter , char *select_stmt ); Both set sqlca.sqlcode. At least this is what the 4GL code compiles to. You might need the 4GL libraries to use these calls. In which case, you'll need to c4gl your .ec file. -Joel Schumacher jschumac@uns-dv1.jcpenney.com OR jschumac@jcpenney.com