Interested to Buy Any Domain ? << Click Here >> for more details...
What is DCLGEN?
- 2 Answers
- 15648 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 |
Is db2 a database?
1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
What is an alias?
How to find the number of rows in db2 tables?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What are bind parameters in db2?
What does sqlcabc has?
How is the SUBSTR keyword used in sql?
What are some characteristics of columns that benefit from indexes?
How is a typical DB2 batch program executed ?
What is the difference between nvl and coalesce?
COBOL 
