DSXchange

First suggestion would be to take that error message about permissions to your System Administrator, they may be able to help as this isn't necessarily a DataStage problem.

So then, as noted, create a Server routine that takes the filename and validates all of the components are there and good, then invoke it in a Routine Activity stage or from inside a job. Or validate them all and land a list of 'validated' filenames that you then process in a loop or all at once.

From what I understand, the stage has 'improvements' in the 8.x version over the 7.x version so perhaps nuances of how the stage works have changed as well. Pity about the lack of documentation, I'll have to check with our 8.x person and see what, if anything, I can find out.

Then it seems to be time to involve your official support provider. Also, answer the questions that Ray asked.

<whack!>

The Index() function is used to locate a substring within a string, you can use the return value from it as a boolean if all you want is true/false, it found it or it didn't.

Recognize that you need permissions all the way up the path, not just on the file itself... still good? I'm assuming it doesn't run under the "dsadm" user from ESP, btw.

In other words, what it says in the documentation.

As noted, that's typically the purview of whomever administers your system. Either the O/S will have something built in or a cron script will run (typically) once a day to clean out files in "temp" locations over X days old. It's really not something anyone not "in authority" sho...

Kryt0n wrote:The OCONV format "DJ" gives Julian Year Date and not Julian Date that is why you get 114.

Also known as an "Ordinal" date - the day number of that year.

The stage needs to be an active stage from what I recall, so best to point to the output link on the transformer that feeds the shared container rather than the container itself.

Entire would definitely cause this. However, you should be able to Hash partition on your grouping key(s) to avoid the problem.

Hmmm... two nodes... values doubling... big clue there, it seems. Works fine when constrained to a single node, I assume?

Sounds more like a parameter rather than a permission problem. I'd triple-check what ESP is doing. However, does your ESP user have full access to "/home/dsadm/SG/error_log_skey.sf"?

Have you tried doing what it says? For example, adding the appropriate "Index Mode" option: Rebuild or Maintenance? Or is there some specific reason you need to take the APT_ORACLE_LOAD_OPTION path?