Select the record with 0x0 inside the field by using Filter

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
benny.lbs
Participant
Posts: 125
Joined: Wed Feb 23, 2005 3:46 am

Select the record with 0x0 inside the field by using Filter

Post by benny.lbs »

I have a simple testing job as below
Row Generator --> Transformer --> Filter --> Peek

APT_STRING_PADCHAR = 0x0

Row Generator
A: String[1]
B: String[10]

Transformer
C: String[10] = A
D: String[10] = B

Filter
Peek1 <-- C like '%0x0%'
Peek2 <-- D like '%0x0%'


From above design, field C should contain '0x0' inside, however, the filter can not select them out.

Anyone know how to select the record with '0x0' inside the field by using Filter ?
Post Reply