Can we use select * statement in cobol program without
giving field names ???
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 |
In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?
pls explain the precompilation process of cobol-db2 pgm
What is copy pending status in db2?
Is the primary key a clustered index?
How can you find out the # of rows updated after an update statement?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is meant by AUTO COMMIT?
What technique is used to retrieve data from more than one table in a single SQL statement?
can we update the table by using cursors can anyone post the query?
difference between group clause and order clause
What is dbrm? What it contains?
What is view db2?