File not opened because library is *PROD and debug is
UPDPROD(*NO). ? what may be the reason? how to solve it..?
No Answer is Posted For this Question
Be the First to Post Answer
What is the picture clause of the null indicator variable?
What is cursor stability in db2?
OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?
Give a brief description of db2 isolation levels?
If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation
What are the three DB2 date and time data types and their associated functions?
Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.
Could anyone clearly explain the diference between sub query and correlated sub query?
what is the responsibility of the construction superintendent
in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert
What is difference between rollback and commit?