Oracle Database Discussions

Hi,

I have a query regarding handling NULL :

Normally by syntax, to work with NULL fields in the table, Pro*COBOL uses Indicator Variables.
But there is a workaround to set a variable named UNSAFE_NULL=YES, which allows the fetching of Database variables and, Spaces are retrieved into the Variables if the DB field has NULL.

In my MicroFocus COBOL code, there are lot of code which Inserts Spaces to Database (not just fetch, but INSERT/update) into Date and Numeric Data type fields, which accepts them and inserts Null into the fields. But NetCOBOL does not allow this.

Can someone tell me if there is any variable to set, such that it allows spaces to be inserted/updated into Database fields of Type Date / Numeric, such that Spaces are inserted as NULLS in to Database.

Thanks in advance !!

-Sunil