RE: need help with unload problem
Thanks Marco, I will give it a try and let you know how I go.
rgds,
Damian
At 06:05 PM 14/02/97 MET, Marco Greco wrote:
}
}--- 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
}
}
}