DSXchange

The login to your UNIX path (with the same userid you use from DataStage) and see what your access rights are!

Is your DataStage on Windows or UNIX?

timestamp and date columns have no format. Formatting is only necessary when converting to a string type. You can do a

Using your Windows explorer, right-mouse click on the file in question, select the properties line and then click on the security tab. You will see that your DataStage userid doesn't have read (for source) or write (for target) access rights on that file.

I've added a header and trailer in DataStage by having the job use 3 streams, one each for header, trailer and data. I use a 1-row row generator for the header/footer and a transform stage to create the line contents, then merge all 3 streams in a funnel stage and specifying the orger there.

The director screen shows the elapsed time for the last run in a column; you can use this (or the more detailed information in the log) to compute average runtimes, DataStage does not keep a running average.

Ush - I understand that you are new to DataStage, but that doesn't mean you cannot use the DSXchange Search utility to find out that both methods have already been explained in detail several times in different threads.

I just did a bit of checking for correct syntax in the modify stage and noticed that there are actually 2 simple ways to do this. If your input column is called "Test" and has [10,4] defined then NewTest1:Decimal[10,2]=Test NewTest2:Decimal[10,2]=Decimal_From_Decimal [round_inf] (Test) will both ret...

Ajay,

instead of posting this problem twice, why don't you follow your original thread here.

Moderator - please delete this duplicate thread.

Ideally, as a developer, you will not see any differences in how you analyze and design EE jobs on Windows or UNIX. There will be some differences in how you declare OS paths and also in how ODBC is initially configured and setup. Scheduling from within DataStage is quite simplistic and does not off...

Set the environment variable APT_DISABLE_COMBINATION to "true" and re-run to locate which stage is causing your abort.

How you solve this depends upon where you are calling your jobs from, i.e. where you need to dynamically retrieve your parameters. If you call your DataStage jobs from the command line, then a UNIX script that uses sed/grep/awk/perl or similar commands to parse the appropriate parameter values and t...

You will need DataStage version 7.5x2 in order to execute Parallel jobs on windows.

I just realized that this list is no longer displayed on the front page - is it available somewhere else on the site? I wanted to see how much Ray's lead in posting responses has widened.

Moderator - please delete this thread, it is a duplicate of this one.

If you are experienced in Server, then reading all the 1000+ page official PX manuals can also help quite a bit; but it won't replace getting training or assistance in the different PX methodologies. So far most of the bad PX DataStage jobs that I have seen come from ex-server developers (like mysel...