Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use select * statement in cobol program without
giving field names ???
- 3 Answers
- 11701 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 |
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
How do I delete a column in db2?
what is difference between Plan and Package
Why do we need reorg in db2?
What is dbrm library?
can any one give the list of some important sql abend codes which r frequently asked in interviews?
how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures
What are the three DB2 date and time data types and their associated functions?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is buffer pool and list some of them?
What do you mean by rollback?
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
COBOL 
