Page 1 of 1
DataStage Search
Posted: Tue Sep 05, 2006 10:06 am
by hema arvind
Hi
Is there any way like we can search for a particular string from entire Jobs in all the categories of a project?
Re: DataStage Search
Posted: Tue Sep 05, 2006 10:17 am
by meena
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.
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?
Posted: Tue Sep 05, 2006 12:13 pm
by kduke
Posted: Tue Sep 05, 2006 12:23 pm
by chulett
You could also go Old Skool and export the jobs to a .dsx file and then use an editor to search the export.
Posted: Tue Sep 05, 2006 4:47 pm
by ray.wurlod
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;
Posted: Tue Sep 05, 2006 6:44 pm
by kduke
Ray went really old school on that one.
Posted: Tue Sep 05, 2006 10:10 pm
by loveojha2
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.
Posted: Tue Sep 05, 2006 11:12 pm
by ray.wurlod
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).