Re: unload to TAPE

>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.