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
    2011

    Help with SQL1013N? [SEC=UNCLASSIFIED]

    Glyn Owen
    [asic]
    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



    All Times America/New_York

    Copyright © 2014 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