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 |
List down the data types in the db2 database.
What is the syntax of SELECT statement when embedded in a COBOL program?
Which catalog table stores referential constraints?
What is dbrm in db2 database?
Can you access the DB2 Directory table using SQL?
What kind of database is db2?
There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........
Explain the contents that are a part of dclgen.
what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI
What is copy book?