Interview Questions Answers in DB2, COBOL, VSAM, JCL

Questions / { prasenjit }

Questions Answers Category Views Company eMail

I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!

KNIT, Tech Mahindra,

17 DB2 22370

What is the difference beetween Arrays and Tables in Cobol? please dont give the answer that arrays in cobol terminology is called tables......

BirlaSoft,

3 COBOL 11239

Answers / { prasenjit }

Question { 13284 }

What do you mean by dirty read ?

Answer

Mr.Ram's answer is the practical reason for using dirty
read.When a user needs to view records and does not intend
to update than a UR isolation level is used, so that any
changes made by other's dont bother user1.

Is This Answer Correct ?

0 Yes

0 No

Question { 11500 }

In the COBOL SELECT statement what is the ORGANIZATION for a
KSDS?

Answer

It can be both Indexed for direct access....
and Sequential for normal access!

Is This Answer Correct ?

6 Yes

0 No

Question { Cap Gemini, 7868 }

The first VSAM file V1 has 2 fields A and B . There is a
DB2 file which has fields E and f. We need the fields A,
B , E and F to another VSAM file called V2. Kindly mention
the logic in procedure division in cobol..

Answer

I suppose the question is a bit confusing....DB2 deals in
table's and has records...

Open VSAM file and read the records into WS variables,
Fetch DB2 records in host variables
Now write them to file V2.

Is This Answer Correct ?

2 Yes

0 No

Question { IBM, 12980 }

A maximum of 100 chars can be passed to Cobol through Parm
in JCL, If we want to pass more than 100 Chars how we can
do it ?

Answer

RE:To add on

You can also use files to pass values

Is This Answer Correct ?

5 Yes

3 No

Question { 12131 }

How to display string in the reverse order using occurs
clause?

Answer

Have u missed something.

Out-string must be an array.

01 OUT-STRING PIC X occurs 9 times.

Is This Answer Correct ?

2 Yes

2 No

Question { 12131 }

How to display string in the reverse order using occurs
clause?

Answer

@fool
Hello Mr.Fool as ur screen name and ur approach suggest u
dont have the basic quality of respecting individuals.Very
sorry to say that this forum is not for abusing anyone nor
it is a place to show individual intellects.I would suggest
that you abstain from commenting and purely provide
solutions to queries posted.You are welcome to do so.
Thanks,
Adim.

Is This Answer Correct ?

13 Yes

1 No

Question { Syntel, 48294 }

What is mean by maxcc

Answer

TO add on to answer num-3

Maxcc=0 Successful.
Maxcc=4 Successful with warnings.
Maxcc=8 Critical or Severe error.
Maxcc=12 Fatal Error.

Is This Answer Correct ?

60 Yes

1 No

Question { TCS, 28642 }

In one of intervie, my interviwer asked, I have a file
which contains 4 records I would like to split the 4
different outputs for each record how to do?

Answer

//**********************************************************

//STEP0011 EXEC PGM=SORT

//SORTIN DD DSN= ,DISP=SHR

//SORTOFO1 DD DSN= ,DISP=.....,
// SPACE=(....),
// DCB=....
//SORTOFO2 DD DSN= ,DISP=.....,
// SPACE=(....),
// DCB=....
//SORTOFO3 DD DSN= ,DISP=.....,
// SPACE=(....),
// DCB=....
//SORTOFO4 DD DSN= ,DISP=.....,
// SPACE=(....),
// DCB=....
//*

//SYSIN DD *

OUTFIL FILES=(1,2,3,4),SPLITBY=1

/*
//

Is This Answer Correct ?

2 Yes

0 No

Question { L&T, 8428 }

how will u find out 3rd week's 2nd day using occurs ?

Answer

Sweta you cant use WS-TEMP because only the field_name in
the last occurs clause or an element in a level below it
can be used to refer to the table.

So it will be WS-DAY (3,2).

Is This Answer Correct ?

22 Yes

1 No

Question { DSRC, 117067 }

Wrete a JCL to compare two files and mached records move to
onc file & un mached rows wants to another file?

Answer

if u are referring to duplicates...than

//SORTXSUM DD DSN=....
//SYSIN DD *
SORT FILEDS=COPY,
SUM FIELDS=NONE,XSUM

Is This Answer Correct ?

31 Yes

24 No

Question { IBM, 9207 }

Minimum how many Number of Paragraphs are there in ID-
Divison?

Answer

Check out this link:

http://docs.hp.com/cgi-bin/doc3k/B3150090013.11820/32

Is This Answer Correct ?

3 Yes

1 No

Question { HCL, 34915 }

how to fetch multiple records without using cursor

Answer

#6
I think that answer #6 is definately a food for thought.
Logically speaking that's definately possible, but can
anyone verify it practically:-)
I think it should work....nothing wrong in logic.

Is This Answer Correct ?

0 Yes

0 No

Question { CGI, 12667 }

When search all is used in cobol program without sorted
input data?

Answer

I think answer#2 is correct.
But i think the main intention of the question was what if
we dont sort the input data will the Search all work or not
work?

So if this is what intended by the question,than i think
that definately Search all will work but it will give
unpredictable results.

Correct me if i am wrong, in this scenario.

Is This Answer Correct ?

9 Yes

3 No

Question { MAHINDRA, 32173 }

How can we execute only one step in a job

Answer

RE:MR.Ankur is right.

COND=EVEN/ONLY in the jobcard will in anyways execute the
first step.

Is This Answer Correct ?

1 Yes

9 No

Question { 7992 }

How to insert values for variables that are declared as
COMP-3 variables in COBOL program in an already created
VSAM file.

Answer

Did you mean how to insert values directly in the file....

If then open the file directly thru some utility...and edit
the field using HEX OFF option....

Is This Answer Correct ?

1 Yes

0 No