unload in Informix

Posted in 1998

Manoj Kumar Sutar — Mon, 14 Dec 1998 15:58:08 GMT — source: Informix-list mailing list archive (1991-1998)

Hi , If I unload from an empty table OR 0 row qualify for unload to a file say file1 . What this file file1 will contain . I have a program which will work fine if file1 contains 0 rows . It must not contain anyting . My program is expected to run on Unix . A part of my shell script is ... echo " unload .... to file1 select ......" > unload.sql isql database_name unload.sql if [ -s file1 ] then echo " OK , I want this " else echo " My program will fail " fi I do not have Informix installed at our office . Can any one tell me whether my program will work as I wanted ? Thanking you in advance for your precious time . With regards , Manoj