MainFrame Interview Questions
Questions Answers Views Company eMail

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

IBM,

2 8425

What is the FREE command?

1 4354

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

2282

What is DB2 (IBM Database 2)?

3 4373

What is QUIESCE?

2 12184

what is the name of the default db2 catalog database?

IBM,

3 7282

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

1 4644

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

1 4702

Explain the EXPLAIN statement?

1 4249

What is a DBRM, PLAN ?

3 17104

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

3 7635

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

CTS, IBM, TCS,

9 12981

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 4200

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?

1648

Why use RUNSTAT Utility?

Merrill Lynch,

3 22557


Un-Answered Questions { MainFrame }

Particular area has been affected in cics screen, what is the process to find?

8559


Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

626


How can record locking be achieved in those DB2 versions which do not support it?

627


What is meant by batch dl/i mode?

584


Suppose I want to code a rexx program in order to get the inputfile and output files of jcl. I want code snippet or the coding for this?

528






Explain this error: "all record formats for externally-described file abcd ignored or dropped due to error; file ignored."?

758


What Is The Error If We Don't Get Login Screen?

681


Define autostatus in idms?

487


Is the order of the when clause important in an evaluate statement? Is the order of the when clause significant in an evaluate statement?

569


Tandem COBOL Interview questions (on TACL,SCOBOL,ENSCRIBE,PATHWAY0

22829


WHAT IS AS/400 SYNORIO?

2890


What are the various section in data division and briefly explain them.

700


how do u compile rpgle program?

628


Explain how will you differentiate between an internal and an external sort, the pros and cons, internal sort syntax etc

825


How to run cobol program using jcl?

655