Answer Posted / hatam
A package contains control structures used to execute SQL
statements
A plan is
1- A list of package names
2- The bound form of SQL statements taken from one or more
DBRMs
package is executable and plan not
| Is This Answer Correct ? | 0 Yes | 19 No |
Post New Answer View All Answers
When reorg is used?
List down the data types in the db2 database.
What are the two types of logging in the db2 database? Explain them.
How to create backup table in db2?
How do I import a csv file into db2?
What parameters are used to control the free space in DB2?
Explain various types of locks in db2?
what are bind concepts in db2 cobol?
Explain about rct.
How is the value function used?
What is difference between alias and synonym in db2?
When the like statement is used?
What is the role of data manager in the db2 database?
Explain about cursor stability?
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?