DSXchange

Not bad as far as it goes, but it doesn't really explain the terms. They are all values that can be set when the hashed file is created or subsequently when the hashed file is tuned. MINIMUM.MODULUS is the smallest number of groups that the hashed file is permitted to have. Its default value is 1. T...

If you have QualityStage, you have the installation media from which you can install the QualityStage plug-in for DataStage, and the qsrtmngr component that needs to be installed on the DataStage server machine. Also on this CD will be all the documentation for using the plug-in stage; essentially, ...

Welcome aboard. :D The PeopleSoft PACK that you can buy from PeopleSoft consists only of server jobs and associated table definitions and routines. While you CAN access the Oracle tables on which you have PeopleSoft running from parallel jobs, there are no short cuts. You would have to import the Or...

Read the manual for the Pivot stage (pivot.pdf).
You may need to create an artificial pivot key column upstream of the Pivot stage, and discard it afterwards.

The best solution will be one that uses no views at all. Second best is to use materialized views. If you use a standard view you have first to execute the SELECT statement that defines the view before you can even begin to select rows from the view (that is, from the result set of its defining quer...

Your DataStage client is not establishing a connection to your DataStage server within 60 seconds.

Can you ping this IP address from a CMD shell?
Can you telnet to the UNIX machine?
Is the DataStage RPC daemon (dsprcd) running on the DataStage server machine?

Try "%dd-%mmm-%20yy"

You can use the Print dialog from Director (check Print To File). You can create a DataStage job to do it. You can create a routine using the DataStage API - depending on what you want you may need various of the DSGetLog... functions. However, it's probable that most of the details you require are ...

The fundamental requirement is that the hashed file has an entry in the VOC file. This will be the case automatically if you created the hashed file in the account (project), but not if you created the hashed file in a directory. In the latter case, you will need to create a VOC entry using the SETF...

Then my final sentence applies.

Are you connected as a user who has administrative privileges (dsadm or root)?

Mistakes made in development or training do not cause loss of face. They cause learning.

Thank you for posting your resolution. It would not have been possible for us to detect that situation. Consider how much your detective skills have improved!

You can run anything that has a command line interface from DataStage.

But why would you want to run an ETL tool from an ETL tool?!!

This most likely indicates one of the following possibilities:
1) the import schema you specified is incorrect
2) invalid data (the schema is correct, but there is an error in the data).