IBM MainFrame Interview Questions
Questions Answers Views Company eMail

Name the different types of Table spaces.

IBM,

5 13462

How do you retrieve the data from a nullable column?

2 7527

What is a clustering index ?

3 5996

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

1 5995

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 8024

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

1 4475

What is a host variable?

3 5593

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 9467

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

1 4324

What information is used as input to the bind process?

2 6245

Can I use LOCK TABLE on a view?

1 6168

Are views updatable ?

4 10210

Give some example of statistics collected during RUNSTATS?

1 5135

What is referential integrity?

5 18205

What is EXPLAIN?

1 4855


Un-Answered Questions { IBM MainFrame }

What is runstats db2?

559


When will a port of ooRexx to "XYZ" be available?

504


Name the cics command that gives the length of twa area?

551


Expalin about Ibm frameworkinh working & is it platform independant & open source?

1621


What is the difference between ooRexx and IBM's Object REXX for Windows?

522






Can I combine uni-REXX with a compiled language in my application? What application programming interfaces are available? For example, can I share variables between uni-REXX and a compiled language?

520


What os does db2 run on?

557


If I have limited experience with Rexx or it's been a long time since I've used it, what kind of help is available to get me started?

523


Suppose I have a program in cobol name ”careerride” and want to execute the program by jcl. Specify the process?

642


how can you copy to a vsam cluster?

611


Explain the three location modes?

484


What are the cobol coding sheets?

637


What is the use of the eibaid field?

589


What is the meaning of copy idms subschema-binds in idms?

490


Is ibm db2 open source?

561