Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use select * statement in cobol program without
giving field names ???
- 3 Answers
- 11759 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 |
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
How to take backup of table in db2?
There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
When is the authorization check on DB2 objects done - at BIND time or run time?
How to design maps
What is the use of with ur in db2?
my project is insurance management system,how to explain my work environment in interview?
Define db2 and its databases?
How to resolve -818 sql code in DB2?
Name some fields from SQLCA
What is buffer pool and list some of them?
COBOL 
