What is read-only cursor?
Answer / s
Read-only cursor is a cursor that is defined with FOR FETCH
ONLY clause. The curosor is defined with SELECT, SELECT
INTO.
| Is This Answer Correct ? | 2 Yes | 4 No |
How can we retrieve the total number of records in RPG & CLLE?
How to access db2 tables in mainframe?
How to fetch the last row from the table in SQL (db2)?
What is a DBRM, PLAN ?
How do u achieve record level locking in DB2 versions when record level locking is not allowed?
What is referential integrity?
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?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Can we declare DB2 HOST variable in COBOL COPY book?
What is runstats db2?
wt is view ? wht r the restrictions for view ?
What is the information associated with sysibm.syslinks table?