Re: dbaccess unload to a pipe

You shouldn't be closing the pipe. Instead, I would suggest that you use the 'split' command.... and possibly a compress program... in your pipeline. DL Redden <redden96@yahoo.co To: Informix List <informix-list@iiug.org> m> cc: Sent by: Subject: dbaccess unload to a pipe owner-informix-lis t@iiug.org 03/18/2004 03:13 PM We have several tables that if unloaded to a file would be larger than 2GB. To manage this I have written a pipe in perl. I use dbaccess' unload to to unload to the pipe file that my perl program issitting behind. My program will catch rows and slam them into a file until the file gets to around 1.7 GB (just in case my calculations are wrong). I then close that file and open a new one and continue throwing rows into the new file. In testing this I have found that I am dropping rows. I have poured through my code and cannot find any reason for this. The question: I was wondering if maybe when I stop reading the pipe so that I can switch output files that the unload doesn't block and it just keeps dumping rows that my pipe isn't catching? __________________________________ Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam http://mail.yahoo.com sending to informix-list sending to informix-list