What is DCLGEN ?
Answers were Sorted based on User's Feedback
Answer / naveen87ginjupalli
DcLGEN is Declaration Generator generates DB2 equalent
cobol variables called Host Variables.
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / girish kumar
DCLGEN is one of the db2 UTILITY.
which is used to create host varibles.
when we provide tabel details to the DCLGEN, DCLGEN will
create host-varible structure in a saparate PDS Member.
That host variable are used to communicate application
program(COBOL) and database(DB2)
| Is This Answer Correct ? | 4 Yes | 0 No |
What are host variables in db2?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
Which component is responsible for db2 startup and shutdown?
Is it mandatory to use DCLGEN? If not, why would you use it at all?
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
Explain about dbrm.
How to compare data between two tables in db2?
What is the difference between cursor stability and repeatable read isolation levels?
What is db2 instance?
How does DB2 use multiple table indexes?
Define check constraint.
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'