Like searches in a string

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
sankarsadasivan
Premium Member
Premium Member
Posts: 39
Joined: Tue Dec 23, 2003 3:47 am
Location: India

Like searches in a string

Post by sankarsadasivan »

Is there any straight forward function to perform like searches in a string...

I did search the forum!

Please suggest

Thanks.
rsaliah
Participant
Posts: 65
Joined: Thu Feb 27, 2003 8:59 am

Re: Like searches in a string

Post by rsaliah »

Checkout the INDEX function in the help or supplied PDF.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

LOCATE, FIND and FINDSTR statements can be used in routines to search for delimited substrings.

INDEX() searches for a particular occurrence (for example the first) of a given substring.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply