Interested to Buy Any Domain ? << Click Here >> for more details...
What is DCLGEN?
- 2 Answers
- 15866 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
DCLGEN is declarations generator that reads the catalog
tables and generates DECLARE TABLE statments and host
language data structures. It ensures that the column data
types and length match the host variables and minimizes the
SQL errors during bind time
| Is This Answer Correct ? | 19 Yes | 3 No |
DCLGEN is a DB2 utility.If we provide table details,it will
generate DB2 structure and host variable structure of the
table.It can also generate NULL indicators for the NULL
columns.This output is stored in a PDS member.These members
are included in the program using the INCLUDE<pds member>.
| Is This Answer Correct ? | 20 Yes | 4 No |
What are bind parameters in db2?
What is a host variable?
What is meant by union and union all?
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
How do I copy a table in db2?
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
What is a lock?
How to create a table using embedded sql?
Can a array declared with an index be displayed(readable format) in spool?
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
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?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
COBOL 
