Interview questions

narasimha_devi · New User Joined: 10 Mar 2005 Posts: 26

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

ovreddy · Posted: Mon Jul 25, 2005 2:30 pm

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.

narasimha_devi · New User Joined: 10 Mar 2005 Posts: 26

thank u very much Mr.reddy.