Sign Up Login


  1. Categories >> Software >> MainFrame
  2. Suggest New Category


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 4952

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

Cap Gemini,

2 24476

what is edit word and edit code

Cap Gemini,

2197

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

Cognizant,

3 8015

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

Cognizant,

3 7648

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 8098

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

Cap Gemini,

8 10856

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 12822

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

Mphasis,

2015

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

 1 4509

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

Cap Gemini,

2 5925

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 12560

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

Cap Gemini,

4 9668

I need exexution process for JCL programs

 2022

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

Cap Gemini,

1 6205

Un-Answered Questions { MainFrame }

name the command that is used to dump the main storage areas related to a task?

833

What is a SSRANGE and NOSSRANGE?

1104

How can a like table be created?

713

Can any one explain the basic things about RLU and Printer Files and their Definitions for both and why are they used,i'm a newbee so please help me out

3118

Categorize the mainframe manual testing?

726

What is null indicator in cobol db2?

765

How is record management performed in vsam?

805

how to pick up the changed records every time in a subfile after the first change made ?

1425

how will you find a string using pdm?

898

what is the use of IEBGENER utility?

868

What is database alias db2?

819

how could you write a program in a structured format?

752

What is the difference between perform … with test after and perform … with test before?

1143

how do you specify the number of records to roll in a subfile ?

1670

What is the pic clause for the data type of length option field type of data fields?

720

For More Un-Answered { MainFrame } Questions Click Here