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

What is the SQL query to select, delete and get count of duplicate rows in DB2?

2 9268

Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?

1 5087

If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?

6 8689

What is the difference between Primary key and unique index?

6 10262

My JCL have five steps & I created new versions of GDG in first step through fourth step & fifth step I was refered Step one GDG version. My JCL got abend at 4th step and how I can restart my JCL Please let me know the answers. //STEP1 EXEC GDG1(+1) DISP=(NEW) //STEP2 EXEC GDG1(+2) DISP=(NEW) //STEP3 EXEC GDG1(+3) DISP=(NEW) //STEP4 EXEC GDG1(+4) DISP=(NEW) //STEP5 EXEC GDG1(+1) DISP=(OLD)

HCL, IBM, L&T, TCS,

11 57465

How many types of parameters are used in JCL and what are mandatory parameters of JOB statement.

IBM,

13 27582

What is the use of a COPYBOOK in Fileaid ?

Steria,

4 11861

Looking for mainframes IMS DB training @ 9912598882

3 7284

why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2

3 9023

What is package versioning? Please give an example.

1 4801

Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)

2 6349

What is the difference between the NOHANDLE option and the IGNORE condition?

3 17606

In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?

Syntel,

8 18958

What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?

4 22236

Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?

6 22414

Un-Answered Questions { IBM MainFrame }

is oorexx compatible with ibm object rexx?

987

What is meant by PPT and what are its uses?

1096

What is dynamic transaction backout?

1130

Define predicate?

1125

Discuss about changing dataset name in proc.

1230

How ENQ and DEQ used in CICS?

1436

Why occurs cannot be used in 01 level in COBOL?

1156

What is the function of a dd statement?

1200

What is amode(31)

1168

Define pcb?

1079

What is rct?

1227

What is iseries database?

1046

Explain control variable in online screens?

997

What is NOTCAT ?

1320

What is mainframe computer /system?

1019

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