Unloaddb to tape

From: Alan Jones 
Subject: Re: Can you get unloaddb to go directly to tape?

To unload Very large Ingres tables is easy under UNIX.

Firstly, make a named pipe under unix using the mknod -p command
eg
% mknod -p /tmp/fifo

then use this file as the file name in the copy command.

As a separate process you then copy the information to tape.

Some sample Bourne Shell script would look like this

(
sql database << EOF
copy blah() to '/tmp/fifo
\\p\\g
EOF
) &
dd if=/tmp/fifo of=/dev/rmt/1

Cheers

Alan
    .-------------------------------------------------------------.
    |  ALAN JONES  - Manager UAC Project                          | 
    |  Ph: +61 7 3858 1235                                        | 
    |  Fx: +61 7 3368 2263           e-mail: alan@qtac.edu.au     | 
    ._____________________________________________________________.
Ingres Q & A
To William's Home Page
Email William