Is Cursor exicutable ?
Answers were Sorted based on User's Feedback
Answer / narayana reddy
expect declare cursor remaining all are
executables(open,fetch,close)
| Is This Answer Correct ? | 15 Yes | 0 No |
What is meant by a unit of recovery?
What are the various locking levels available?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is the difference between SYNONYM and ALIAS?
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 RUNSTATS?
What is the FREE command?
What is clone table?
What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?
what are the SQL codes u freequently got?
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
What do you need to do before you do EXPLAIN?