Get Stage Properties from command line

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
n_suresh_82
Premium Member
Premium Member
Posts: 19
Joined: Mon Jun 23, 2008 7:28 am

Get Stage Properties from command line

Post by n_suresh_82 »

How to get the stage properties from command line interface?

e.g.
1) File name of Sequential file stage
2) Table name (or) SQL of DB2 stages

Note:- I got the DS Project Name, job name and stage name using dsjob command with different options.
Suresh
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

I know of no method of getting this from the command line interface.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Other than faking it (using a command line interface to execute a query against the local repository database) I too am unaware of any command line technique the like of which you write.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
dsedi
Participant
Posts: 220
Joined: Wed Jun 02, 2004 12:38 am

Post by dsedi »

dssearch command can be used to Search for Job Using Specified Table Definition--(Please check the options @ P714 of Server job developer's Guide)--but that may only work on server jobs that uses the DRS stage
Not sure about the command to get the File name of Sequntial file stage!


kDuke Etlstats may also help to get this...
Accept that some days you're the pigeon and some days you're the statue.
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

If you know the filename then you use the SQL in:

viewtopic.php?t=99349&highlight=DsSearch1
Mamu Kim
Post Reply