View previous topic :: View next topic
|
Author |
Message |
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Hi all,
I have a cobol-db2 program, i pre-compile it. It gives me a DBRM.
My question is ,
when i bind package it, it creates a new PACKAGE, RIGHT
My question is,
How to create a new collection & add my PACKAGE to that collection.
So that i can use the this collection in the plan.
Please enlight me in this process.....
How to create new package, collection and plan.
Add packages to collections and use this collection in the plan.
Very Confused Right now,
Sushanth |
|
Back to top |
|
|
Bharath Bhat
Active User
Joined: 20 Mar 2008 Posts: 283 Location: chennai
|
|
|
|
Read this Article. Probably this could help you. |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Hi,
I get the flow how it goes.
By bind package/plan ? i can create a package/plan.
How to create a collection ? and add the package to the collection.
Sushanth |
|
Back to top |
|
|
Bharath Bhat
Active User
Joined: 20 Mar 2008 Posts: 283 Location: chennai
|
|
|
|
When you are binding a package, mention your collection name in
Code: |
PACKAGE(?)
MEMBER(URMEMBER)
...........................
........... |
I think that should create a collection if you have authority to create a collection.
PS--> I've not tested it. But when I tried, it gave me an error
Code: |
DSNT235I -DTTA DSNTBCM2 BIND AUTHORIZATION ERROR
USING DB2TUNT AUTHORITY |
not an SQLCODE. So I thought the approach is correct but problem with authority. |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
I just found out, in BIND PLAN i can create a new collection(PKLIST).
Thank You,
Sushanth |
|
Back to top |
|
|
Bharath Bhat
Active User
Joined: 20 Mar 2008 Posts: 283 Location: chennai
|
|
|
|
Thanks for letting me know. |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Its all about SHARING bharath. |
|
Back to top |
|
|
Bharath Bhat
Active User
Joined: 20 Mar 2008 Posts: 283 Location: chennai
|
|
|
|
I tried it out, but I am still getting a similiar error. I guess I do not have proper authority. |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Bharath,
I tried to create package for a table which i created. I guess i will be having proper authority.
Sushanth |
|
Back to top |
|
|
Bharath Bhat
Active User
Joined: 20 Mar 2008 Posts: 283 Location: chennai
|
|
|
|
sushanth bobby wrote: |
Bharath,
I tried to create package for a table which i created. I guess i will be having proper authority.
Sushanth |
I thought packages are for programs. What do you mean by 'package for a table'? |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Yes Yes Bharath,
Packages are for program only. The cobol program access the table which i created, so i am the table owner. So, as i was saying, i will be having proper authority.
Sushanth |
|
Back to top |
|
|
Bharath Bhat
Active User
Joined: 20 Mar 2008 Posts: 283 Location: chennai
|
|
|
|
Oh!! Okies, I got that. I will try to emulate you some time later |
|
Back to top |
|
|
|