DSXchange

Sure you can write directly to DS_METADATA. It is a simple table. There is very little risk too. If you mess up then just clear the table and reload from export. I would think Ray's routine which exported this table to a XML file would be the place to start. I expect the XML file would also import b...

There is one in the SDK under Utility. These hashed files have more than one key column like project and jobname. So you need @TM in between so your key becomes MyProject :@TM: JobName.

DSGuru2B great job.

I give a lot of routines away on my tips page and the Tools4DataStage link below.

"Take, adapt and shine" in the words of a friend.

EtlStats alone has about 15.

How is that possible? The dsjob command is the before job routine. It outputs a sequential file for all 3 tables. The same file is the source for all 3. Before Job: dsjob -> KimD/JobName.xml Job: KimD/JobName.xml -> ETL_JOB_HIST KimD/JobName.xml -> ETL_ROW_HIST KimD/JobName.xml -> ETL_PARAM_HIST Thi...

I doubt if anyone is going to share these types of tools. First of all it is a difficult thing to support. Second it is a competitive advantage to have tricks like these. If you want to share these then I could post on my web site until the upload feature is released on this site. I would like to se...

I wrote one a few years ago. I think Craig has written one too. Mine takes a DSX for 4 jobs and replaces the column metadata with the new columns. It assumes basically it is a straight table copy from one table to another. It does assume it is a source table to a dimension table. The table names are...

I think the last run is stored in a hashed file for easy access with a routine. The key does not include any date. Take a look at DSJobReportDb.

There is a import command which will import any DSX file. The dsimport.exe command will do the trick. You need to be able to create a DSX file. I am not sure it can import XML files but I would try it if I was you. Ray posted the program to create XML files from DS_METADATA the internal table of Dat...

Your are welcome. I will add a for more soon.

Your SELECT will not work without a EVAL. I would fix the html after generating it. You need to probably replace '\' with '_'.

The scripts are at:

www.Duke-Consulting.com/Downloads/Scripts.zip

If you use CREATE TABLE then it will create your dictionary items for you.

You may need to change PRJ_DATA_DS_JOBOBJECTS to DS_JOBOBJECTS.

After you export the jobs you need to check in to PVCS. You need to post the syntax of the command line check in.