Page 1 of 1
Get Stage Properties from command line
Posted: Tue Mar 09, 2010 2:00 am
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.
Posted: Tue Mar 09, 2010 2:30 am
by ArndW
I know of no method of getting this from the command line interface.
Posted: Tue Mar 09, 2010 2:57 am
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.
Posted: Tue Mar 09, 2010 10:15 am
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...
Posted: Tue Mar 09, 2010 12:05 pm
by kduke
If you know the filename then you use the SQL in:
viewtopic.php?t=99349&highlight=DsSearch1