Forums & Discussions Home

    A place for members, communities, and committees to have discussions online and via e-mail.
    Click a category or topic to below to start the conversation...

    You are currently in view only mode for this forum. Please click the appropriate below to login as a member and participate. If you are not a member, please CLICK HERE for more information.

    Jun 01

    Help with SQL1013N? [SEC=UNCLASSIFIED]

    Glyn Owen
    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
    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.

    Glyn Owen

    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,
    is the home of IDUG's Listserv

    All Times America/Chicago

    Copyright © 2015 IDUG. All Rights Reserved

    All material, files, logos and trademarks within this site are properties of their respective organizations.

    Terms of Service - Privacy Policy - Contact