Automatic conversion of spaces in CFF to Null in oracle

Ragunathan Gunasekaran · Sun Sep 07, 2008 12:08 am

Hi ,
I am extracting from the mainframe file and dumping the data into the target table using the load option . All the fields are non nullable both in the source and the target . But due to the blank spaces in the source PX converts them to null and tries to insert them in the target . The job aborts due to this ... Any help on this please

Mydesign looks like this

CFF(No of readers =1)------->Oracle Stage (Write method =load)

Any help on this please ... I have tried to search in the forum.There are issue like this but they were not resolved or there were no workarounds available ,......

Aruna Gutti · Post by **Aruna Gutti** » Mon Sep 15, 2008 10:45 am

Did you tried inserting a transformer stage in between CFF and Oracle stages to manipulate the fields with Spaces ?

If the Mainframe file has spaces in a field it is not a null value unless you define it so.

Are you sure you have spaces in the mainframe file and not Low Values ?

shamshad · Post by **shamshad** » Mon Sep 15, 2008 11:03 am

Extending to what Aruna said, try to decode the value of the column that is creating issue. See what the SEQ() / CHAR() value is and then make sure they are indeed spaces or low values

chulett · Post by **chulett** » Mon Sep 15, 2008 11:13 am

Oracle may be converting the spaces to nulls and not PX, if that's the case then you can set APT_ORACLE_PRESERVE_BLANKS to true to stop that from happening.