Search found 3 matches

by arunselvaraj
Fri Jan 04, 2008 12:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: LookUp Problem
Replies: 7
Views: 2451

I too tried tat...but all in vain. For the unmatched records, null is not coming. i dono whether it is blank space.
iam worried what is happening there??
by arunselvaraj
Fri Jan 04, 2008 12:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: LookUp Problem
Replies: 7
Views: 2451

Iam looking up column named start_c char(1) from a dataset with nullable=no and code_val_c varchar(30) from a db2 stage with nullable=no.My lookup is set to "continue" on failed lookups. Iam getting all the matched and unmatched from the lookup. But while checking the nullability for the ...
by arunselvaraj
Fri Jan 04, 2008 11:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: LookUp Problem
Replies: 7
Views: 2451

LookUp Problem

Iam trying to lookup a char(1) column with varchar(30) column. But iam not getting null for not matched record in the lookup. When iam looking the records in the dataset after lookup, iam having a blank field but it is not null. I need null when the column is not matched.Please anyone give me an id...