IBM MainFrame Interview Questions
Questions Answers Views Company eMail

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

16

Discuss about db2 bind?

20

List out the data types available.

15




Define sqlca.

16

Explain packages.

15

Mention the definition of cobol in varchar field.

20

Explain the function done by data manager?

16

Define buffer pool.

17

Outputs of explain are with matchcols = 0. What does this signify?

10

Explain in detail about buffer manager and its functionalities?

15

Mention the various locks that are available in db2.

15

Explain about dbrm.

11

Can I redefine an x(200) field with a field of x(100) ?

13

What is comp-1?

9

How many bytes will a s9(8) comp field occupy ?

11







Un-Answered Questions { IBM MainFrame }

Brief description of inline procedure of jcl.

3


Suppose if there are a set of statements and each has a word “value” in it, if I want to display all these statements so that the word “value” is aligned, then how do I code this in rexx?

16


With the use of an alternate index, how is a VSAM file accessed?

16


How to submit jcl through a cobol program?

3


in order to execute step2 a job after a return code of 8 in step1, what condition you will code in step2?

18






suppose I have two tables a and b. Both tables are connected with ssn number as foreign key. I want to retrieve a column data from b table. How will you write a query?

17


Why is free space left in ksds dataset?

8


explain sorting techniques in cobol program?

3


what is the meaning of a (new, catlg, keep) disposition mean?

18


What is concurrency?

19


which cics service transaction is used to gain accessibility to cics control tables? Mention the one that has the highest priority.?

19


Highlight the difference between a symbolic map and physical map?

20


what are the types of abends that occur on job failure? And explain the possible causes of these

504


What is an ook-rec in idms?

3


What are all the divisions of a COBOL program?

15