Is it possible to precompile if db2 goes down?
- 4 Answers
- 12891 Views
- Target, I also Faced
- E-Mail Answers
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 |
Is db2 relational database?
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
why we go for SPUFI for creating tables or for sql queries?
how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?
How many Buffer pools are there in DB2 and what are they?
What are the Isolation levels possible ?
What is db2 bind process?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
how to unload different table data into different gdg files/ vsam files.
wht displays the number of times a query modified ?
What are db2 tables?
COBOL 
