Interested to Buy Any Domain ? << Click Here >> for more details...
How do you insert a record with a nullable column?
- 2 Answers
- 6352 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 |
What is bind in db2?
When is the skeleton cursor table created?
How do I add a column to an existing table in db2?
If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?
What is the format (internal layout) of ?TIMESTAMP??
What information is held in SYSIBM.SYSCOPY?
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
Can you use max on a char column?
How to insert more than one record using insert?
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
How will you return the number of records in table?
List down the types of triggers in the db2 database?
COBOL 
