Answer Posted / s
The WHERE clause only retrieves the rows based on the
predicate coded in the SQL.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Which are the db2 tools to protect integrity of the database?
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 are the uses of db2 optimizer?
What is the use of with ur in db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is db2 purescale?
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?
What is bind plan?
What is db2 bind?
What is bind package and plan in db2?
What is multi row fetch in db2?
What is cursor with hold option in db2?
How can you find out the # of rows updated after an update statement?
Is db2 a mainframe database?
What is the use of runstats in db2?