What is the command used by TSO users to invoke DB2?
Answers were Sorted based on User's Feedback
What is isolation level?
What does sqlcabc has?
Explain the contention situations caused by locks?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
How do I add a column to a table in db2?
What is difference between *omit and *nopass?
Can we delete records from view?
wt is view ? wht r the restrictions for view ?
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.
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 .....
What is a SELECT statement?
How does coalesce work?