When u submit cobol-db2 where u will see the TIMESTAMP

Nithya-Sankar · New User Joined: 10 May 2007 Posts: 3 Location: balngalore

Hai,
I'm a fresher.These r the questions i faced in the interview.SO pls answer me for these questions.

1) THERE ARE 5 JOB STEPS IN A JCL.i WANT TO EXECUTE ONLY THE 3RD STEP.HOW IS IT possible?

2) Can2 job cards present in a jcl? If not why? When executed what will be the resule?

3) What is the max lenth of the Parm value in jcl? How will u pass a value with 1000 length from jcl to cobol?

4) WHen a same cobol-db2 program is executed for 5 times how many DBRM will be created?

5) When u submit cobol-db2 where u will see the TIMESTAMP ?

6) When u open DBRM what will the internal structure of it?

7) S9(4)v99 comp Is it correct or not/ if not ,why?
X (4)
S9(8) comp
S9(4)v99 comp-3 what will be the total bytes?

8) Ther is nullable column.It doesn't have any data. Select max(nullable col) What will be the result?

Nithya-Sankar · New User Joined: 10 May 2007 Posts: 3 Location: balngalore

Hai,

1) Without referring the jcl how would u find the plan name for the program?

2) Cobol code to accept the parm values in jcl?

3)Where do u give the start and end in cobol prog?

Nithya-Sankar · New User Joined: 10 May 2007 Posts: 3 Location: balngalore

Hai,
I'm a fresher.These r the questions i faced in the interview.SO pls answer me for these questions.

1) WHen a same cobol-db2 program is executed for 5 times how many DBRM will be created?

2) When u submit cobol-db2 where u will see the TIMESTAMP ?

3)S9(4)v99 comp Is it correct or not/ if not ,why?
X (4)
S9(8) comp
S9(4)v99 comp-3 what will be the total bytes?

priyamnavada · New User Joined: 24 Dec 2005 Posts: 52 Location: hyderabad

2) When u submit cobol-db2 where u will see the TIMESTAMP ?

In footprints, you can see everything...

3) S9(4)v99 comp Is it correct or not/ if not ,why?

No, COMP is only for binary representation. COMP-3 is for packed decimal.

COMP should contain only S and 9 in the PIC clause.

4) X (4) - 4 BYTES
S9(8) comp - 4 BYTES
S9(4)v99 comp-3 - 4 BYTES

priyamnavada · New User Joined: 24 Dec 2005 Posts: 52 Location: hyderabad

1) THERE ARE 5 JOB STEPS IN A JCL.i WANT TO EXECUTE ONLY THE 3RD STEP.HOW IS IT possible?

use restart parameter, for example, RESTART= STEP03
and put a null statement after the 3rd step.

1) Without referring the jcl how would u find the plan name for the program?

from footprints, you can get everything.

superk · Posted: Thu May 31, 2007 12:41 am

While we can answer those questions - we need to know your goals to be
able to "help you out".

Are you creating questions to find out whether prospective employees
are competent?

Are you trying to fool employers into thinking you are competent? (If
so, can you come up with a reason that we could morally agree to
assist you)? Or at least so that we can do so without hurting our
industry?

skkp2006 · Posted: Thu May 31, 2007 1:21 pm

Superk is right......but still i am sharing what i know.....

1.Run the step below and include the steps that u wanna run
//userIE JOB (TD),'FUND CODE',
// CLASS=P,MSGCLASS=X,NOTIFY=&SYSUID
//STEP1 EXEC PGM=IEBEDIT
//SYSUT1 DD DSN=Your dataset that contain the JCL,DISP=SHR
//SYSUT2 DD SYSOUT=(*,INTRDR)
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
EDIT TYPE=INCLUDE,STEPNAME=(STEP1,STEP2)

/*

2.255 Job cards in one JCL can be run
3.100 bytes.... else use sysin
4.only one ... it will get updated all the time
5.Load module and DBRM
6.all sql call statements
7.
8.No value will be returned ... i think aggregate funcions will avoid null values.

expat · Posted: Thu May 31, 2007 1:25 pm

kzkrishnamoorthy · New User Joined: 23 May 2007 Posts: 1 Location: chennai

If u want to execute only 3sr statement code Restart=step3 code cond=(0,Le) in job step so that irrespective of cond step 3 will be executed and no other steps will be run because o will be always greater than or equal to any condition code.

srebba · New User Joined: 26 Apr 2007 Posts: 37 Location: USA

Could u please let me know the what is Footprint.
Where we can see and what information

Thank you
Sree