What DB2 Catalog column tell you when an index needs table
reorganized ?
What is a base table?
what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx
What is subquery ?
what types of copies can be made with the COPY Utility ?
What is dbrm in db2 database?
if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..
How would the varchar column remarks defined?
Write a query to retrive partial string.
How do you do the EXPLAIN of a dynamic SQL statement?
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?
What is difference between alias and synonym in db2?
How do you define a correlated name?