1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category
DB2 Interview Questions
Questions Answers Views Company eMail

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?

 2 4083

What is meant by the attachment facility?

 3 8241

What is a Cartesian product?

 2 9165

What is DCLGEN ?

 2 5348

Can we declare DB2 HOST variable in COBOL COPY book?

 2 9409

What's the Maximum Length of SQLCA and what's the content of SQLCABC?

 2 17773

Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?

 1 4794

max number of columns in a db2 table?

 6 22919

Can you access the DB2 Directory table using SQL?

 3 6404

What is correlation names?

 1 3958

What is an alias?

 3 4748

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?

 3 5127

What is the difference between Where and Having Clause

IBM, iFlex,

7 27561

Which transaction use a command thread ?

 1 3086

What is a LIKE table and how is it created?

 2 4508

Post New DB2 Questions

Un-Answered Questions { DB2 }

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

605

What is the role of data manager in the db2 database?

640

What is the maximum size of a char data type in db2?

584

How can deadlocks be resolved?

538

How do you eliminate duplicate values in db2?

679




What is host variable?

590

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

581

What is meant by union and union all?

582

Can you tell me how can you find out the # of rows updated after an update statement?

605

What is db2 stogroup?

673

What is the max length of sqlca?

759

Explain in detail about buffer manager and its functionalities?

558

Name the lockable units in DB2?

661

What is the information associated with sysibm.syslinks table?

657

What is ibm db2 used for?

598

For More Un-Answered { DB2 } Questions Click Here