How to supress the warning message generated for NULL fields

[muralisankarr]

Hi,

A Simple 'Oracle Enterprise-> Transformer -> Sequential File' job has given me the below warning message.


Sequential_File_1: When checking operator: When validating export schema: At field "SALARY": "null_field" length (0) must match field's fixed width (10)

Sequential_File_1: When checking operator: When validating export schema: At field "COMMISSION": "null_field" length (0) must match field's fixed width (4)

The metadata of the job is

EMPLOYEE_ID NUMBER(6) not null,
FIRST_NAME VARCHAR2(20),
LAST_NAME VARCHAR2(25) not null,
EMAIL VARCHAR2(25) not null,
PHONE_NUMBER VARCHAR2(20),
HIRE_DATE DATE not null,
JOB_ID VARCHAR2(10) not null,
SALARY NUMBER(8,2),
COMMISSION NUMBER(2,2),
MANAGER_ID NUMBER(6),
DEPARTMENT_ID NUMBER(4)

Why we got the warning message on Decimal columns alone? Is there any way to habdle this? Please help me

Many Thanks
rMS

[arvind_ds]

Do null handling for said columns in the transformer stage

[muralisankarr]

Do null handling for said columns in the transformer stage

Nope. They are simple one to one mapping

[arvind_ds]

It is not possible to write NULL values to a sequential file.

[arvind_ds]

It is not possible to write NULL values to a sequential file.

[ds_search2008]

muralisankarr,

You can fix this by Nullable properties in the sequential file column tab. Meaning, in the column tab click on the number against the corresponding column "Edit Column Meta Data" window will open. Set the "Nullable" properties accordingly.

Regards

[muralisankarr]

muralisankarr,

You can fix this by Nullable properties in the sequential file column tab. Meaning, in the column tab click on the number against the corresponding column "Edit Column Meta Data" window will open. Set the "Nullable" properties accordingly.

Regards

Hi,

For the following action 'Edit column meta data > NULLABLE>Null Field Value = <<<Character equivalent to length>>>' the warning messages are suppressed. But on null fields, the values of nulls are replaced by the characters we entered in Edit column meta data. Is there any way we have to suppress the warning message with out replacing the null value with a character? Please help me sort this out

[ds_search2008]

In the transformer stage use SetNull() against the corresponding null fields and in sequential stage Null Field Value should be set to '', meaning Null Field Value =''.

Regards

[muralisankarr]

In the transformer stage use SetNull() against the corresponding null fields and in sequential stage Null Field Value should be set to '', meaning Null Field Value =''.

Regards

Nope. It doesn't work out. I still got the error message

[throbinson]

I hate to jump into the mis-information and bad advice pool but what the heck.
NULLS have no meaning to a Sequential file.
NULLS have to be represented by, some out-of-bound value (hopefully) of the proper width, when encountered in a fixed width field like a date field when being written out to a Sequential File.
I like to define this;
APT_IMPEXP_ALLOW_ZERO_LENGTH_FIXED_NULL
as a Project level Environment variable and set it's value to TRUE.
It will allow one to import/export a zero length fixed width NULL within a Sequential file with no warnings. For example a '' (empty string, that is tick tick) which I also define as the Sequential File => Input tab => Format => Field Default => Null Field value property.

[sharantheboss]

Hi,

In sequential file datatypes Char and Decimal are considered as fixed widht,so you have to edit metadata properites for sequential file,wherein need to give Null field value=' ' no. of spaces shoud be equal to lenght of column

Regards
Boss

Hi,

A Simple 'Oracle Enterprise-> Transformer -> Sequential File' job has given me the below warning message.


Sequential_File_1: When checking operator: When validating export schema: At field "SALARY": "null_field" length (0) must match field's fixed width (10)

Sequential_File_1: When checking operator: When validating export schema: At field "COMMISSION": "null_field" length (0) must match field's fixed width (4)

The metadata of the job is

EMPLOYEE_ID NUMBER(6) not null,
FIRST_NAME VARCHAR2(20),
LAST_NAME VARCHAR2(25) not null,
EMAIL VARCHAR2(25) not null,
PHONE_NUMBER VARCHAR2(20),
HIRE_DATE DATE not null,
JOB_ID VARCHAR2(10) not null,
SALARY NUMBER(8,2),
COMMISSION NUMBER(2,2),
MANAGER_ID NUMBER(6),
DEPARTMENT_ID NUMBER(4)

Why we got the warning message on Decimal columns alone? Is there any way to habdle this? Please help me

Many Thanks
rMS

[dsuser_cai]

Use the env variable: (you need to define it in the DS Admin, in user defined section)

APT_IMPEXP_ALLOW_ZERO_LENGTH_FIXED_NULL

value is TRUE.

[ray.wurlod]

Set the Null Field Value property to something that has the same number of characters as does the fixed-width field.