IBM MainFrame Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

COBOL (1072)
JCL (1031)
CICS (755)
DB2 (1122)

IMS (143)
IDMS (107)
Natural (81)
ADABAS (26)

REXX (60)
Assembler (68)
CLIST (6)
QMF (32)

MVS (25)
OS390 (10)
OS 2 (7)
VSAM (319)

IBM MainFrame Interview Questions

Questions Answers Views Company eMail

if my GDG limit has been kept as 50 and if am trying to put 60 records.what would happen. will there be any abend for this scenario

4 9973

a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.

3 7987

in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.

iGate,

2 9089

Suppose you are adding a new field in a map, and that field should also be added as a new column in DB2 table. How do you implement this? what is the impact analysis u will do?

Thomson,

2 8092

Suppose your program is reading a Sequential Vsam file. The file contains 10 records. How will you code the JCL to read only 2nd, 5th, 7th,and 10th record?

Thomson,

1 8525

I've one sequential file, that file size is LREC=100 (File contain Records like 1 to 100). Now I was increase the file size is LREC=102. My question is I want insert 00 (Two Zeros) in to the new file (That output file looks like : 00123 up to 100). How will write the SORT card in JCL. Please let me know.

Syntel,

2 11781

I've one string with spaces ( I N D I A ). My question is I want remove the spaces & combine in to single string without space (INDIA).How we can write the cobol program & wich options we need to use. Please let me know.

Mascon,

10 22998

What are the parameter in the job card wihtout which job won't run........

IBM,

10 22205

how can count the number of character in feild ?? suppose for instance i have a feild with value ' rajesh sarkar' then how can v count the number of characters whitout spaces...........

Wipro,

4 10844

how can we find nth max salary from A table

IBM,

5 26319

how to take the back up of the DB2 table.

7 22105

I encountered an error when I move spaces to a numeric field?What should I do to move spaces on that field?help please.

9 13288

Please let me know at which Scenarios we will go for STATIC call or DYNAMIC

IBM,

3 7564

In A cobol program , we can use COPY Statement in FILE- SECTION / WORKING-STORAGE SECTION / ENVIRONMENT DIVIION basically what is the difference

IBM,

3 11171

Can a array declared with an index be displayed(readable format) in spool?

Syntel, UST,

4 7682

Un-Answered Questions { IBM MainFrame }

What is role in db2?

1168

List down the types of triggers in the db2 database?

1085

Explain how can the disposition of sysout datasets be set for an entire jobstream?

1154

which is more efficient, level 77 or 01?

1107

What do you understand by the terms: joblib and steplib?

1264

How are you going to remove duplicates from the file that is being read?

1058

What is null indicator in cobol db2?

1119

Can we use procopt on pcb and segment field (senseg)?

1041

how to move the records from file to array table. give with code example

2737

What is difference between rollback and commit?

1219

Explain how you can characterize tables in cobol?

1118

How do I create a view in db2?

1087

without jcl how to run the batch programs

2590

How do I import a csv file into db2?

1046

How to Provide Column Names Using the DRAW Command ?

1586

For More Un-Answered { IBM MainFrame } Questions Click Here