Re: external load via named pipes

Here's a new utility I wrote for a client to get around the limitation of dbcopy only handling a single blob column in a table (it gets confused if there are more than one). It should also get around the LVARCHAR problem though I haven't tried it on lvarchars yet. I'm including it in the next utils2_ak release, but if you can give it a try for me I'd appreciate it. It should be nearly as fast as dbcopy. 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 Sun, Jul 28, 2013 at 10:04 PM, RAY BURNS <ray.burns@velocityglobal.co.nz>wrote: > I changed some scripts and copied 496 tables from my database and all but > three tables went swimingly. for each execution I used the -F -S -E 1 flags > (as well as -d -D -t). I redirected the stderr to a file. > > For the three failing tables stderr file each reported the same error > -1831. > Finderr showed this as "Combination of FetArrSize, Deferred-PREPARE, and > OPTOFC is not supported" > > I cannot see anything particularly different about these three tables as > opposed to the other 493. > > Before I go drowning in code, are you able to shed any light on where I > might > begin? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e0158c2920e858204e3858ec9