Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use select * statement in cobol program without
giving field names ???
- 3 Answers
- 11773 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 a DB2 bind?
What is schema in db2?
What is the use of runstats in db2?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
Is db2 a mainframe?
What are packages in db2?
What is a predicate?
I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?
What is the SQL query to select, delete and get count of duplicate rows in DB2?
What is db2 connect?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
what is datacom db?
COBOL 
