When I tried to do something similar quite a while back I had very similar
syntax to you.
---- remote=remote database
---- remote database is in the local database directory
---- local =local database id
db2 connect to remote;
db2 "declare mycursor cursor database local user userid using password for
select * from repository.LOAD_FORM" ;
db2 "load from mycursor of cursor replace into db2inst3.LOAD_FORM
db2 connect reset ;
I was connected to the remote database and had to put the password in for
the local so I did not script it.
Please consider the environment before printing this document
This e-mail and any attachments are intended for the addressee(s) only and may be confidential. They may contain legally privileged or copyright material. You should not read, copy, use or disclose them without authorisation. If you are not the intended recipient please contact the sender as soon as possible by return e-mail and then please delete both messages. This notice should not be removed.
IDUG DB2 Tech Conference * Prague, Cz * 14-18 Nov 2011 * http://IDUG.ORG/EMEA
If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's Listserv