Empty value in the Source

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
MURALI123
Participant
Posts: 46
Joined: Sun Jun 21, 2009 1:37 am
Location: CHENNAI

Empty value in the Source

Post by MURALI123 »

Hi All,

i am using the Source file have some tags based on the tags i transform the vlues here one of the Tag has coming from Empty which is
not null column in target thats way whcih shows the warning has assigned to null value to a not null column.
In the tags are required value but which empty thats way that warning comes.
In this situvation what can i do can anybody suggest me.

Regards,
Malli
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

By "tags" do you mean XML-style tags, i.e. <Col></Col>? Or are you just refering to columns that contain no values, i.e. in a comma separated source file

Code: Select all

a,,c,d,,f
where columns B and E have no value?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

You'll need to check for these empty "tags" and assign a default value it seems to me.
-craig

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