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 |
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
What is ibm db2 used for?
how many bytes timestamp token occupies?
6 Answers Boss Global, Cap Gemini, TCS,
Explain what are the various isolation levels possible?
What is host variable?
could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..
Which component is responsible for db2 startup and shutdown?
What is query for your birthday date should be in hours,minute and seconds format?
i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.
Explain in brief how does db2 determine what lock-size to use?