I'm trying to lookup an oracle table in a server job & when I compile I receive this message. I have no constraints in my transform stage. What am I doing wrong?
Pin\%%V0S1P17.Column\%%1 = #<>~
^
"GE" unexpected, Was expecting: Assignment Operator
1 Errors detected, No Object Code Produced.
lookup error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You appear to have "#<" in an expression. This "not less than" operator is a synonym for "greater than or equal to" or "GE". Your derivation expression is syntactically invalid. Right click on the expression and choose "Validate Derivation" to get advice on what's wrong, then fix it.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 457
- Joined: Tue Sep 25, 2007 4:05 pm
Re: lookup error
Check and see, as Ray suggested, inside the transformer stage if any fields are showing up as "Red". Validate the derivation and the tool will tell you where you went wrong.bhargav_dd wrote:I'm trying to lookup an oracle table in a server job & when I compile I receive this message. I have no constraints in my transform stage. What am I doing wrong?
Pin\%%V0S1P17.Column\%%1 = #<>~
^
"GE" unexpected, Was expecting: Assignment Operator
1 Errors detected, No Object Code Produced.
Vivek Gadwal
Experience is what you get when you didn't get what you wanted
Experience is what you get when you didn't get what you wanted
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: