In cursor program-1 can we create another cursor program-2
inside the cursor program-1.If yes how/no why ?
Answers were Sorted based on User's Feedback
Answer / lvr_rams
yes it can possible. Multibull cursor we can used.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / truclu
yu can create multiple cursor but with hold...because if
you don't want to lose your row...
| Is This Answer Correct ? | 0 Yes | 1 No |
Once you create a view, where would information about the view be stored?
What does CURRENTDATA option in bind indicate
What are the contents of a dclmgen?
what is dynamic cursor?gives syntax for this?
What is check constraint. Explain with example.
What os does db2 run on?
What is the difference between cursor stability and repeatable read isolation levels?
in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.
What is a result table?
what are the SQL codes u freequently got?
what types of copies can be made with the COPY Utility ?
What are db2 objects?