Help with SQL1013N? [SEC=UNCLASSIFIED]

Glyn Owen

Help with SQL1013N? [SEC=UNCLASSIFIED]
Hello Sally

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
NONRECOVERABLE" ;
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.


Regards
Glyn Owen

Please consider the environment before printing this document


NOTICE
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