MainFrame Interview Questions
Questions Answers Views Company eMail

db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above. 1 What is the maximum number of tables that can be stored on a Partitioned Table Space ? 1 what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names Accenture 5 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 When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing? 2 how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE IBM 7 max number of columns in a db2 table? 6 What is package versioning? Please give an example. 1 What is the picture clause of the null indicator variable? 6 How do you filter out the rows retrieved from a Db2 table ? 1 What is DB2 (IBM Database 2)? 3 Can any one tell me about Restart logic in DB2.

Cap Gemini,

2 4462

WHY LRECL NEEDS TO BE 4 EXTRA THEN THE COBOL FILE LENGTH & WHAT IT CONTAIN IN THAT LENGTH

Cap Gemini,

2 23716

what is edit word and edit code

Cap Gemini,

1967

A job has 90 steps i want to execute only step7 and step15

Cognizant,

3 7461

A job has 150 steps i want to execute only 57th step

Cognizant,

3 7207

oza017.myorg.emp has 100 records ,oza018.myorg.staff has 200 records but 50 are the common records in both files copy all the common records into oza017.myorg.xyz dataset

Cognizant,

3 7538

if a pic 9(3) value 354,b pic x(2) value '46' then a)a>b 2)a

Cap Gemini,

8 9871

How can I override a dsn that is contained in a proc called by another proc? I need to do the override in the calling JCL.

3 12201

What r the comman abends in db2, jcl and cobol???????

Mphasis,

1820

what is diffrence b/w file-aid tool and file-aid utility???

1 4183

Hi, can any one tell about " How do u eliminate the duplicates "

Cap Gemini,

2 5442

How To get the last record in VSAM file in cluster? and How can u get the ksds file records into ur cobol program ? Pls tell me about these two questions.

Cap Gemini,

1 11981

How do define Dymanic array in cobol how do u define single demensional arry and multidymensional arry in ur cobol.

Cap Gemini,

4 8980

I need exexution process for JCL programs

1853

1)what is use of linkage section? 2)what is difference between comp and comp-3

Cap Gemini,

1 5878


Un-Answered Questions { MainFrame }

How are the next sentence and continue different from each other?

766


What is acbgen process?

696


Name the three ways available for a program to position the cursor on the screen?

594


What is difference between bind by copy and bind by reference?

1734


Define temporary storage?

607






how do you execute a background cics txn ?

828


What do you understand by jcl?

631


Define buffer pool.

628


B37 abend during spufi?

983


what keyword must be used with protect keyword ?

1131


a set statement is used to define commonly used symbolic across job steps or procedures. It initializes the previous values in the symbolic names. It has to be defined before the first use of the symbolic names in the jcl. State whether true or false?

622


Name and explain the type of locks?

558


Explain the difference between the into and the set option in the exec cics receive map command?

562


how do you reference the esds vsam file formats from cobol programs

634


Explain the function of entry-sequenced data set?

536