Hi
Is there any way like we can search for a particular string from entire Jobs in all the categories of a project?
DataStage Search
Moderators: chulett, rschirm, roy
Re: DataStage Search
Hi Hema
I think it is not possible to look for a particular string.But you can look for a table or for a file.
I think it is not possible to look for a particular string.But you can look for a table or for a file.
hema arvind wrote:Hi
Is there any way like we can search for a particular string from entire Jobs in all the categories of a project?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can effect a SEARCH against DS_JOBOBJECTS, but would then require some knowledge of the structures used in DS_JOBOBJECTS to understand the results.
Code: Select all
SEARCH DS_JOBOBJECTS
STRING=MyString
STRING=
SELECT OBJNAME,OBJIDNO FROM DS_JOBOBJECTS ORDER BY OBJIDNO;
Last edited by ray.wurlod on Tue Sep 05, 2006 7:00 pm, edited 1 time in total.
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.
I have a solution.
I don't know whether its right way of doing or not, but it works.
I read the DS_JOBOBJECTS using a Hashed File Stage and use a transformer concate the columns there and search the string in the concated column.
Till now it has worked with 100% success.
Try it. Its fast also.
I don't know whether its right way of doing or not, but it works.
I read the DS_JOBOBJECTS using a Hashed File Stage and use a transformer concate the columns there and search the string in the concated column.
Till now it has worked with 100% success.
Try it. Its fast also.
Success consists of getting up just one more time than you fall.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
That would work but only to a limited degree - you don't get to search the "invisible" columns - of which there can be more than 200 depending on the object type.
One solution would be to use a UV stage to select from the table. Specify only one big VarChar column, and for its derivation specify EVAL "@RECORD" (the entire data record).
One solution would be to use a UV stage to select from the table. Specify only one big VarChar column, and for its derivation specify EVAL "@RECORD" (the entire data record).
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.