What is the FREE command?
Answer / s
FREE command drops the Plan or can be used to drop a
package.
Is This Answer Correct ? | 2 Yes | 0 No |
What is the function of the Data Manager?
How to fetch the last row from the table in SQL (db2)?
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?
Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.
What is the use of value function?
What is ibm db2 database?
What should be specified along with a cursor in order to continue updating process after commit?
Can any one tell me about Restart logic in DB2.
What is isolation level?
What are bind parameters in db2?
Is Cursor exicutable ?
i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?