stagevariable

[basu.ds]

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

[srinagesh]

Try something like

Code: Select all

if "*" : trans.empno = "*" : mast.empno then 1 else 0 

[ray.wurlod]

As I already answered in one of your other posts, use the Compare() function if you need to force a string comparison. Syntax of the Compare() function can be had from the DataStage BASIC manual or from the on-line help.

Code: Select all

Compare(mast.empno, trans.empno, "L")