DSXchange

I had this code in constraint of the datastage transformer stage.

[color=red][b](lValidatedXpn.SourceNum # "03" or IsNull(lValidatedXpn.SourceNum)[/b][/color]

the '#' character seems to be very odd here .
we use # as parameter usage delimiter. based on this business logic, I am guessing that # is used inplace of not equal to ('<>'). and this code is working in production for 5 hrs no business complaints, so I can't change it.
Does any know what # does here?>


This code initially developed in 3.6 thne migrated to 4.2., 5.2. 75.1A.

pxr87 wrote: I am guessing that # is used inplace of not equal to ('<>')

Your guess is right.

# is the same as not-equal-to. It's perfectly valid DS BASIC syntax. You can use #, NE, or <> and they perform the same.

A fourth synonym is ><