RE: need help with unload problem
--- On Fri, 14 Feb 1997 20:51:12 UTC+10 Damian Van Prooyen
<dvp@melbpc.org.au> wrote:
>Hi all,
>I am running Online 5.03.UC2 and have a problem with
>unloading tables that I need some help with.
>
>Scenario 1.
>I need to create many ASCII pipe delimeted files, I have no
>worries with this concept except for the fact that I
>don't have the disk space and I need to "stream" the
>unloads to an 8MM Exabyte tape.
>What I thought of doing was creating a "named pipe",
>unloading to the named pipe and then piping through
>dd to a non rewindable tape device.
>I have no idea how to do this from within ISQL without
>generating syntax errors. What I wish to test would be
>something like the following.
>echo "select * from tabname unload to /dev/named_pipe"
>|$INFORMIXDIR/bin/isql dbname|dd if=/dev/named_pipe
>of=/dev/rmt/xt1n
>
>I know my syntax is wrong, can anyone point me in the
>right direction?
>
try [untested!]
dbaccess<<-! | dd if=named_pipe of=your_tape <other_dd_parms>
database your_db;
unload to named_pipe
select * from your_tab!
HTH,
Marco
____________________________________________________________________________
rem radioterapia, which I immeritately manage, seldom agrees with what I say
marco greco (Catania, Italy) Work:
marcog@ctonline.it rem radioterapia 39 95 447828 fax 446558
(was mar.greco@agora.stm.it) Achea 39 95 503117