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 types of copies can be made with the COPY Utility ?
what is the input to PLAN? what is the input to DBRM?
how can u nderstand the sql stmts executed successfully or not ?
What is sqlca?
How to design maps
what is the maximum number of tables that can be joined ?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is FREEPAGE and PCTFREE in TABLESPACE creation?
Where do you specify them?
Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?
What is DCLGEN?
How to fetch the last row from the table in SQL (db2)?