Creating a DB2 package

To create a DB2 package, follow these steps:

1. Create the collection using the following command:

   GRANT CREATE ON COLLECTION SYAMD2 TO PUBLIC

2. Bind the plan to include the collection and grant access to the packages using the following command:

   BIND PLAN(AMD2PLAN) ACTION(REPLACE) PKLIST(*.SYAMD2.*) + ISOLATION(CS) VALIDATE(BIND) GRANT RUN ON PLAN AMD2PLAN TO PUBLIC

3. Bind the packages in the collection using the following command:

   BIND PACKAGE(SYAMD2) ACT(REPLACE) + LIBRARY('SYBASE.AMD2105.CICSDB2.DBRM') MEMBER(RSPA) + ISOLATION(CS) VALIDATE(BIND) GRANT EXECUTE ON PACKAGE SYAMD2.RSPA TO PUBLIC BIND PACKAGE(SYAMD2) ACT(REPLACE) + LIBRARY('SYBASE.AMD2105.CICSDB2.DBRM') MEMBER(RSPB) + ISOLATION(CS) VALIDATE(BIND) GRANT EXECUTE ON PACKAGE SYAMD2.RSPB TO PUBLIC

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF