DB2 Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

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 4903

What is meant by the attachment facility?

3 9210

What is a Cartesian product?

2 10136

What is DCLGEN ?

2 6116

Can we declare DB2 HOST variable in COBOL COPY book?

2 10336

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

2 18720

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

1 5539

max number of columns in a db2 table?

6 24761

Can you access the DB2 Directory table using SQL?

3 7517

What is correlation names?

1 4704

What is an alias?

3 6149

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 6413

What is the difference between Where and Having Clause

IBM, iFlex,

7 30169

Which transaction use a command thread ?

1 3727

What is a LIKE table and how is it created?

2 5347

Post New DB2 Questions

Un-Answered Questions { DB2 }

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

1115

How will you return the number of records in table?

882

What is meant by explain?

1064

What is null value in db2?

953

What is isolation level in db2?

943

How is a typical db2 batch pgm executed?

1110

How to fetch the last row from the table in SQL (db2)?

1590

What is db2 bind?

1019

What is copy pending and check pending in db2?

954

What is cursor in dbms?

1008

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

2316

What is package in db2 mainframe?

923

What is reorg and runstats in db2?

1147

What is db2 command?

965

How do I change the column size in db2?

1084

For More Un-Answered { DB2 } Questions Click Here