DSXchange

When considering the "limit is not an issue" remember that the Repository tables are mostly hashed files, and you get five of these per job.

1. before-stage subroutine (if any)
2. stream input
3. reference inputs (in link execution order)
4. stage variables (in order in grid)
5. output links (in link execution order)
....(a) constraint expression
....(b) output column derivations (in order in grid)
6. after-stage subroutine (if any)

What tool are you using to schedule the job? If it's DataStage Director, check with your operating system administrator as to why there was a failure in AT - for example was the Schedule service not running at the time? Open a DOS shell and type the command AT (with no command line arguments). This ...

Solved. See the other job. You need an active stage driving the OCI stage to cause the transaction grouping stuff to happen.

It is not possible (not supported) to change the value of a job parameter once that job is running.

You need to find another approach.

If you want to allocate the parameter value dynamically but before the job starts running (for example using a job sequence), that IS supported.

In Administrator client, in project properties, is "Generate operational meta data" checked?

It might be time to involve your support provider.

What precise version of DataStage are you using? You can find out by choosing "About" from the Help menu.

Usually there's an extra step, to pre-populate the hashed file from the target table.

It's not working for me in 7.5x2. Did it on razor, just to check. Didn't work there (7.5.1A) either.

That is because MetaStage is not installed.

Provided you didn't corrupt it when you "looked at" DS_STAGETYPES, you might try reindexing that table. But, before you do, export all of the project except stage types, because you may have to delete and re-create the project; this way you'll be able to reinstate your work. To reindex DS_STAGETYPES...

It is NOT "some junk character". It is the character specified in whatever character map you are using. This character (Swedish ore?) is not an ASCII character - whence do you obtain it to load into Oracle. What value is the NLS_LANG environment variable for Oracle set to? What maps are listed in th...

What details were in the MultiLoad report file (abc.rpt)?

Is APT_ORCHHOME environment variable correctly set (to PXEngine)?
Does LIBPATH include $APT_ORCHHOME/DSCAPIOp directory ?

You DO want write permission on group.

You DO want different groups for different projects, and you want to make sure that the two developers are only in the right group. In dsenv and the users' profiles, make sure that umask is set to 002.

It will work, provided you don't use caching for read or write. Also enable lock for update. It is essential that you use separate Hashed File stages; add an annotation warning future developers that the two stages refer to the same hashed file (not hash file).