View previous topic :: View next topic
|
Author |
Message |
meenakshi_forum Warnings : 1 Active User
Joined: 27 May 2008 Posts: 121 Location: India
|
|
|
|
Please let me know how Low values in a file can be converted to Null before updating a table with the same.
Thanks |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
cobol low values and db2 null values are not related in any way
cobol low values are the content of a variable according to it's definition
a null db2 column means that the column does not contain any data
a normal db2 column is a single thing containing the data
a nullable db2 column is made of two things, a flag and the data
the flag will tell if the column contains any data
the data can consist in any case of low values
( but that does not make a column null) |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
If this is your requirement, I feel you could check for low-values in the field and move "-1" to the null indiactor of the corresponding DB2 column and do a table insert.
Thanks,
Arun |
|
Back to top |
|
|
meenakshi_forum Warnings : 1 Active User
Joined: 27 May 2008 Posts: 121 Location: India
|
|
|
|
Could you please tell me what does -1 mean? |
|
Back to top |
|
|
Suresh Ponnusamy
Active User
Joined: 22 Feb 2008 Posts: 107 Location: New York
|
|
Back to top |
|
|
|