MainFrame Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

IBM MainFrame (5234)
IBM AS400 (1355)
IBM PL/1 (31)

MainFrame Interview Questions

Questions Answers Views Company eMail

Name the different types of Table spaces.

IBM,

5 15635

How do you retrieve the data from a nullable column?

2 8941

What is a clustering index ?

3 7675

Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?

1 7143

How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)

2 9212

What else is there in the PLAN apart from the access path?

1 5358

What is a host variable?

3 7045

In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?

1 10416

Once you create a view, where would information about the view be stored?

1 5158

What information is used as input to the bind process?

2 7559

Can I use LOCK TABLE on a view?

1 6965

Are views updatable ?

4 12868

Give some example of statistics collected during RUNSTATS?

1 5956

What is referential integrity?

5 20143

What is EXPLAIN?

1 6251

Un-Answered Questions { MainFrame }

What are 77 levels used for?

1155

i am using non join multiple format my 3 database file is like that pf97 R REC ENAME ETENNO ESTATUS K ENAME pf98 R REC1 ENAME ESAL K ENAME PF99 R REC3 ENAME CRDCARD EID K EID & MY NON JOIN LOGICAL FILE IS ALSO SAME EXCEPT RECORD NAMES BEFORE I TRIED WITH 2 FILES SO ITS SAYS ERROR I.E.(Key field attributes must be same as for previous formats. ) SO I CHANGED KEYFIELD ACCORDING TO PF SO ITS WORKING BUT AFTER ADDING 3 FILES ITS SAYING SAME ERROR . I DONT KNOW I NEW IN AS400 PLLZ HELP ME I HAVE ONE MORE QUE. CANT BE USE DIFFERENT KEYFIELD (NOT ACCORDING TO PF) IN NON JOIN LOGICAL FILE.

1569

what is the size of the address space in kbs for 16 bit address space?

1166

What is a Foreign Key?

1150

Define a path?

1147

What are s0c1, s0c4, s0c5, s0c7 and socb?

1234

Define cedf?

1021

How to call one program from another program in RPG? please help me with the code

1794

What do you understand by the term job time – out and how can you overcome that?

1098

What is runstats and reorg in db2?

1370

What is the maximum number of pcbs allowed in a psb?

1029

How can you get the ksds file records into your cobol program?

1147

Can you define foreign keys?

1093

Explain the disadvantage of dynamic generation of acb?

999

How do you create a temporary dataset?

1250

For More Un-Answered { MainFrame } Questions Click Here