DSXchange

A lot easier to find on the internet if you have a specific error code. For example if I search for DB2 error codes I might get a million matches, if I search for DB2 SQL0670N I will get several very precise matches that take me straight to the IBM online documentation on all sql errors or the usefu...

Please visit the FAQ forum. There is a specific FAQ explaining the different types of DataStage products.

This has to be our first "how do I make my jobs run slower" post! Got to wonder what other on-line apps are doing on an ETL server. Just in case chaps up up and away doesn't work you might be able to run two sets of sequence jobs, one set that runs most jobs serially so you tend to use just one CPU,...

Reading about it in the Parallel Job Developers Guide may be faster then asking about it on this forum. The stage generates sequentially incrementing unique integers from a given starting point. The existing columns of the data set are passed straight through the stage. If the stage is operating in ...

The SQL*Loader-937 error is specific to Oracle and pretty much means what it says. You have tried a parallel bulk load to a table which has triggers and constraints turned on. In your Oracle Enterprise stage you have an Option called "Disable Constraints" which can be set to true or false. Set this ...

Have you tried using the Complex Flat File stage? It has support for text/Binary formats and ASCII/EBCDIC formats.

When you import the definition of a complex flat file into DataStage it derives a DataStage data type for each field using the file definition. For cobol files this is the cfd file. All your mainframe data types will be converted to DataStage data types. Quite an easy task since all fields are writt...

The Change Capture stage provides endless entertaining warning messages for the whole family. It works best when the column list on the After (primary) stream exactly matches the Before (reference) stream. If you have a column on the After stream that is not on the Before stream then you need to cho...

I agree, server jobs are probably going to be supported for at a while yet. They are still packaging a server license with every release of PeopleSoft EPM. Because server licenses are cheaper customers are still buying them.

It depends on your restart plan. If you have a file full of updates and it fails you can just run it again, updating the same rows in the database wont do any harm. A load of inserts is harder, you could try rolling them back manually with a delete statement using a date field or a process identific...

If you take a closer look at your database stage you will see it supports many combinations of insert/update or update/insert or replace etc. You should be able to find a combination that handles both your inserts and updates. Be aware that your current design may be a lot more efficient. For exampl...

Ascential Developnet does not appear to be accepting my login, failing with the error: || Warning: Cannot modify header information - headers already sent by (output started at /www/sso/html/conf_prod.php:1) in /www/sso/html/common.php on line 226 Warning: Cannot modify header information - headers ...

Good luck, there are not a lot of DataStage implementations out there that would pass a security audit much less eTrust integration. I've never come across eTrust, maybe if you post your specific problem a solution could be found.

I think Ascential has connectivity to Manugistics via the DataStage TX product, which in turn can be used as a plugin to a DataStage job. You really need to contact someone at Ascential to get the details. The other option is to connect straight to the tables via ODBC or a database driver.

The project parameters file is called DSParams and DSParams.keep and it can be found in the project home directory. You need to check the read permissions on the project directory and on these two files for the login you are using. I only ever log into the Administrator tool as dsadm.