Can we use select * statement in cobol program without
giving field names ???
Answer Posted / vish
Yes we can do it but as a practice people don't use "SELECT
*..." in COBOL program. Possibly the main reason for this
is that if there is any modification to the table in future
(e.g. a column addition) then all such programs needs to be
at least recompiled once even if there is no code changes
into them. This is ensure taht they use latest DCLGEN for
the modified table else the programs will abend for column
mismatch.
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
Can we update view in db2?
What is bind and rebind in db2?
What is the difference between plan and package in db2?
What is rebind in db2?
Mention data types used in db2 ?
How does db2 sample database connect?
What are types of indexes?
Explain in detail about buffer manager and its functionalities?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is db2 optimizer?
Which component is used to execute the sql statements?
What is db2 stogroup?
How can deadlocks be resolved?
How to restart a DB2 program?
What are the benefits of using the db2 database?