Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use select * statement in cobol program without
giving field names ???
- 3 Answers
- 11899 Views
- Zensar, I also Faced
- E-Mail Answers
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
What is the cobol picture clause of the db2 data types date, time, timestamp?
What are union and union all?
Define db2 and its databases?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
Which component is responsible for db2 startup and shutdown?
How do I create a view in db2?
Define buffer pool.
Explain about cursor stability?
What does db2 stand for?
How to take backup of table in db2?
Which component is responsible for processing sql statements and selecting access paths?
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
Is ibm db2 open source?
How many types of page locks can be held in db2?
can we view the access paths created by dbrm ? how ? thx
