Hi,
I have a scenario in which I have to lookup to a table with a column(having data such as DIVISION no 1) and the source table with a column(having data such as DIVISION no 1arx).I have to pass a other column (DIVISION ID)from lookup to target based on the match as above..where division 1 should match with division 1arx. Should I use the like function...i.e.MATCHES?
Need help using the like..actually MATCHES BASIC function in DS.
thank you.
comparing data
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
No, what you need to do is to pass the "1" unchanged by DataStage, and use user-defined SQL in the stage that connects to the table. In the user-defined SQL specify LIKE rather than "=", and use an appropriate wildcard character (usually %).
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.