MainFrame Interview Questions
Questions Answers Views Company eMail

What is db2 command?

574

What is a system catalog table in db2?

569

How to create db2 table in mainframe?

617

What is bind package and plan in db2?

578

What is ibm db2 database?

524

What is nvl in db2?

614

What happens in bind step in a db2 program?

557

What is ibm db2 connect?

560

What is database manager in db2?

537

What does reorg do in db2?

565

What is blu acceleration in db2?

590

What is multi row fetch in db2?

590

What is dpf in db2?

653

What does db2 blu stand for?

650

What is phantom read in db2?

627


Un-Answered Questions { MainFrame }

have in 100 records in a file i want to read first 3 records and skip next 3 records and agan i want to read 3 records and again i want to skip 3 records... run a loop from record one to 10 evaluate i/3 if comes even then skip else write to output file

910


what is a jcl?

675


What is the distinction amongst include and copy?

513


Are there any set of rules for the names of the steps used in a job?

616


difference between view and index ?

691






What is need of start 0?

643


What is cobol coding sheet?

706


What does db2 plan contain?

567


I need to compare 3 variables(dates) and do some processing based on the earliest date. There could be more then 1 date record in any of the 3 fields. What is the best way to code this?

1792


how to define a directory and what is the structure and definition for the same?

609


Can anybody tell what is tool used to generate the list of PROCS used in JCL to generate a PROCTREE

1953


What is the binary search?

531


what disp parameter we mention for creation of temporary dataset so that we can use it in later steps?

642


How does coalesce work?

571


Apart from opening of a file do we have any other use of USROPN?

945