MainFrame Interview Questions
Questions Answers Views Company eMail

Explain the use of the WHERE clause.

IBM,

2 4184

What is index cardinality?

3 9641

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

IBM, Tech Mahindra,

2 10409

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

1 3891

What is the meaning of -805 SQL return code?

3 11226

What is a base table?

2 3877

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

IBM,

2 4860

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

2 7534

What is the STOSPACE Utility used for?

1 5771

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

1 4241

What is isolation level?

4 5685

What is a predicate?

1 3967

What is ALTER ?

3 5620

What do you need to do before you do EXPLAIN?

1 4436

How do you insert a record with a nullable column?

2 5247


Un-Answered Questions { MainFrame }

Why we are not able to perform insert delete and update operation in Join logical file?

933


How to Clear a Query Using the RESET Command ?

1208


If we say that bms length of field = 0, then what does that mean?

727


Difference between array and sub-script ?

1157


What are all the divisions of a COBOL program?

660






How dummy is used in jcl?

643


what is the difference between sflclr and sflinz?

1031


How to Get Information About the Tables?

1179


Why are you looking for a change?

539


What is meant by a ‘Transid’ ?

627


if we have " ibm mainframe ",in that how to remove first and last leading space eg:"ibm mainframe" like that the answer we need

851


Suppose you are processing an input file in a natural program and you want the program to fail if the file is empty. What command you use in natural to force it to fail?

572


Can you define aica abend?

682


List the type of locks and explain each of them.

530


How to pass the parameter in parm using linkage section ? (syntax)?

645