Re: unload to TAPE

You can unload/load a single table w/ `onunload`. There are certain restrictions, so read the manual carefully: check the Informix Migration Guide (v 7.2), pg 9-61. If you want to unload an entire database, you could use `dbexport`, which will let you indicate a tape drive as an output device. Jonathan Leffler wrote: > >Date: Mon, 18 Aug 1997 16:14:33 +0000 > >From: pjhaveri@attmail.com (Priti Jhaveri) > >X-Informix-List-Id: <list.16013> > > >I wanted to know whether it is possible to unload data on tape e.g. > > >unload to /dev/tape_device > >select * from table> > >or > > >load from /dev/tape_device > >insert into table> > Yes, though you should theoretically use quotes around the device > name. > > >If yes, how is Informix going to detect/prompt for the second tape. > > It isn't. LOAD expects to read all the data from a single file. > UNLOAD expects to write all the data to a single file. > > For LOAD, when the single file is complete (eg because the tape ran > out of space), then the load is complete. If there was a partial data > > row on the last row of data, you will get an error (probably) and the > load may be rolled back (in a logged database). > > Or, for UNLOAD, when the file runs out of space, you get an error in > the UNLOAD command. > > Yours, > Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> > PS: Warning I do not reply to messages with anti-spam in the return > path. -- * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ADDRESS ALTERED TO FOIL SPAMMERS: Remove "*NO-SPAM*" to reply. Cosmo Lee Multi-User Computer Systems Brooklyn, NY "JUST SAY 'NO' TO SPAM" * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *