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 |
Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.
WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?
What is PRIME TABLE and what are the uses of it
What does the sqlcode of -818 pertain to?
What is the clustering index in the db2 database?
What are simple, segmented and partitioned table spaces ?
I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.
can any one expalin check point with an example?
What's the Maximum Length of SQLCA and what's the content of SQLCABC?
How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?
What information is contained in a SYSCOPY entry?
What is a lock?