What are the contents of a DCLGEN?
Answers were Sorted based on User's Feedback
Answer / s
DCLGEN reads the catalog tables and generates DECLARE TABLE
statements and host language data structures that are used
to receive the data. These DECLARE TABLE statements are
used by the precompiler to check the syntax of the SQL
statement.
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / ramesh naidu
It contains the db2 equalent cobol variables called host variables
| Is This Answer Correct ? | 3 Yes | 0 No |
What is a db2 cursor?
What is the cobol picture clause of the db2 data types date, time, timestamp?
Is schema the same as database?
How do I start db2 in windows?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
How to find last record before record through SQLRPGLE?
What is a page?
What is the syntax for FETCH in DB2 ?
WHAT IS MEANT BY COMMIT COMMAND?
When can an insert of a new primary key value threaten referential integrity?
how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...
What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.