Name some fields from SQLCA.
Answers were Sorted based on User's Feedback
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
how to resolve -811 error. give clear explination
What does the sqlcode of -818 pertain to?
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA
What are the different types of base tables?
what is the use of bind parameter, Replace?
pls explain the precompilation process of cobol-db2 pgm
How can you count the number of rows from a table tab?
Explain the contention situations caused by locks?
What is a cursor in programming?
What is a clustering index?