# character in the datastage server

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
pxr87
Premium Member
Premium Member
Posts: 16
Joined: Thu Oct 27, 2005 9:19 am

# character in the datastage server

Post by pxr87 »

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.
narasimha
Charter Member
Charter Member
Posts: 1236
Joined: Fri Oct 22, 2004 8:59 am
Location: Staten Island, NY

Re: # character in the datastage server

Post by narasimha »

pxr87 wrote: I am guessing that # is used inplace of not equal to ('<>')
Your guess is right.
Narasimha Kade

Finding answers is simple, all you need to do is come up with the correct questions.
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

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

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

8) A fourth synonym is ><
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply