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