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 4282

What is meant by the attachment facility?

 3 8468

What is a Cartesian product?

 2 9491

What is DCLGEN ?

 2 5541

Can we declare DB2 HOST variable in COBOL COPY book?

 2 9628

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

 2 18075

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

 1 4963

max number of columns in a db2 table?

 6 23379

Can you access the DB2 Directory table using SQL?

 3 6705

What is correlation names?

 1 4122

What is an alias?

 3 5030

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 5403

What is the difference between Where and Having Clause

IBM, iFlex,

7 27990

Which transaction use a command thread ?

 1 3234

What is a LIKE table and how is it created?

 2 4739

Post New DB2 Questions

Un-Answered Questions { DB2 }

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

733

Mention the downsides of page level lock.

812

What is the difference between cursor stability and repeatable read isolation levels?

774

What is explain in db2?

653

What is the information associated with sysibm.syslinks table?

754




What is dclgen (declaration generator)?

694

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

831

what are bind concepts in db2 cobol?

730

Mention the definition of cobol in varchar field.

776

Can one database have multiple instances?

661

Why do we need reorg in db2?

642

What is meant by union and union all?

668

How can we read records for specific member in CL? AND rpg?

322

What is universal database?

714

Why do chiropractors use drop table?

774

For More Un-Answered { DB2 } Questions Click Here