Hi..
I am facing a problem to develop below scenarion in datastage 7.5.
SCENARIO:
How to catch a string pattern from sequential_file source (just like grep in UNIX) . and if able to catch a pattern then how to send as an parameter for next job on run time??
Please Suggest..??
Sequential FIle Scenario
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 148
- Joined: Thu Apr 10, 2008 12:47 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Justice of the Peace?devesh_ssingh wrote:use index function to search 1st occurance of pattern then pass the same in jp.
Please don't use potentially ambiguous or unclear abbreviations.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
as suggested in earlier post. you can use index function to search for string and write it into sequential file in job1.
Then write a datastage server routine which accept file path and name and return you the value stored in file.
in job sequence use user variable activity add valriable and call datastage server routine , provide file level inputs. it will assign the value stored in file to user variable. which you use in any job next in sequencer.
Then write a datastage server routine which accept file path and name and return you the value stored in file.
in job sequence use user variable activity add valriable and call datastage server routine , provide file level inputs. it will assign the value stored in file to user variable. which you use in any job next in sequencer.
Regards,
Deepak Singhal
Everything is okay in the end. If it's not okay, then it's not the end.
Deepak Singhal
Everything is okay in the end. If it's not okay, then it's not the end.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Why re-invent the wheel? Your putative routine does precisely what the Index() function accomplishes.
To the OP, you could also use grep as a Filter Command in the Sequential File stage or in an External Source stage.
To the OP, you could also use grep as a Filter Command in the Sequential File stage or in an External Source stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.