DSXchange

I tested it again today, if an after-job call to EXECSH fails it returns a warning to the job - on Windows at 8.7

If the EXECSH fails it creates a warning in the job log, isn't that sufficient to trigger a different action?

"D-YMD[4,A3,2]"

I just played around and found that you can do the following: 1. Edit the DSParams file. 2. find the [EnvVarDefns] section in the file and locate the line with your parameter parameter definition 3. Replace the String "\User Defined\" with "\User Defined/{NewSection}\" 4. Save th...

Interesting, I haven't seen that done anywhere yet. But you've given me some ideas and my current project has a pageful of user-defined project parameters as well which I would like to organize into categories...

Since you are in DataStage Server the error message is not from the conversion itself, but when that column is being written to your database, it is most likely using a different default format for dates. Once you convert your string to what the DB expects the job should work correctly.

Don't touch the DSParams file manually, it is easy to make a syntactical mistake and mess it up. You can add your own variable in the Administrator. Choose the project -> Properties -> Environment -> User Defined and add your own. They will be shown and listed in alphabetical order (of the descripti...

While the version might be old, the known bugs with multi-instance jobs back then were, as far as I know, all involving purge/auto-purge and the director log but it really is time to upgrade. If not, a reproduceable simple test case will be required by your support provider to get them to fix it.

1) Yes, it might be possible that one installation does and another doesn't insert sorts / repartitions but that would depend on your configuration settings. If you didn't explicitly change $APT_NO_PART_INSERTION or $APT_NO_SORT_INSERTION then both installations should execute the same score for job...

Normally I would expect to see several locks from users with the designer and director open, but certainly not hundreds. Could you post a sample of the output of the "LIST.READU EVERY" command done from the administrator that will show what kind of locks are set on what objects.

Could you post your complete error message? Also, why aren't you doing a "ALTER INDEX [index] ON [table] DISABLE; GO;" which should be more efficient than droppig and re-creating.

ssreeni3 - This is posted in the server forum, and the server sequential file stage does not offer this option.

Yes, take a look at the server "folder file" stage, that will let you use wildcards and other rules to select files to process from a directory.

If it compiles and runs but shows up red in the designer, then the descriptor is missing from the DSParams file in the project and can be manually added. If it doesn't compile or run then you need to contact your service provider.

Have you turned on $APT_DUMP_SCORE and perhaps $APT_PM_PLAYER_TIMING to see how your processes are actually allocated?