External table ... pipes

Aix 6.1 IDS 11.70.fc6 Working with an external table and a pipe ... Getting a -26154 and -6 error. If I do .. unload to asset select * from psfsdw:asset; Works as expected ... When I do a:insert into asset_ext select * from psfsdw:asset; I get the error ... external table is defined to use the pipe .. pipe works ok with the direct unload .. If I change the pipe to a file in the external table, then the second works ok ... anyone got an idea as to what might be happening? Thanks ... Peter Logan Senior Database Administrator Phone: 616/878-8309

Dumb question: Do you have some program writing data to the pipe for the SELECT to read? The -26154 error indicates a filesystem IO error, the ISAM error -6 is echoing the errno from the OS. Errno 6 is "No such device". Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Jul 8, 2013 at 11:49 AM, Peter_Logan@spartanstores.com < Peter_Logan@spartanstores.com> wrote: > Aix 6.1 > IDS 11.70.fc6 > > Working with an external table and a pipe ... Getting a -26154 and -6 > error. If I do .. > > unload to asset > select * from psfsdw:asset;> > Works as expected ... > > When I do a:insert into asset_ext > select * from psfsdw:asset;> > I get the error ... external table is defined to use the pipe .. pipe > works ok with the direct unload .. If I change the pipe to a file in the > external table, then the second works ok ... anyone got an idea as to > what might be happening? > > Thanks ... > > Peter Logan > Senior Database Administrator > Phone: 616/878-8309 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e013d1cf8a9e5f304e1024488

Nope .. that is what is strange ... I can do an unload to pipe .. select * from ... and it works as expected .... Peter Logan Senior Database Administrator Phone: 616/878-8309 From: "Art Kagel" <art.kagel@gmail.com> To: ids@iiug.org, Date: 07/08/2013 12:11 PM Subject: Re: External table ... pipes [30777] Sent by: ids-bounces@iiug.org Dumb question: Do you have some program writing data to the pipe for the SELECT to read? The -26154 error indicates a filesystem IO error, the ISAM error -6 is echoing the errno from the OS. Errno 6 is "No such device". Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Jul 8, 2013 at 11:49 AM, Peter_Logan@spartanstores.com < Peter_Logan@spartanstores.com> wrote: > Aix 6.1 > IDS 11.70.fc6 > > Working with an external table and a pipe ... Getting a -26154 and -6 > error. If I do .. > > unload to asset > select * from psfsdw:asset;> > Works as expected ... > > When I do a:insert into asset_ext > select * from psfsdw:asset;> > I get the error ... external table is defined to use the pipe .. pipe > works ok with the direct unload .. If I change the pipe to a file in the > external table, then the second works ok ... anyone got an idea as to > what might be happening? > > Thanks ... > > Peter Logan > Senior Database Administrator > Phone: 616/878-8309 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e013d1cf8a9e5f304e1024488 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.