Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / s
Dynamic SQL are built at execution time. Dynamic SQL does
not go through the program preparation process like static
SQL and can execute different SQL statements in one
program.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is blu acceleration in db2?
What are the uses of db2 optimizer?
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 .....
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
Explain about rct.
What is a storage group (stogroup)?
Which component is used to execute the sql statements?
what is the sqlcode -501
is it compulsory commitment control in journal?
On which levels locks can be applied?
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 dclgen in db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
How does a cursor work?
What is the difference between drop table and delete table?
