Interested to Buy Any Domain ? << Click Here >> for more details...
How do you insert a record with a nullable column?
- 2 Answers
- 6228 Views
- I also Faced
- E-Mail Answers
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 |
When would you prefer to use VARCHAR?
How do you check for a null value in a db2 column?
Describe major components of db2?
What is role in db2?
What is sqlcode -811?
7 Answers Accenture, CTS, TCS,
What is an alias?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is isolation level?
Can a array declared with an index be displayed(readable format) in spool?
how to check the table is empty or not?
Highlight all the advantages that are attached to a package.
On which levels locks can be applied?
COBOL 
