Oracle Sparse lookup with like option not working

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
RAJEEV KATTA
Participant
Posts: 103
Joined: Wed Jul 06, 2005 12:29 am

Oracle Sparse lookup with like option not working

Post by RAJEEV KATTA »

I have a scenario where in I am running the below sparse lookup

SELECT
PATIENT.FIRST_NAME
FROM
PATIENT PATIENT
WHERE
PATIENT.FIRST_NAME LIKE 'ORCHESTRATE.FIRSTNAME%'

the input FIRTSNAME is coming from a row generator.The datatype is varchar(15) for both the oracle database table & row generator.Even though there is a matching record its rejecting the record.The value in the database table is 'CHARLENE' & the value in row generator is 'CHARLE'.
Post Reply