DSXchange

I think what Arnd is trying to say also was treat each line as if it is one field. You need several stage variables like FirstWord = field(InputLine, " ", 1) SecondWord = field(InputLine, " ", 2) States = if FirstWord = "OLEType" then SecondWord else States Name = if FirstWord = "Name" then SecondWo...

EtlStats is on my tips page below my signature or the other link. When you unzip it there is a text file on how to install it. It is a bunch of jobs and source code to the jobs and routines. It also needs a few sequential files or directories to store sequential files. Instructions show you how to c...

Ray went really old school on that one.

There is a routine activity stage as well. You need to create a user variable before you use it. So if you need a parameter calculated then you can call either a routine activity or create a user variable before or both. In the formula for a user variable you can call routines as well just like in a...

Look at this post http://www.dsxchange.com/viewtopic.php?t=99543

Good idea. Why not a QA section as well?

This topic explains how http://www.dsxchange.com/viewtopic.php? ... c&start=15 This allows you export one job at a time which you can import with the above command. The export is done with dsexport.exe and not dscmdexport.exe.

You are welcome.

You need to add ORACLE_HOME and the other variables to dsenv. Do a search this has been covered in great detail. You may need to start and stop DataStage.

You can hard code this partition into the table name. You could also create a parameter which represents the name and feed it into the job.

But I doubt if that was what you were really asking.

I thought I was the only one who had worked for the Discovery channel.

I noticed you have double quotes in your SQL statement. That gets a little more tricky. You may need a backslash in front of your embedded double quotes. You will have to try it.

Post your solution please.

Add a uvsh or dssh in front of the SQL with double quotes around all of it. You need to cd to the project dirctory first.

What do you want the routine name? Or are you asking does DSJobName work in a routine?

Most of what I have in EtlStats is using dsjob -report XML. I can also retrieve old job runs by reading the job log directly. There is no other way to get an old run. The API only deals with the last run. There is a last run for every job instance though. If you autopurge your logs then that option ...