comparing data

logic · Post by **logic** » Thu Mar 24, 2005 2:16 pm

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.

ray.wurlod · Post by **ray.wurlod** » Thu Mar 24, 2005 4:22 pm

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 %).

logic · Post by **logic** » Thu Mar 24, 2005 5:38 pm

Hi Ray,
Thank you.