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 |
How many databases are there?
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 is a clustering index ?
What is package in db2 mainframe?
Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA
what is parm utility
What is dbrm? What it contains? When it will be created?
How to connect to db2 database from windows command line?
What is DYNSLT keyword? How do you perform selection using DYNSLT
What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?
What is the syntax for FETCH in DB2 ?
i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?