env problem

shaonli · Post by **shaonli** » Sun Mar 30, 2008 10:32 pm

input is A.txt file(10 records) which has fileld C1,C2...char field...
ref i/p is B.txt(7 records) which has field C1,C3...char filed....
lookup has continue condition....lookup key is C1...
In lookup the o/p fields are C1,C2,C3
now o/p of lookup is 10....(7 records matching)

Now in later stage if I use any null function on C3 field (trim/is null/null to empty) it is not able to figure the 3 records for which c3 is null....

The job was totally running fine in Dev env.....Now in QA it is not working...Not able to understand why null value is not coming from lookup...

Is ther any env settings problem...
Please suggest...

ray.wurlod · Post by **ray.wurlod** » Sun Mar 30, 2008 10:34 pm

What is different between dev and QA environments? Look very carefully - something is different, obviously.

shaonli · Post by **shaonli** » Sun Mar 30, 2008 10:43 pm

Apparently we are not able to find any difference.Is there any special APT parameter to recognize null value..or do we need to chack character set used by datastage..
Please suggest...

keshav0307 · Post by **keshav0307** » Wed Apr 02, 2008 8:15 am

what is optput for C3 columns after the lookup stage, for those 3 records you are not getting match?