DSXchange

Hi

I have written on stagevariable but it is giving me wrong result can any help me on this

mystagevariable if trans.empno=mast.empno then 1 else 0

both columns are varchar columns
trans.empno=00000802 (value coming from hash file)
mast.empno=802 (value coming from oracle stage)
but data stage shows both are same i am wondering how?

Thanks in advance

DataStage BASIC resolves the "equals" operator as That is, it performs a numeric comparison if both operands are numeric. You can force a string comparison using a Compare() function or by concatenating something non numeric (the same something, of course) to each operand.

Too late. Argh... deleted my reply. Duplicate posts actually.