What is load utility in db2?
No Answer is Posted For this Question
Be the First to Post Answer
When Can you be sure that a query will return only one row?
Can you search give an array in the WHERE clause of a db2 query?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is the information associated with sysibm.syslinks table?
What is the result of open cursor statement?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
How would you find out the total number of rows in a db2 table?
What is a db2 tablespace?
A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?
How will fetch last 5 rows from table in db2
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
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 .....