DataStage Search

[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?

[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.

Hi

Is there any way like we can search for a particular string from entire Jobs in all the categories of a project?

[kduke]

Look at this post viewtopic.php?t=99543

[chulett]

You could also go Old Skool and export the jobs to a .dsx file and then use an editor to search the export.

[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;

[kduke]

Ray went really old school on that one.

[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.

[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).