how to code bind copy

william giannelli

how to code bind copy

I need to bind copy one package from one system into another.

I am not understanding the manual example. It suggests coding a stored proc?

thanks

Bill

steen rasmussen

how to code bind copy
(in response to william giannelli)
This statement will bind a copy of RQATL into a separate collection IDUG_COLL2 (currently sits in IDUG_COLL collection).
BIND PACKAGE(IDUG_COLL2)                         OWNER(RASST02)                              QUALIFIER(RASST02)                          COPY(IDUG_COLL.RQATL)                       COPYVER(CAD115_2008-01-08-20.41.45)         CURRENTDATA(NO)                             VALIDATE(RUN)                               EXPLAIN(NO)                                 ACTION(REPLACE)                             SQLERROR(NOPACKAGE)                         ISOLATION(CS)                               RELEASE(COMMIT)                             DEGREE(1)                                   REOPT(NONE)                                 KEEPDYNAMIC(NO)                           DBPROTOCOL(DRDA)                 ENCODING(EBCDIC)                 IMMEDWRITE(INHERITFROMPLAN)      DYNAMICRULES(BIND)               ROUNDING(HALFEVEN)               APREUSE(NO)                      SYSTIMESENSITIVE(YES)            BUSTIMESENSITIVE(YES)            DESCSTAT(YES)                    ARCHIVESENSITIVE(YES)            FLAG(I);                      
Steen Rasmussen On Saturday, September 7, 2019, 02:59:57 PM EDT, william giannelli <[login to unmask email]> wrote:


I need to bind copy one package from one system into another.

I am not understanding the manual example. It suggests coding a stored proc?

thanks

Bill

Site Links: View post online   View mailing list online   Start new thread via email   Unsubscribe from this mailing list   Manage your subscription  

This email has been sent to: [login to unmask email]
Discover the best cloning tool on the market. Try BCV5 & the new BCV5 Masking Tool.
ESAi also has powerful solutions for Buffer Pool Tuning, Log Analysis, TDM, & more.
http://www.ESAIGroup.com/idug



Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2

Chris Tee

how to code bind copy
(in response to steen rasmussen)
Bill

Taking Steen's example below, if you want to bind onto another subsystem, say location DSN2, it would be

BIND PACKAGE(DSN2.IDUG_COLL2)
OWNER(RASST02)
QUALIFIER(RASST02)
COPY(IDUG_COLL.RQATL)
COPYVER(CAD115_2008-01-08-20.41.45) .....

This assumes that there is a DDF link to DSN2 and that the owner id (or the id it translates to in USERNAMES) has the relevant access on DSN2.

regards

Chris
________________________________
From: steen rasmussen <[login to unmask email]>
Sent: 08 September 2019 04:29
To: william giannelli <[login to unmask email]>
Subject: [DB2-L] - RE: how to code bind copy

This statement will bind a copy of RQATL into a separate collection IDUG_COLL2 (currently sits in IDUG_COLL collection).

BIND PACKAGE(IDUG_COLL2)
OWNER(RASST02)
QUALIFIER(RASST02)
COPY(IDUG_COLL.RQATL)
COPYVER(CAD115_2008-01-08-20.41.45)
CURRENTDATA(NO)
VALIDATE(RUN)
EXPLAIN(NO)
ACTION(REPLACE)
SQLERROR(NOPACKAGE)
ISOLATION(CS)
RELEASE(COMMIT)
DEGREE(1)
REOPT(NONE)
KEEPDYNAMIC(NO)
DBPROTOCOL(DRDA)
ENCODING(EBCDIC)
IMMEDWRITE(INHERITFROMPLAN)
DYNAMICRULES(BIND)
ROUNDING(HALFEVEN)
APREUSE(NO)
SYSTIMESENSITIVE(YES)
BUSTIMESENSITIVE(YES)
DESCSTAT(YES)
ARCHIVESENSITIVE(YES)
FLAG(I);

Steen Rasmussen
On Saturday, September 7, 2019, 02:59:57 PM EDT, william giannelli <[login to unmask email]> wrote:



I need to bind copy one package from one system into another.

I am not understanding the manual example. It suggests coding a stored proc?

thanks

Bill

-----End Original Message-----