Can we insert update delete in view?
DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language
How can deadlocks be resolved?
What is host variable?
can any one expalin check point with an example?
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
How to find schema of a table in db2?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is the advantage in De-normalizing tables in DB2?
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
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
What is cascading rollback?
What is a DB2 catalog?