Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 1 Answers
- 5543 Views
- BNP Paribas, I also Faced
- E-Mail Answers
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 |
I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country
What is an alias and how does it differ from a synonym?
What are the 2 sqlcodes that are returned?
db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2
What are column-name qualifiers used?
which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?
What is runstats and reorg in db2?
wht are the restrictions for union ?
What are the full forms of spufi and dclgen and why are they used?
what is static sql? what is dynamic sql? Give me details
What types of tables are there in the db2 database?
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
COBOL 
