what is difference between Plan and Package
Answer / swapnil
PLAN IS A EXECUTABLE CODE FOR COBOL.
PLAN IS A COLLECTION OF PACKAGE AND IT IS OUTPUT OF
BIND PROCESS.
PACKAGE: PACKAGE CONTAIN ONE DB REQUSET MODULE(DBRM)
AND IT IS NOT EXECUTABLE MODULE.
| Is This Answer Correct ? | 12 Yes | 2 No |
What will happen, while trying to close the closed cursor.
What is db2 isolation?
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.
When DB2 connection fails, will online program work or give errors.
what is datacom db?
insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
How to connect to db2 database from windows command line?
Explain packages.
Q3. How will you fetch duplicate values from a DB2 table?
What is sqlcode -811?
7 Answers Accenture, CTS, TCS,
Suppose if I need to update a column, how you do that using cursor?
How do you do the EXPLAIN of a dynamic SQL statement?