How to check last update on table in db2?

1059

How to test SQL -911 error while developing COB-DB2 program

7565

Give a brief description of db2 isolation levels?

1072

Explain what are the various isolation levels possible?

1044

Explain how can you do the explain of a dynamic sql statement?

1125

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

700

What is check constraint in db2?

1087

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

2852

What does db2 stand for?

1025

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1194

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1278

What is the clustering index in the db2 database?

1001

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 .....

2365

Is db2 a programming language?

1048

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9200