Search for string on designer canvas

Rob4732 · Post by **Rob4732** » Mon Sep 28, 2015 9:50 am

Hello All,

I have a seq job that contains several hundred stages. I want to search the canvas(not the repository or dsx) for object names containing that string(or partial string). Resulting in a visual location on the canvas showing where those objects are.

Anyone know if this can be done?

Thanks

qt_ky · Post by **qt_ky** » Mon Sep 28, 2015 2:12 pm

Interesting idea... Can it be done? Not that I'm aware of.

Rob4732 · Post by **Rob4732** » Mon Sep 28, 2015 2:23 pm

I will suggest this feature at this year's IBM insights conference. At least developers in the future will benefit.

ray.wurlod · Post by **ray.wurlod** » Mon Sep 28, 2015 7:03 pm

Meanwhile you can query the DS_JOBOBJECTS records for that particular job number.

Code: Select all

SELECT * FROM DS_JOBOBJECTS
WHERE JOBIDNO = (SELECT JOBNO FROM DS_JOBS 
                 WHERE NAME = '<<Job name>>')
AND EVAL "@RECORD" LIKE '%<<string>>%';

This query can be run from a dssh shell or, if you have DataStage Administrator role, from the Command window of the Administrator client.

rkashyap · Post by **rkashyap** » Tue Sep 29, 2015 10:52 am

Till a more elegant solution is available ... a query to determine stage location on DS Designer Canvas is:

Code: Select all

Select J.DSNAMESPACE_XMETA Server_DSProject, 
       J.CATEGORY_XMETA Category, 
       J.NAME_XMETA JobName, 
       D.STAGELIST_XMETA,
       D.STAGEXPOS_XMETA,
       D.STAGEYPOS_XMETA,
       D.STAGEXSIZE_XMETA,
       D.STAGEYSIZE_XMETA
       D.LAZYLOADINFO_XMETA 
  From XMETA.DATASTAGEX_DSJOBDEFC2E76D84 J, 
       XMETA.DATASTAGEXDSDESIGNVIEWC2E76D84 D 
Where J.XMETA_REPOS_OBJECT_ID_XMETA = D.XMETA_LOCKINGROOT_XMETA 
 And J.NAME_XMETA = <JobName>;

Stage attributes information for multiple stages is stored in pipe-delimited format in same field .... Stage-names can be parsed from LAZYLOADINFO_XMETA and corresponding locations from STAGEXPOS_XMETA and STAGEXPOS_XMETA.

Top-leftmost position on canvas is 0,0 (STAGEXPOS and STAGEYPOS). Each grid-block has size of 24 units.
i.e A stage with STAGEXPOS = 240, STAGEYPOS = 360 is 10 grid-blocks from leftmost-position and 15 grid-blocks from top.

Rob4732 · Post by **Rob4732** » Mon Oct 05, 2015 9:43 am

Interesting. I will give it a try.

Thanks

rkashyap · Post by **rkashyap** » Thu Oct 08, 2015 5:22 pm

Rob4732 wrote:I will suggest this feature at this year's IBM insights conference.

At IBM Insight, what is the correct forum for giving such suggestions?

ray.wurlod · Post by **ray.wurlod** » Thu Oct 08, 2015 6:34 pm

rkashyap wrote:At IBM Insight, what is the correct forum for giving such suggestions?

There isn't one. That's not what IBM Insight conference is about. Use the standard enhancement request mechanism.

qt_ky · Post by **qt_ky** » Fri Oct 09, 2015 7:42 am

That's right. IBM will ask you to submit a Request For Enhancement (RFE) on the RFE web site. Link not handy at the moment, but you can search for it!

Here is an indirect link to the RFE site:

http://www-01.ibm.com/support/docview.w ... wg21662699