How do you check for a null value in a db2 column?
Answer Posted / guest
You use a null indicator on the colunm and if the null
indicator = -1 then the column has a null value.
| Is This Answer Correct ? | 32 Yes | 0 No |
Post New Answer View All Answers
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
How will you return the number of records in table?
What are the contents of dclgen?
Which is faster delete or truncate?
What is a db2 tablespace?
What is difference between isnull and coalesce?
How to get the ddl of a table in db2?
What is copy pending and check pending in db2?
What is the physical storage length of time data type?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
How to take backup of table in db2?
What is table space in db2?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What is the role of schema in the db2 database?
How to access db2 tables in mainframe?