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 |
For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?
What is usage pointer in cobol?
Explain various types of locks in db2?
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
What is the use of with ur in db2?
What os does db2 run on?
What is the STOSPACE Utility used for?
What is the maximum size of varchar data type in db2?
How can you split a table in to exactly half?
In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?
What is the difference between base table and view?
What is ibm db2 used for?