Pattern Matching

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
vskr72
Premium Member
Premium Member
Posts: 128
Joined: Wed Apr 28, 2004 9:36 pm

Pattern Matching

Post by vskr72 »

Have a small issue in Pattern matching. Scenario is;

1. I have a directory that has a bunch of files that I need to search for a specific pattern repeteadly
2. Directory is fixed but the pattern for search will change every time, so, I cannot hardcode a search pattern.
3. Everytime, when I run the parent job I am storing these search pattern in a sequential file.

Pls let me knwo if there is any way to automate this process.

Thanks

Kumar
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Kumar,

offhand I would say the solution is (or ought to be) parameters. Which stage/methodology are you using? Is it in a sequencer or server job?
vskr72
Premium Member
Premium Member
Posts: 128
Joined: Wed Apr 28, 2004 9:36 pm

Pattern Matching

Post by vskr72 »

I am using it in a Sequencer. Is ther a way to use in Server Jobs.

Mostly the stages used are ODBC, Seq and Hash files. Thanks

Kumar.

[quote="ArndW"]Kumar,

offhand I would say the solution is (or ought to be) parameters. Which stage/methodology are you using? Is it in a sequencer or server job?[/quote]
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

How are you performing the search?

Yes, it can be done in a Server job, in a number of ways. The obvious one, the Folder stage, is only good for a small number of small files, due to a known bug.

The search can also be performed in a Routine (perhaps invoked from a Routine activity), which is probably the easiest way to pick up a parameter value.
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