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

IBM MainFrame (5234)
IBM AS400 (1355)
IBM PL/1 (31)

MainFrame Interview Questions

Questions Answers Views Company eMail

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

3 17619

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 18997

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

4 22254

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 22452

Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?

3 7828

Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?

8 26859

Will the variable POS in the following code have a value of 2 or not? 01 POS PIC S9(4) COMP VALUE 2. 01 FIRST-NAME PIC X(10) VALUE 'ABC'. 01 LAST-NAME PIC X(10) VALUE 'XYZ'. 01 NAME PIC X(20) VALUE SPACES. STRING FIRST-NAME DELIMITED BY SPACES ' ' DELIMITED BY SIZE LAST-NAME DELIMITED BY SPACES INTO NAME WITH POINTER POS

2 4896

What is the difference between CALL BY VALUE and CALL BY CONTENT?

7 27629

is it possible to pass an SQL query inside a jcl which is inside a cobol program?

CTS,

5 14388

INCLUDE is used ONLY on MVS/ESA Version 4 or higher systems to name an INCLUDE group. An INCLUDE group is a set of one or more valid JCL statements that are stored together in a JCLLIB data set or a system procedure library, and that are read in and used to replace the INCLUDE statement itself within the job. Any number of INCLUDE statements can be used in a job, but the name field value used on each should be unique within the job. The INCLUDE statements can appear in a job anywhere after the JOB statement, but may not appear between a CNTL and ENDCNTL JCL statement.

2240

can we create PS file using IDCAMS utility?

IBM,

3 13880

What is the difference between PS file and VSAM file?

IBM, Infosys, Verizon,

7 40429

What are all the ways we can create datasets?

IBM,

7 13204

Which keyword is used both in subfile and subfile control record format of a DSPF?

8 17867

CRTDTA AND CRTARA should be used along with?

2 8082

Un-Answered Questions { MainFrame }

What is the use of KSDS,LDS,ESDS,RRDS??what is VRRDS?? How are all these useful in realtime scenario??Plz helpme out...Its a recent question in IGATE..

8759

what is use of disp parameter in dd statement?

1102

How to debug a batch job when it is in messagewait(mswg) status. I know the steps for batch ebugging, but im confusing with when we submit any job for batch debug we put in held state. So here also do same thing or any other way?

1273

What is DEQ?

1046

Suppose I have a pf,it contains 5 members,how to access particular member data from logical file ?and what is the use of member in pf?

1055

Explain the difference between a return with transid and xctl? For example program. A is issuing return with transid to program b. Program a. Is isssuing xctl to program b?

1049

Is it possible to left uncode disp? If yes, how?

1193

how many printer files maximum can be used in single rpg program?

1195

What is the main function of key-sequenced data set?

1025

In a test environment, is there a need to run a runstats?

971

What types of tables are there in the db2 database?

1061

when is a tag statement used in rpg?

2245

If DB2 query returns in null value, how do you work with it in PL/1?

2364

Explain how many conditions can you include in a single handle condition command?

1034

How can you quickly find out the # of rows updated after an update statement?

1049

For More Un-Answered { MainFrame } Questions Click Here