DSXchange

Posted: **Sun Nov 29, 2009 11:07 pm**

Hi All,

I am getting this error:

SEQL_Current: When checking operator: When validating export schema: At field "system_business_date": "null_field" length (2) must match field's fixed width (26)

The datatype is Timestamp. What value do I give for Null Field Value?
Currently I have given \xAB. Is there any other better approach than giving a 26 char Null field value?

Thanks in advance.

Regards,
Deepa

Posted: **Sun Nov 29, 2009 11:12 pm**

This has been answered in a response to another of your posts, in which you asked exactly this question.

Posted: **Sun Nov 29, 2009 11:20 pm**

I'm sorry for the repetition.

This is more specific to DATE fields-Timestamp in particular.

I meant instead of giving Null Field value which has 26 characters, is there any other approach? When I use Actual Length and Null Field Length it throws an error saying, it must be used in conjuction with Prefix or Link Length.

Posted: **Sun Nov 29, 2009 11:44 pm**

deepa_shenoy wrote:I meant instead of giving Null Field value which has 26 characters, is there any other approach?

For fixed-width, no.

Posted: **Sun Nov 29, 2009 11:59 pm**

Thank you. I used 1900-12-12-00:00:00.

DSXchange

"null_field" length(2) must match field's fixed wi

"null_field" length(2) must match field's fixed wi