input col like %.AX%, what is equivant in datastage?

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
cfuller
Premium Member
Premium Member
Posts: 70
Joined: Mon Mar 24, 2003 10:08 pm
Location: Australia

Post by cfuller »

Try 'INDEX', syntax Index (string, substring, instance). So your code would look like -

Code: Select all

INDEX([input_col], '.AX')
The designer manual should be able to give you more examples.

:)
Regards
Chris Fuller

"Reality is what refuses to go away when you stop believing in it"
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”