DSXchange

Plan your If .. Then .. Else .. constructs, and use the Expression Editor to build them. In this way you will not be left with a dangling clause in the expression. And, Bobby, can you please write in English? These SMS-style expressions are difficult for those participants whose first language is no...

Have you got the correct option button selected?

That is, are you filtering on owner or on table name?

Hi, I have some doubts on HashFile option of Normalize-on/Un normalize for Outputs HashFile. -When should be use this option ? -What is the purpose of using Normalize-on? -How to decide on which field we will normalize? Regards, Rajendran The decision is initially not in your hands. "Normalize on" ...

Here's a shell script I threw together this morning to report (from a UNIX shell) whether a hashed file uses 32-bit or 64-bit internal pointers. It only handles "Type 0" machines (no byte-swapping, therefore no Intel). Maybe when I find more time... If you want to do this from a Routine or the TCL e...

He does indeed mean log in as root.

Mukund is running version 5.x.

Build error checking into every sequence. A parent sequence can check it's child processes' exit status. You can use a custom trigger based on exit status, or you can use a Command or Routine activity to capture the status. It's very difficult to do from the operating system, because you need to be ...

To clarify, Display Width has two purposes. This has been the case since version 1.0. The "minimize" in version 7.x was a glitch. One is to set the initial display width for the Data Browser. The other, applicable only to Sequential File stage where the format specifies fixed width, is to be the sto...

Yes, no, maybe.

Define performance.

Tell us what the multiple processes are doing.

Check out the PX benchmark on Ascential's web site (700+ GB/hour), then ask again about multiple processes!

It definitely does no harm. I always use stage variables if there's any likelihood that that particular evaluation may need to occur more than once - for example in multiple output columns and/or links, or in output constraint and output column derivation. The only place I'd advise against using a s...

You are trying to configure ODBC access from DataStage to SQL Server. DataStage is running on UNIX (according to your original post). There is NO Control Panel for UNIX ! So it all has to be done with ini files and the like (just like ancient versions of Windows!). The DataStage engine is the client...

It's not possible in before stage.

You do not have the column value until the stage itself has begun processing rows.

Do you mean the column NAME ?

That description suggests that you DO want to use the value in each row to delete from the other table. I understand from your description that you don't want to commit individual DELETE commands (one per row). This you would need to manage via "rows per transaction" being set to "all" (0), so that ...

More generally the rules are as follows. A passive stage can not open its output(s) until all its inputs are closed (the IPC stage being a notable exception). This is why it is possible to pre-load a hashed file in the same job that uses it. An active stage can not open its output(s) until and unles...

Jobs do not need to be recompiled if Routines change. Routines are stand-alone components, which are compiled separately. Jobs DO need to be recompiled if Transforms change. Transforms are encapsulated expressions which become part of the in-line job code when used. Transforms are not compiled separ...

Yes, you also need to define the DSN in .odbc.ini; I assumed that you had done that when you claimed to have "created a data source name".

How DID you "create a data source name" on a UNIX machine if you didn't edit .odbc.ini?