Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use select * statement in cobol program without
giving field names ???
- 3 Answers
- 11763 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 syscat in db2?
wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?
What is the difference between SYNONYM and ALIAS?
What is IMAGECOPY ?
Where can you declare a cursor in a cobol-db2 program?
Explain in detail about buffer manager and its functionalities?
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?
2 Answers Tech Mahindra, Wipro,
What are some SQL aggregates and other built-in functions?
How to know the primary key of a table without defining the primary key in the table?
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
what is the sqlcode -501
COBOL 
