DSXchange

Not to derail this, but... Ray, I could have sworn in the past you've said that DataStage was an odd duck in that it did not enforce any precedence when evaluating expressions? That it is, without parens, evaluated strictly from left to right. Am I mis-remembering? I was talking about logic, not ar...

Hi All, We are using PX 7.0 with Oracle 9i currently we don't have any indexs on our database. As an enhancement we are palnning to add some indexes on most of the tables. we would like to know where this will affect the DS performanace. do we need to do any changes in our ETL jobs. FYI ..our PX se...

In passive stages there are fields that are usually job parameters, suchy as DSN, user name, password, filename. It would be nice to be able to select job parameters from a list, rather than to have to type them in accurately. This exists in parallel job stages - a tool takes you to a menu that incl...

Date/time created, modified and deleted are all stored in a table called DS_AUDIT. Constrain on the column called INSTANCE which, for jobs, contains the job name. SELECT DTC, CREATOR FROM DS_AUDIT WHERE INSTANCE = '<<JobName>>'; SELECT DTM, MODIFIER FROM UNNEST DS_AUDIT ON MODS WHERE INSTANCE = '<<J...

Search the forum for techniques for remembering values from the prior row and detecting change in a column using stage variables. It can all be done with these.

None. Unless you consider a system backup to be an external utility.

MetaStage lineage analysis will track through the name changes.

When you learned arithmetic at school, what did they teach you about precedence? What's the difference between these two expressions? CurrentDate - HireDate / 7 (CurrentDate - HireDate) / 7 The second of these will provide what you seek provided both dates are in DataStage internal format. However, ...

The Palette is meant to be empty if you have no jobs open. It can't determine which Palette to display until a job of a particular type (e.g. server, job sequence, parallel) is selected.

The first argument of DSExecute is the shell name, you've used UV which is a variable name. That's fine so long as you've assigned the value "UV" or "DOS" or "UNIX" to that variable, but a more meaningful variable name is warranted. The second argument is whatever must be executed. If Arg1 (another ...

Welcome aboard! :D We don't do "urgent" here. It is an all-volunteer site. If you want urgent, sign up for premium support with your support provider. Urgent is expensive. Click on the link to the October newsletter (on the home page at the time I post this) for more information about how to get bes...

No.

They don't supply DS for MKS or Cygwin.

Try using the IP address rather than the host name in the DataStage connection dialog.

Let us know how you fared.

Windows doesn't use mutex locks, so it won't be a problem there.

Search for mutex and/or SPINTRIES, I posted a description of what's happening. A good exact search term might be "smart semaphore".

It's normally populated with those servers from which you have imported table definitions.