Can we use select * statement in cobol program without
giving field names ???
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / guest
Shouldnt the code be changed to handle the new column that
would be returned by the SELECT *...
| Is This Answer Correct ? | 0 Yes | 2 No |
what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
What are union and union all?
How would you find out the total number of rows in a db2 table?
db2 restart logic ?
What is db2?
Mention data types used in db2 ?
Are views updateable?
How can record locking be achieved in those DB2 versions which do not support it?
What is the difference between IN subselects and EXISTS subselect?
What is universal database?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is dpf in db2?