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 the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?
How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement
Where do you specify them?
What do you mean by rollback?
What is index in db2?
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
How can you quickly find out the number of rows updated after an update statement?
What is the SQL query to select, delete and get count of duplicate rows in DB2?
In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?
What is iseries database?
what is dynamic cursor?gives syntax for this?
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?