Is it possible to precompile if db2 goes down?
Answers were Sorted based on User's Feedback
Answer / i-tek
Yes. Because the precompiler does not refer to the DB2
catalogue tables.
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / ram
100 % correct. During pre-compile, DB2 doest not required
to be up. Because it wont refer any DB2 catalog tables....
its does a basic syntax checking by referring DB2
DECLGEN....
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / kranthi kumar
while bind step takes place, definitely db2 should be up.
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / reddy kanupuru
Yes. DB2 need not be up during precompilation stage. at
that stage DB2 will get the info about tables using DCLGEN
not from the tables
| Is This Answer Correct ? | 1 Yes | 3 No |
Can SQL statements/queries be included in a copybook?
what is the role of the cursor in db2?
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
What is buffer pool in the db2 database?
Explain in brief how does db2 determine what lock-size to use?
What is the SQL Communications Area and what are some of its key fields?
What is concurrency?
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
What is a plan and package in db2?
how can we find nth max salary from A table
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
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?