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
 

 

Interview questions

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

New User


Joined: 10 Mar 2005
Posts: 26

PostPosted: Sat Jul 23, 2005 6:48 pm    Post subject: Interview questions
Reply with quote

hi
recently i hav faced an interview and i hav the following two questions. i hav answered the questions but they havn,t satisfied.can i know the answers for those.


1. How you optmize your programs.

2.How to pass parameters from JCL to DB2 ?


thanks in advance
Back to top
View user's profile Send private message

ovreddy

Active User


Joined: 06 Dec 2004
Posts: 211
Location: Keane Inc., Minneapolis USA.

PostPosted: Mon Jul 25, 2005 2:30 pm    Post subject: Re: Interview questions
Reply with quote

Hi Narsimha,

Ans 1: To optimize your program you need to observe and optimize all the SQL queries in your programs. For example if you want to use a small DB2 control table repeatedly in your program then load it into Working storage section. Always try to use Indexed columns in WHERE clause. etc...

Ans 2: We cannot pass parameters directly from JCL to DB2. We will passthem to COBOL+DB2 program, which uses them in queries as host variables. There are 3 methods to pass data from JCL to COBOL

1. Code PARM parameter
2. Use SYSIN DD *
3. PARMLIB Member

Thanks,
Reddy.
Back to top
View user's profile Send private message
narasimha_devi
Warnings : 1

New User


Joined: 10 Mar 2005
Posts: 26

PostPosted: Tue Jul 26, 2005 6:23 pm    Post subject: Re: Interview questions
Reply with quote

thank u very much Mr.reddy.
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 Mainframe Interview Questions CICS,CO... akshathan Mainframe Interview Questions 6 Thu Feb 09, 2017 6:38 pm
No new posts Viewing executing process in NDM .. q... Debb.Brant IBM Tools 0 Wed Dec 14, 2016 10:55 pm
No new posts INCLUDE condition questions van bui DFSORT/ICETOOL 1 Thu Jun 30, 2016 9:52 am
No new posts SAS Programming - Basic Questions Techelm All Other Mainframe Topics 3 Fri Mar 18, 2016 10:53 pm
No new posts Where can i find Interview questions ... Elixir Mainframe Interview Questions 4 Sat Feb 20, 2016 12:38 am


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