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
Why do we bind in db2?
Explain db2.
How to take backup of table in db2?
How to fetch the last row from the table in SQL (db2)?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
Give a brief description of db2 isolation levels?
What is precompiler in db2?
How does db2 sample database connect?
How to test SQL -911 error while developing COB-DB2 program
What is scrollable cursor in db2?
How many types of page locks can be held in db2?
What is check constraint. Explain with example.
Explain about dbrm.
What is the physical storage length of timestamp data type?
Define db2.