View previous topic :: View next topic
|
Author |
Message |
karthik1680 Warnings : 2 New User
Joined: 14 May 2005 Posts: 64 Location: chennai
|
|
|
|
1. in a static call how the called pgm and calling program linked, which step linking them?
2. i am having two files in that files some fields are same in two files i want to eliminate that fields using sort how?
3 .i am having a copy book that copybook is used by 10 pgms
ex: 01 ws-a.
02 ws-b pic x(1).
02 ws-c pic s9(3) comp-3.
.................
....................
..................
, nw i get a request to change one of the variable ie 02 ws-c pic s9(3) is changed to pic s9(5).
1.nw in my 10 pgms , 8pgms are going to use the copybook that are changed and other 2 pgms are going to use the old?
2.we re not changing the copy book nw 8 pgms are not going to use the variable ws-c.and two of my pgms are going to use that variable ws-c?
4. in db2 using a single insert statement how to add the values in two tables? |
|
Back to top |
|
|
iknow
Active User
Joined: 22 Aug 2005 Posts: 411 Location: Colarado, US
|
|
|
|
Hi Karthik1680,
Check out the answers,
Quote: |
1. in a static call how the called pgm and calling program linked, which step linking them? |
At the time of execution, the LOADLIB will take care of calling and called program in the case of Static call.
Quote: |
3 .i am having a copy book that copybook is used by 10 pgms
ex: 01 ws-a.
02 ws-b pic x(1).
02 ws-c pic s9(3) comp-3.
.................
....................
..................
, nw i get a request to change one of the variable ie 02 ws-c pic s9(3) is changed to pic s9(5).
1.nw in my 10 pgms , 8pgms are going to use the copybook that are changed and other 2 pgms are going to use the old?
2.we re not changing the copy book nw 8 pgms are not going to use the variable ws-c.and two of my pgms are going to use that variable ws-c? |
In case 1) You need to re-compile only the 8 programs.
In case 2) Since there is no change in the copybook layout, all the 10 programs will work as such. No need to re-compile any of these programs.
Hope this helps. |
|
Back to top |
|
|
iknow
Active User
Joined: 22 Aug 2005 Posts: 411 Location: Colarado, US
|
|
|
|
Hi Karthik1680,
As a follow up to my previous post let me give some more information on your queries.
Quote: |
3 .i am having a copy book that copybook is used by 10 pgms
ex: 01 ws-a.
02 ws-b pic x(1).
02 ws-c pic s9(3) comp-3.
.................
....................
..................
, nw i get a request to change one of the variable ie 02 ws-c pic s9(3) is changed to pic s9(5).
1.nw in my 10 pgms , 8pgms are going to use the copybook that are changed and other 2 pgms are going to use the old?
2.we re not changing the copy book nw 8 pgms are not going to use the variable ws-c.and two of my pgms are going to use that variable ws-c? |
In case 2) if you didn't re-compile then you will end up with LRECL mismatch and the program gets abended. One way you can avoid that by making use of FILLER. Just increase the size of FILLER to amtch with LRECL.
Quote: |
2. i am having two files in that files some fields are same in two files i want to eliminate that fields using sort how? |
The answer is make use of either SYNCSORT or EXEC PGM =SYNCTOOL.
Inside the JCL make use of SUM fields = NONE.
NOTE
For this query contact Frank Yaeger(DFSORT Moderator) for the exact code.
Quote: |
4. in db2 using a single insert statement how to add the values in two tables? |
To my understanding one solution is by making use of STORED PROCEDURES you can achieve the solution
Hope this helps.
If anyone come up with a solution, please add on. |
|
Back to top |
|
|
|