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

[deepa_shenoy]

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

[ray.wurlod]

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

[deepa_shenoy]

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.

[ray.wurlod]

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

For fixed-width, no.

[deepa_shenoy]

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