How can you validate Sql errors during cursor operation in
db2 pgms and where do you code?
- 0 Answers
- 1709 Views
- IBM, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is -904 sql code? How to resolve it?
What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?
List out the data types available.
Define predicate?
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
What is db2?
How do I add a column to a table in db2?
if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
Which component is used to execute the sql statements?
how can we retrieve the 100 records of the file ?
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
What is a buffer pool?
COBOL 
