DSXchange

That user cannot do it but you could run the job as a different user. This user needs to have access to this drive. That is not the way I would do it though. Writing to shared drives are always having issues. Write to a local drive and share this with the users which need access to it. I would not s...

Vince

Check out http://www.dsxchange.com/viewtopic.php? ... ermissions

I think there is a -wait option to dsjob. Please look it up or search for it.

Also you need to be in the project directory.

Add either a uv or uvsh in front of a quoted TCL command. You need $DSHOME/bin in your path or $DSHOME/bin/uvsh.

Sure you can but you would probably want to put your data in a hash file. There are routines in the SDK that comes with DataStage. The Utility routines have some good examples.

PLEASE POST IN Ascential DataStage Server Edition section.

Do a lookup with ODBC or OCI (Oracle plugin). Change the metadata so the one column is the "key" by unchecking the other fields and just checking this one field. The field to return is not a key. The same is true for any other returned field.

Oh by the way a separate process is available in DwNav which will download the same information into an Access database to merge with the data in Reporting Assistant. This runs on version 5 and above. You can download DwNav from my web site as well. It is not available on ADN. DwNav includes row his...

You need EtlStats.zip. It is posted on my web site or ADN. It is version 7 of DataStage. If you have an older version then it is real simple. It runs dsjob -report project job XML. I am not sure this command will work with older versions of Ds. Anyway it will push the results into Oracle. All the cr...

Craig

A lot of commands can change the UNIX dates. If they are old then believe them. If they are new then backups or some other command can change them. You could of done a LIST at TCL or within the job.

I get it. At the UNIX level you can look at the access time. I am not sure that is adequate. If you know all the jobs which read or write to this hash file then Ray did a post which shows the last time these jobs ran. As long as jobs are not compiled then you can also get the last run times from Job...

Ray posted a query to find all jobs on this topic http://www.dsxchange.com/viewtopic.php?t=87959 . You can also use MetaStage or Reporting Assistant. Do a search. If you cannot find the other topics then we can help.

Hash file is the best solution. You can stored as many values as you like. The overhead is close to nothing. Maintenence is also simple. You can retrieve it by a key of your choice. You can have multiple record types in the same hash file. There are prewritten routines in the Utility part of the SDK...

Not bad but how do you build the multivalue hash file within a job without writing the whole thing in BASIC. Ken has a trick to load it comma delimited. You need the dates sorted descending for the locate to be fast. The next problem is still have not joined these 2 together. I am not sure what you ...