What will happen, while trying to close the closed cursor.
How do you concatenate the firstname and lastname from emp table to give a complete name?
For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?
which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?
What is sqlca’s maximum length?
How to access db2 tables in mainframe?
What does the sqlcode of -818 pertain to?
Which component is responsible for processing sql statements and selecting access paths?
How can you find out the # of rows updated after an update statement?
What is a cursor?
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?
What is the maximum size of a char data type in db2?