DSXchange

That response is bewildering! Force Compile exists for parallel jobs. If you change a parallel job but do not change an already compiled Transformer or Build stage, then an ordinary compile does not re-compile these stage types. Force Compile guarantees that they are re-compiled and re-linked, even ...

In this case I usually make the parameter a List type to prevent operators inadvertently supplying an incorrect value.

True... IF you happen to know the eCase number.

True... IF you happen to know the eCase number.

I don't believe there is from EE. I don't know enough about Federation Server but would assume that the answer is no there also, unless your DB2/390 has hooks to the COBOL functions. Ultimately, you need a COBOL program to call a COBOL function.

Your support provider can be tasked with determining whether there are any patches related to getting metadata from Netezza.

There's both the manual Parallel Job Advanced Developer's Guide and on-line help. The first step is to decide what you need to achieve. The second step is to determine that none of the existing stages can do the job (there's a lot of capability there). Only then would you contemplate a custom stage ...

Note that this technique is appropriate only for UNIX-hosted DataStage (or UniVerse) systems, not Windows-based ones.

Administering UniVerse (version 9.6) page 14-14.

PI/Open still exists. Prime INFORMATION still exists. They were among the databases that Informix sold to IBM in 2001. No-one is going to take the time to explain what everything in $DSHOME/bin does. You use very few of them directly - they support what the engine does. Occasionally you will find on...

How exactly did you specify the Filter Command?

The message indicates that the SQL on the reference input has returned more than one row. However, in DataStage only one row is accepted, and it chooses (is designed) to use the last row selected. Perhaps you could design the query to return only one row; this will run faster; or use an ODBC stage i...

What exact release?

I have seen that happen occasionally in 7.5.2 and 7.5x2, but don't know why. Restarting the client clears the problem. Sometimes (rarely) you get to see an OLE Automation error message box flash past.

I definitely advocate guaranteeing RI within the ETL tool.

Do not rely upon database errors to check RI. For one thing, it's slow.

1. From a DataStage perspective nothing whatsoever. But, if you read a history of the UniVerse product and VMARK Software, Inc., you will know that UniVerse was created to capture some of Prime's market share, so it had to be able to do what Prime INFORMATION did. 2. IBM will probably deny that ther...

Yes, but it involves writing an after-job subroutine. You may as well use ExecSH as the after-job subroutine to execute a UNIX mv command.