Page 1 of 1
Search for string on designer canvas
Posted: Mon Sep 28, 2015 9:50 am
by Rob4732
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
Posted: Mon Sep 28, 2015 2:12 pm
by qt_ky
Interesting idea... Can it be done? Not that I'm aware of.
Posted: Mon Sep 28, 2015 2:23 pm
by Rob4732
I will suggest this feature at this year's IBM insights conference. At least developers in the future will benefit.
Posted: Mon Sep 28, 2015 7:03 pm
by ray.wurlod
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.
Posted: Tue Sep 29, 2015 10:52 am
by rkashyap
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.
Posted: Mon Oct 05, 2015 9:43 am
by Rob4732
Interesting. I will give it a try.
Thanks
Posted: Thu Oct 08, 2015 5:22 pm
by rkashyap
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?
Posted: Thu Oct 08, 2015 6:34 pm
by ray.wurlod
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.
Posted: Fri Oct 09, 2015 7:42 am
by qt_ky
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