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 |
What do you need to do before you do EXPLAIN ?
Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle
how to fetch multiple records without using cursor
How can you do the explain of a dynamic sql statement?
how to resolve -818 error. how to see timestamp token in load module and plan
What is commit in db2?
What is the command used by TSO users to invoke DB2?
what happend with out using Commit,when closing cursor and program?
I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.
What is the function of logging in the db2 database?
How connect db2 database to datastage?
What is performance tuning db2?