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?
Answer / manikanta
No. Only these 3 values i.e 0, -1, -2 will be there in null indicator.
| Is This Answer Correct ? | 4 Yes | 2 No |
database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please
How do you retrieve the data from a nullable column?
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
What is the information associated with sysibm.syslinks table?
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.
What does reorg do in db2?
What is index in db2?
How do I add a column to an existing table in db2?
What is phantom read in db2?
What do you mean by NOT NULL? When will you use it?
what is static sql? what is dynamic sql? Give me details
Is db2 relational database?