All,
We have created three tools in DataStage 7.5.1 in our project. They are,
1. ListJobParameters.dsx - List out all job parameters present in a server/parallel job and Job Sequence from an input DSX file. In detail, this DataStage Server Job will provide all the Job parameters components such as Parameter name, Prompt, Type, Default value and Help text.
2. ListFileNames.dsx - List out all file names present in any File group stage form an DSX file. In detail, this DataStage Server Job will pick up all file names mentioned in all File Group Stages in Server /Parallel such as Data Set, Sequential File, Look up File Set, File Set, Complex flat file and FTP file.
Note: the tool present in anotheritco.com lists out only Seq file and Hash file names present in the input DSX file.
3. ListJobAuditInfo.dsx - List all Job details in the jobs and sequencers present in the input DSX file. In detail, this DataStage Server Job will pick up all Stage names, Link names, Stage count, Link type, Stage type and Last modified Timestamp from the input file.
We are likely to submit these tools to any forum.
Please suggest me to submit these tools to any forum.
Where to submit DataStage tools
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
DSXchange currently does not have an upload facility. You could, of course, post them on your own web site. Or you can post with attachments on IBM developerWorks
You mention only DSX files. I trust full documentation on how to use the same will also be posted.
You mention only DSX files. I trust full documentation on how to use the same will also be posted.
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.
Thanks Ray,
Here is link for those tools,
http://www.ibm.com/developerworks/forum ... 7&tstart=0[/url]
Here is link for those tools,
http://www.ibm.com/developerworks/forum ... 7&tstart=0[/url]
-
- Premium Member
- Posts: 385
- Joined: Wed Jun 16, 2004 12:43 pm
- Location: Virginia, USA
- Contact:
Ram,
My List all files and tables used by jobs in a dsx file recognizes the files and tables in ALL DataStage Server stages, as well as in their user defined SQL. The lastest versions of my tool also recognize parallel sequential, fileset, dataset, lookup fileset, dynamic relational, and oracle stages.
Perhaps you are familiar with a VERY old version on my tool, but your review of my tool WRONG.
My List all files and tables used by jobs in a dsx file recognizes the files and tables in ALL DataStage Server stages, as well as in their user defined SQL. The lastest versions of my tool also recognize parallel sequential, fileset, dataset, lookup fileset, dynamic relational, and oracle stages.
Perhaps you are familiar with a VERY old version on my tool, but your review of my tool WRONG.
Chuck Smith
www.anotheritco.com
www.anotheritco.com
Re Opening reopening this post
This forum is about trying to keep information true by the wide and able persepective of it's members to keep it so. It has come to my attention that by marking a topic resolved, it assumes that all facts are in evidence. I have unresolved this post to allow those interested to finish their public discovery and dissemination.
On an ongoing basis, if anyone feels that the body of a post is not the true outcome, even if parties chose to differ on the final recommendation, I will always error on behalf of more than less. I am proud to say that I am RARELY asked to intervene, so I do believe the 'system' works.
Dennis James, Editor.
On an ongoing basis, if anyone feels that the body of a post is not the true outcome, even if parties chose to differ on the final recommendation, I will always error on behalf of more than less. I am proud to say that I am RARELY asked to intervene, so I do believe the 'system' works.
Dennis James, Editor.
Re Opening reopening this post
This forum is about trying to keep information true by the wide and able persepective of it's members to keep it so. It has come to my attention that by marking a topic resolved, it assumes that all facts are in evidence. I have unresolved this post to allow those interested to finish their public discovery and dissemination.
On an ongoing basis, if anyone feels that the body of a post is not the true outcome, even if parties chose to differ on the final recommendation, I will always error on behalf of more than less. I am proud to say that I am RARELY asked to intervene, so I do believe the 'system' works.
Dennis James, Editor.
On an ongoing basis, if anyone feels that the body of a post is not the true outcome, even if parties chose to differ on the final recommendation, I will always error on behalf of more than less. I am proud to say that I am RARELY asked to intervene, so I do believe the 'system' works.
Dennis James, Editor.
Hello chucksmith,
I have commented your previous version of your tool. When i posted a message at first (two months back), I did not come to know that your tools had been updated with some more functionalities.
Really regretting about having been an ignorant of your tools updates.
Absolutely nice to see those updates in your current version of your tool.
I have commented your previous version of your tool. When i posted a message at first (two months back), I did not come to know that your tools had been updated with some more functionalities.
Really regretting about having been an ignorant of your tools updates.
Absolutely nice to see those updates in your current version of your tool.