How do you insert a record with a nullable column?
Answers were Sorted based on User's Feedback
Answer / santosh
For the column which you want to incert a null value,
incert -1 value to indicator variable then incert the
column.
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / s
INSERT INTO TABLE X VALUES('ABC','DEF','')
will allow you to insert a record with no value specified
for the nullable column
Is This Answer Correct ? | 2 Yes | 3 No |
my project is insurance management system,how to explain my work environment in interview?
What is difference between rollback and commit?
How to access db2 tables in mainframe?
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
why we create view.
What is null indicator in db2?
How to check table size in db2 sap?
How would the varchar column remarks defined?
What is DCLGEN ?
i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?
8 Answers Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,
How can you count the number of rows from a table tab?
wt is view ? wht r the restrictions for view ?