Can a array declared with an index be displayed(readable
format) in spool?
Answers were Sorted based on User's Feedback
Answer / ganesh
Since we can display content of array like below
Display Array(Idx)
But we can display index alone like
Display Idx
| Is This Answer Correct ? | 0 Yes | 2 No |
What is buffer pool and list some of them?
What is the size of a data page?
how to take the back up of the DB2 table.
How to find primary key of a table in db2?
Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI
What are host variables in db2?
Is schema the same as database?
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?
How can you quickly find out the # of rows updated after an update statement?
can we update the table by using cursors can anyone post the query?