COPY command in PRO*C

good morning,..

i running a 6.0.37 rdbms on hp-ux 9.0.1.

i'm trying to copy tables from one db to another. i want to use the COPY command, because i need to select a portion of the tables to copy. the second database is much smaller.

the problem is, i need to do the procedure in a PRO*C program, and dyanmically build the sql statement to COPY... i'm not sure i can do this. first off, i can't set the arraysize, or copycommit, due to a "missing keyword" error. i guess these two commands are more suited to the SQL*PLUS environment, rather than a program. finally, my syntacticly correct sql statement returns a syntax error when run.

i seem to be preparing and executing correctly.... bottom line, can you use COPY in a PRO*C program?

(i tried opening a cursor, fetching and inserting,.. but the procedure took about 72 hours to complete.. a bit too slow)

any help is appreciated,.. thanks...

--
                   Brian J. Gelly -- Cleveland, Ohio
bjgelly_at_iccgcc.decnet.ab.com               bu921_at_Cleveland.Freenet.Edu