View previous topic :: View next topic
|
Author |
Message |
herewego
New User
Joined: 20 Feb 2006 Posts: 14
|
|
|
|
Quick question -
Can I have two DCLGENs for a DB2 table.
Let's consider I have a table and I want to use that table in two different scenarios, one for normal fetch & another for multifetch. In that case, for multifetch scenarios, we need to have a array defined in the DCLGEN. So I will have two DCLGENs, one for normal fetch usage and one for multifetch usage.
Note : I dont' want to change the normal fetch DCLGEN since it has been called by many modules. Also I don't want to use the workstorage variables since it is not the standard way of using tables. |
|
Back to top |
|
|
Succor
New User
Joined: 20 Feb 2009 Posts: 96 Location: Bangalore :)
|
|
|
|
Quote: |
Can I have two DCLGENs for a DB2 table |
I am not sure if you can.
DCLGEN generates a table or view declaration and puts it into a member of a partitioned data set that you can include in your program.
You can use DCLGEN for table declarations only if the table or view that you are declaring already exists.So,you wont be having a DCLGEN to support your multiftech scenario.
Hope this helps.
WTF |
|
Back to top |
|
|
ashimer
Active Member
Joined: 13 Feb 2004 Posts: 551 Location: Bangalore
|
|
|
|
Quote: |
Also I don't want to use the workstorage variables since it is not the standard way of using tables.
|
????????
why dont you term your second one as a COPYBOOK ? [/code] |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hi Ashimer,
Quote: |
Also I don't want to use the workstorage variables since it is not the standard way of using tables. |
Quote: |
???????? |
Wonder where that belief originated. . . I don't recall seeing a program that did not use ws variables. . . . Maybe some clarification will be posted. |
|
Back to top |
|
|
|