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 |
What is the advantage in De-normalizing tables in DB2?
What if we fail to give values in columns declared as NOT NULL ?
Explain db2.
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
What is concurrency?
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
What is EXPLAIN?
How can you do the explain of a dynamic sql statement?
What is the meaning of -805 SQL return code?
Mention the definition of cobol in varchar field.
What is host variable in db2 cobol?
WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?