"When validating export schema:" message.

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
tbtcust
Premium Member
Premium Member
Posts: 230
Joined: Tue Mar 04, 2008 9:07 am

"When validating export schema:" message.

Post by tbtcust »

Hi all,

Is anyone familiar with the Director message below and how to resolve it?

env
----
Parallel Job


Thanks in advance for any help.

"When checking operator: When validating export schema: At field "FldName": Exporting nullable field without null handling properties"
throbinson
Charter Member
Charter Member
Posts: 299
Joined: Wed Nov 13, 2002 5:38 pm
Location: USA

Post by throbinson »

I would say that almost EVERYONE who has ever done EE is familiar with this particular message.
You cannot export a field defined as nullable into a sequential file without handling the possibility of a NULL. There is no such thing as a NULL in a flat file. Searching the forum would have helped you here.
tbtcust
Premium Member
Premium Member
Posts: 230
Joined: Tue Mar 04, 2008 9:07 am

Post by tbtcust »

Thanks so much throbinson. This was very useful.

Also, I searched the forum for "When validating export schema: At field" and got no hits. So I post the question. Thanks again.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Try searching for something more like "Exporting nullable field without null handling properties".
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply