Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

In a static call how the called pgm and calling program link

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
karthik1680
Warnings : 2

New User


Joined: 14 May 2005
Posts: 64
Location: chennai

PostPosted: Sun Dec 11, 2005 9:38 am    Post subject: In a static call how the called pgm and calling program link
Reply with quote

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
View user's profile Send private message

iknow

Active User


Joined: 22 Aug 2005
Posts: 413
Location: Colarado, US

PostPosted: Mon Dec 12, 2005 1:52 pm    Post subject: Re: In a static call how the called pgm and calling program
Reply with quote

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
View user's profile Send private message
iknow

Active User


Joined: 22 Aug 2005
Posts: 413
Location: Colarado, US

PostPosted: Mon Dec 12, 2005 8:09 pm    Post subject: Re: In a static call how the called pgm and calling program
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SQL query not working in Cobol program. CuriousMainframer COBOL Programming 14 Wed Feb 22, 2017 5:56 pm
No new posts Calling procedure with multiple entri... steve-myers PL/I & Assembler 5 Fri Jan 27, 2017 3:33 pm
No new posts Executing OO COBOL program invoking J... Virendra Shambharkar COBOL Programming 2 Tue Jan 10, 2017 6:37 pm
No new posts Need Suggestion on COBOL program vickey_dw COBOL Programming 5 Thu Jan 05, 2017 10:55 pm
This topic is locked: you cannot edit posts or make replies. Calling REXX code from ISPF panel sanchita dey TSO/ISPF 4 Mon Jan 02, 2017 5:13 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us