Answer Posted / abhishek singh
DECLARE TABLE, that is table structure of DCLGEN is NOT really needed for pre-compilation. But if it is used, then any misspelled table name, column names are trapped in pre-compilation stage itself.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is lock escalation in db2?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
How to execute stored procedures?
What is the physical storage length of the data types date, time, and timestamp?
Differentiate between cs and rr isolation levels? Where do you specify them?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
How many databases are there?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is db2 optimizer?
What is cobol db2?
what is utility for parm lib
Explain packages.
What is ibm db2 used for?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
When do you specify the isolation level?