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 17761

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 19296

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

4 22428

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 22665

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 7937

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 27145

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 5005

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

7 27954

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

CTS,

5 14602

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.

2314

can we create PS file using IDCAMS utility?

IBM,

3 14014

What is the difference between PS file and VSAM file?

IBM, Infosys, Verizon,

7 40756

What are all the ways we can create datasets?

IBM,

7 13431

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

8 18145

CRTDTA AND CRTARA should be used along with?

2 8196

Un-Answered Questions { MainFrame }

What is icm instruction?

1123

How do you define an altindx?

1089

Explain difference between read(1) and read work file once?

1020

what are the different types of arrays available in rpg ?

1803

what are the various types of device files?

1753

Explain the difference between and exec cics xctl and exec cics start command?

1233

how can you detect and handle a record lock situation?

2069

Explain how can the submitting users racf authority be overridden in a job stream?

1194

What tools are available in PL/1?

1573

What is schema in db2?

1084

i want to maintain uniqueness on pdf without make lf??????????

2211

If my rpg program has a date field, what extra care I have to take while compiling that rpg program? If the file is keyed and I have declared the file as well as key list properly in my program. Still am getting an error message like "chain/reade operation is not allowed" what may be the case?

1172

What are the information stored in ci?

1070

What is scrollable cursor in db2?

1128

What is query_cache_limit?

1038

For More Un-Answered { MainFrame } Questions Click Here