Assuming that a site's standard is that pgm name = plan
name, what is the easiest way to find out which Will
precompile of an DB2-COBOL program bomb, if DB2 is down?
Answer / s
DB2 Precompiler does not require the DB2 to be active. it
does not access the DB2 catalog
| Is This Answer Correct ? | 3 Yes | 0 No |
My SQL is not performing well. Describe how will you fine tune it?
A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?
Is there any advantage to denormalizing DB2 tables?
What is dclgen (declaration generator)?
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??
What is database reorganization?
How do you check for a null value in a db2 column?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is a plan and package in db2?
Mention data types used in db2 ?
I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?
Which catalog table stores referential constraints?