Onunload script
The poster using IDS 9.21 on HP-UX wanted an onunload script that splits output into 2GB files. Jonathan Leffler suggested checking large file support, using SQLCMD, or unloading to a named pipe and splitting with split. The poster mentioned Expect and later said the problem was solved, without giving details.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hello, all.
I have IDS 9.21 on HP-UX.
I am searching onunload shell script, which automatically unload data
in file 2Gb size and automatically change file.
On Fri, May 30, 2008 at 1:36 AM, <rootdbs@gmail.com> wrote:
> I have IDS 9.21 on HP-UX.
> I am searching onunload shell script, which automatically unload data
> in file 2Gb size and automatically change file.
Which version of HP-UX? Does the o/s support large files?
If so, then you should be able to get SQLCMD (which requires ESQL/C)
to work OK, without the need for splitting up the files. The
as-distributed software might not support large files, but you can
work around that.
Alternatively, you could consider unloading to a named pipe, and
having the process that reads the pipe do the splitting for you --
maybe the 'split' program, or maybe something else
--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/
"Blessed are we who can laugh at ourselves, for we shall never cease
to be amused."
NB: Please do not use this email for correspondence.
I don't necessarily read it every week, even.
I want to usу EXPECT Expect - http://en.wikipedia.org/wiki/Expect.
I solved this problem. :)