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

Explain the use of the WHERE clause.

IBM,

2 5453

What is index cardinality?

3 11031

How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?

IBM, Tech Mahindra,

2 12128

What are the three types of page locks that can be held?

1 4619

What is the meaning of -805 SQL return code?

3 12822

What is a base table?

2 4880

what's the best lock size that you could use when you create a tablespace?

IBM,

2 5933

How would you print the output of an SQL statement from SPUFI?

2 8848

What is the STOSPACE Utility used for?

1 6536

Where besides the DB2 catalog is database object information stored by DB2?

1 4981

What is isolation level?

4 7297

What is a predicate?

1 4794

What is ALTER ?

3 6891

What do you need to do before you do EXPLAIN?

1 5257

How do you insert a record with a nullable column?

2 6290

Un-Answered Questions { MainFrame }

When we have a file with Duplicate records and I want to read the unique record from the file. For example a file containing Emp Name as 'Ram' and there are 3 entries of it. So how to read a unique record from File?

966

Can we update view in db2?

1007

why is there no os/2 (ecs) port of oorexx?

1005

What is the term bms in cics?

1224

OPEN INPUT StudentFile READ StudentFile AT END SET EndOfStudentFile TO TRUE END-READ PERFORM UNTIL EndOfStudentFile DISPLAY StudentId SPACE StudentName SPACE CourseCode SPACE YOBirth READ StudentFile AT END SET EndOfStudentFile TO TRUE END-READ END-PERFORM CLOSE StudentFile STOP RUN what will be output

2515

what does check opcode do ?

1875

Particular area has been affected in cics screen, what is the process to find?

9900

Can level check error occur if we do chgpf?

1258

What are db2 objects?

1053

Explain how can the attributes of one sms dataset be copied to another dataset?

1219

What is the difference between iter and do? We know both are used to execute set of statements repeatedly, but what is the main difference?

1029

I just know the Panvalet dataset name, i would like to search all the members of that dataset for particular keyword through Rexx. how to achive? please suggest. Is it possible to open panvalet member in browse mode using Rexx? Your help would be appreciated very much. Thanks in advance.

5567

How can you count the number of rows from a table tab?

1093

How can you submit a job through cobol program?

1537

What is the physical storage length of time data type?

1133

For More Un-Answered { MainFrame } Questions Click Here