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