Hi Friends,
When I am sending data to Rejects file it showing below warning can tell to me how solve this warning. This "LOSGR" Having Decimal Datatype, Size is 13,3.
REJECTS: When checking operator: When validating export schema: At field "LOSGR": "null_field" length (1) must match field's fixed width (15)
Decimal warning
Moderators: chulett, rschirm, roy
Re: Decimal warning
The decimal field "LOSGR" is of nullable field. I think you might have specified the null field value to '' (single character). But as it is a decimal field, DS expects the null field value of length 15 (i.e. 13 + 2).deesh wrote:
REJECTS: When checking operator: When validating export schema: At field "LOSGR": "null_field" length (1) must match field's fixed width (15)
Edit the field property for "LOSGR" as null field to 15 character.
Ping me if I am wrong...
-
- Premium Member
- Posts: 151
- Joined: Fri Feb 13, 2009 4:19 pm
Re: Decimal warning
You need to check for the null property for this particular column.deesh wrote:Hi Friends,
When I am sending data to Rejects file it showing below warning can tell to me how solve this warning. This "LOSGR" Having Decimal Datatype, Size is 13,3.
REJECTS: When checking operator: When validating export schema: At field "LOSGR": "null_field" length (1) must match field's fixed width (15)
To do this, open the stage properties, go to columns tab, click on the column number of "LOSGR" column and you will see the Edit Column Meta Data window. In the Properties option set the Nullable property with spaces.
For example if the size of LOSGR column is 10, you have to leave 10 spaces, like
Null Filed Value = " "
(use double quotes). I think this should fix your problem.
Thanks
Karthick
Karthick