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


MainFrame Interview Questions
Questions Answers Views Company eMail

What is the command used by TSO users to invoke DB2?

IBM,

2 8415

What is the FREE command?

 1 4346

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

 2273

What is DB2 (IBM Database 2)?

 3 4366

What is QUIESCE?

 2 12173

what is the name of the default db2 catalog database?

IBM,

3 7262

What are the three DB2 date and time data types and their associated functions?

 1 4629

What is the significance of DB2 free space and what parameters control it?

 1 4690

Explain the EXPLAIN statement?

 1 4241

What is a DBRM, PLAN ?

 3 17083

What's the maximum number of characters that a tablename can have?

 3 7618

What technique is used to retrieve data from more than one table in a single SQL statement?

CTS, IBM, TCS,

9 12910

can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?

 1 4193

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

 1645

Why use RUNSTAT Utility?

Merrill Lynch,

3 22533

Un-Answered Questions { MainFrame }

how to do automated restart when a job abends?

841

What is data structure in as400? What is the use of data structure?

602

What is role in db2?

612

What are storage attributes of records?

521

Explain the system transid cemt?

586




What are the processing modes available in ims db?

628

What do you understand by psb and acb?

659

What is the pcp in the cics?

522

Service Program : S1 Modules in S1 : M1 M1 having two procedures : ADD, SUB Current Binder Language STRPGMEXP PGMLVL(*CURRENT) EXPORT SYMBOL("ADD") EXPORT SYMBOL("SUB") ENDPGMEXP Doubt: I need to add one new Module to the Service Program M2 having one procedure ‘MULT’ How to add this new module to the service program S1 ? If I need to recreate the service program again, Do I need to mention the Module M1 again while recreating along with new Module M2? There is no Binding Directory. Binder language structure will be like this STRPGMEXP PGMLVL(*CURRENT) EXPORT SYMBOL("ADD") EXPORT SYMBOL("SUB") EXPORT SYMBOL("MULT") ENDPGMEXP STRPGMEXP PGMLVL(*PREVIOUS) EXPORT SYMBOL("ADD") EXPORT SYMBOL("SUB") ENDPGMEXP

1925

using dfu, user will be able to ___________ from physical file?

577

What is meant by a bolt dispute?

823

How to get the ddl of a table in db2?

674

What does a store statement do?

1113

Why is free space left in ksds dataset?

596

Explain in DD statement what is the use of DCB parameter?

652

For More Un-Answered { MainFrame } Questions Click Here