IBM MainFrame Interview Questions
Questions Answers Views Company eMail

What is the difference between TYPE 1 index & TYPE 2 index

IBM,

1 12475

What are the disadvantages of using VARCHAR?

3 14081

What is the purpose of the DSNC transaction ?

1 6710

What are delete-connected tables?

1 3558

What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?

4 28546

What is a correlated sub query?

2 4524

What is read-only cursor?

1 5983

What Utility is used to migrate DB2 from one release to the next?

1 4902

What is Skeleton cursor table (SKCT)?

2 12733

Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?

1 5231

What is the database descriptor?

2 13059

What is the syntax required for the creation of a cursor?

1 8584

What is meant by AUTO COMMIT?

3 8884

What information is contained in a SYSCOPY entry?

2 8934

What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?

Emsang,

5 18783


Un-Answered Questions { IBM MainFrame }

Receive consists of buffer option in it. What is the significance of this option?

577


Explain cedf transaction commands?

627


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

707


What is the function of //cntl statement?

832


What are the different dataset organizations used in vsam?

571






Explain the difference between link and xctl?

518


List the type of locks and explain each of them.

536


How to create 1 ddm that fetches 3 adabas files simultaneously?

540


What is the syntax for creating a table in the db2 database?

628


What is a db2 tablespace?

602


What is catelog procedure and how many catelog procedure to use in one job?

7466


how to compare two datasets without using superce because output is limited to 133 bytes

1486


How many maximum base registers we can have in a single program?

639


Name the command used for terminating a browse operation?

576


What is meant by dclgen?

619