DSXchange

Go to either my tips page or ADN and download EtlStats.zip. This is a few jobs to get row counts and store them in tables. Do a search. I have explained this in detail on both web sites. Very easy to run and setup. We store row counts in our data warehouse so we can look back over time and see if a ...

TCL is like sqlplus for Universe. Universe is the database DataStage uses. If you telnet into your DataStage server then you need to run uv. This command is in the DSEngine/bin directory. You need to be in the project directory before you run uv. Do a search this has been covered a lot. Anyway you c...

Try this post http://www.dsxchange.com/viewtopic.php?t=88914

Ray

I know swap space is not the same as UVTEMP but it is sometimes called scatch space. It functions in a similar manor as UVTEMP for the OS. UNIX also uses /tmp for scatch or temp space.

I was wondering if that method would give you the multiple instances? Also I am not sure there is a shortcut to getting status without attaching to a job.

Sometimes called temp space or swap space. In Universe it is defined by UVTEMP.

Here you go: SELECT DS_JOBS.NAME AS JOB_NAME, DS_JOBS.CATEGORY, DS_JOBOBJECTS.NAME AS OBJECT_NAME, DS_JOBOBJECTS.OLETYPE, EVAL DS_JOBOBJECTS."if index(upcase(@RECORD),'DEALORDERDIM',1) > 0 then 'FOUND' else ''" AS FOUND FMT '5L' FROM DS_JOBS, DS_JOBOBJECTS WHERE DS_JOBS.JOB...

The SEARCH command requires input. You have to use a DATA statement. You need a blank DATA statement as well to finish input. This will only a list of keys. You would need to use that in a SELECT to get JOBNO. Next you would need to use JOBNO to go against DS_JOBS to get job name. This is not a bad ...

You could almost guess it. Each stage type has a corresponding OLETYPE in DS_JOBOBJECTS. select distinct OLETYPE from DS_JOBOBJECTS ; Recently I posted a SQL query to join DS_JOBOBJECTS to DS_JOBS. If you cannot find it then ask. You need to get the job name from DS_JOBS. The JOBNO is the common fie...

You can buy DwNav or download EtlStats.zip from ADN or my tips page. It is my understanding that MetaStage will also get rows counts. EtlStats has dsx files to import into Ds7.1 or newer. If you are running on older versions then there are several API routines to call to get row counts. You have to ...

If you could limit it to specific stage types then it is possible. Ray posted one for hash files. What stage types do you need?

Otherwise buy DwNav. That is why I wrote it.

The UNLOCK verb only exists in the UV account. You can copy it by creating a Q-pointer to the VOC in the UV account or you can LOGTO UV.

If you look at this post then you can do exactly what you want to do. I wanted to get the max surrogate key from a hash file so I used a UV stage. SELECT MAX(#SurrogateKey#) FROM #HashFile# then output this to SDKsequences. This hash file was a crossref file with source keys and would lookup the sur...

Please post question in the correct category like Ascential DataStage Server Edition.

The second field in the VOC record has the path to the data side of a hash file. The third field is the path to the dictionary side of a hash file. Field one should have an "F". You should probably do error checking around all these little details but this is good enough. You should be able to finis...