Setting Date using SQL

[Zoogie]

I want to use SQL to reset a date on F03B11 to Null. The date field in SQL is defined as numeric 9. If I run SQL to set this date to Null, the UBE in OneWorld does not pick up the record when I use data selection where date is equal to NULL. Have tried setting it to zero but no luck. Can anyone help please?

 

[Larry_Jones]

Zoogie,

don't EVER set any OneWorld database field to NULL. OneWorld programs don't really understand it. A OneWorld "Null Date" should be set to numeric 0.

Regards,

 

[jzapeta]

Hellow, One World do not use null or blanks. I sugest you to use in numeric field the value 0, and in the strings a blank space (' ').

Good luck!

 

[rwebster]

OneWorld table I/O NEVER creates NULLS despite creating fields which are not primary keys as null-capable. Empty fields are set to blanks/zeros. Subsequently a test for null on a data selection is changed by OW to a test for blank/zero. Hence no OneWorld table should ever be changed by SQL, etc to have null values in any field.