Re: 4gl Quesions (EASY, I hope...)

No. But you can have the SELECT/INSERT part of the UNLOAD/LOAD statement in a variable string. For example: DEFINE unload_str CHAR(512), load_str CHAR(512) LET unload_str = "SELECT * FROM ", tablename CLIPPED UNLOAD TO "FileName" unload_str LET load_str = "INSERT INTO ", tablename CLIPPED LOAD FROM "FileName" load_str HTH, ----------------------------------------------------------------------------- Robert Minter Data Systems Support Senior Software Engineer A Client Technologies Company E-Mail: rob@dssmktg.com Tel: 714.771.0454 Fax: 714.771.3028 #include <std_disclaimer.h> http://www.dssny.com * You cannot prepare a 'LOAD' or 'UNLOAD' statement in a program, correct me if I am wrong.. * * piyush * * > * > LOAD is an INFORMIX SQL STATEMENT That can be used in dbaccess as well as * > prepared in a 4gl program. I have used load to take a flat file and LOAD * > it into a TEMP table then used by the program.