DSXchange

You found a bug! *fanfare* No, not your bug. DataStage's BUG! Report this to Ascential Support at your earliest convenience. In the meantime... Instead of concentating data, just do this: 1. Transformer Stage before the Sequential Stage -- Convert all fields to Char(specific length). Do the necessar...

This error message shows up when you are trying to do something down the stream that utilizes the sort data. Your sort key(s) must fit that stage's key(s). If it's an aggregator, you need the same keys. If it's a remove duplicate, you need one extra sort field beyond the keys. The list goes on. Hope...

Unicode is usually added to your metadata if you have a NLS setup, and does not toggle off the Char -> Unicode option when you import metadata to the job. Obviously, your SQL server is not NLS enabled. I am not quite sure how to enable it without doing some hard core Googling. Anyone else know here?

You can not really run Orchestrate on a machine WITHOUT a full DataStage installation. You could call Orchestrate directly ($APT_ORCHHOME/bin/osh), but no, you can not run it independently.

Sorry, this is most likely part of the licensing agreement your company signed with Ascential.

That warning message is typical for EE. In order to fix this, you need to go to the previous stage, click on its properties, select the "Advanced" tab, set "Preserve Partitioning" to "Clear". This is caused by the default behavior of DataStage which is to preserve parti...

This is normal. Timestamp with microseconds are provided to 6 digits within DataStage.

Sorry, other than to set up your dsenv file to ensure that your paths are correct on the server itself (the server requires an Oracle client, obviously). Care to paste the env path you have from the job run on here? Include all Oracle environment settings, please.

Be careful with using different names for your fastname. This would automatically cause DataStage EE to think that it's running as a MPP process, and will try to transfer the Transformer libraries over to the sgwbba01 server via RSH (see $APT_ORCHHOME/etc/distribute-component - that's the script tha...

Ah, it appears he want a command line interface scripting tool.

I am sorry, but DataStage is not a command line interface scripting tool. Especially not EE. I believe you are better off using the tools provided with DB2.

kill -9 <pid> There's your problem RIGHT THERE! Read my instructions very carefully. DO NOT USE -9. DO NOT USE -9. USE -14! You killed DataStage using a very hard-core Operating System kill -- where everything's destroyed without mercy. This is a last resort action. Kill -14 will tell DataStage, &q...

Wild idea: Create a server shared container that invokes the routine. Encapsule it within a Parallel job. Read from dataset and pass data to shared container.

Forgive me for being a bit reluctant in answering -- there are a number of people who try to get us to help them install an illegal copy of DataStage in the past. I love DSXchange, and want it to succeed. In order to do so, we have to stay honest in the narrow legal definitions. So... Have you tried...

In DataStage's transformer, Integer and Characters are interchangeable.

Edit:

will any official course provide the DS knowladge I seek or is it only an Ascential employee priviladge?

Depends on what you want to know!

user_id is missing and not supplied with a value.

Our answers greatly depends on what specific stage you are using. Please let us know.

One other solution: Use: [Sort] -> [Transformer] Sort the key in order of case (ascending), and date (ascending). Use Transformer's Stage Variable to retain the current key. Initialize it to 0 (or some value that will never happens), and compare it with the case. If it's different, provide the new v...