COBOL PRECOMPILER ERROR:
"XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED
DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL
STATEMENT.
WHAT COULD BE THE PROBLEM?
Answer / praveen kumar
ensure that u hv included dclgen members before executing
any query or using table name anywhere in the program
Is This Answer Correct ? | 2 Yes | 2 No |
quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th
why should we bind the DB2 program . What if we did not BIND a BD2 program ??
9 Answers Infosys, TCS, Xansa,
What is bind and rebind in db2?
What r the comman abends in db2, jcl and cobol???????
How to find the number of rows in a db2 table?
What is Skeleton cursor table (SKCT)?
How does a cursor work?
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
what is a collection?
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?
Update command
what are the SQL codes u freequently got?