Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use select * statement in cobol program without
giving field names ???
- 3 Answers
- 11886 Views
- Zensar, I also Faced
- E-Mail Answers
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 is consistency token
Comment whether the cursor is closed during commit or not.
How do you check for a null value in a db2 column?
What is query_cache_limit?
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process
What is nvl in db2?
What is null indicator in db2?
what is diffrence b/w file-aid tool and file-aid utility???
What is copy pending status in db2?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
Explain the function done by data manager?
COBOL 
