Re: unload in Informix

Posted in 1998

Topics: Installation, Setup & Upgrades, Server Administration, Migration, Import/Export & Data Conversion

Octavian Chiriac — Mon, 14 Dec 1998 20:06:33 +0200 — source: Informix-list mailing list archive (1991-1998)

Sure. Why not ? I would use dbaccess instead of isql. But it is Ok too. Manoj Kumar Sutar wrote: > > 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

Glossary

dbaccess