DSXchange

Maybe you are not loading data correctly?

The error message is not helpful. Please provide more details from the logs, especially the warning messages before this failure message.

This feature should either be available now, OR coming soon. I have not touched 7.5a, so I am not sure if it's available for that version.

The input dataset does not have ACCT_NBR.

Check your metadata in the job.

If you can call the stored procedure in SQL, you can do it in DataStage.

Since you're using Oracle, there's a Stored Procedure Stage on DataStage EE 7.5 that can do what you need.

Also, why not just use the stored procedure stage to check whether it should run or not?

Try not using UNION. Pull it using 3 distinct Teradata stages, and join them (using funnel, if it's a pure UNION, lookup/merge/join if it's actually a single SQL statement joining tables). See how the performance is. It's worth a try.

Do read the following DataStage document: man_gde.cfg (DataStage Manager Guide), chapter 11 - "The Parallel Engine Configuration File".

May I suggest that you contact Ascential for some beginning training on how Parallel Extender (EE) works for students who have previously used Server? One option is "DataStage Essentials for Enterprise Edition for rev 7.x", which you could find more information about on the following site:...

Trust Ray on this. Sure you could hack together a solution using EE, but I really really really advise that you don't. Stick to ProfileStage or AuditStage. You can build something in minutes that would take a couple hours or more under EE.

I sense that one thing needs to be clarified: Parallel jobs does not equal to Server jobs. You must develop a new job using the Parallel palette in order to take full advantage of EE. Copying over the Server to a Parallel job will not work. You may see a modest performance boost in running Server in...

Land it to a sequential file in server. In PX, pull it and use a regular lookup stage. Won't that result in the same or poorer performance than the hashed file in a server container? It will out-perform the hash file within a server container, especially if you have a very decent disk I/O throughpu...

If you can call the PL/SQL procedure within SQL, you can call it within DataStage. (See: Using calls within SELECT statements). There is also an Oracle Stored Procedure stage (and soon-to-be DB2 if that's not out already). Just don't expect to be able to control it very much like you do in SQL Navig...

Where's your C++ compiler?

##W TBLD 001014 07:05:40(002) <main_program> Error when checking composite operator: Output from subprocess: sh: /opt/SUNWspro/bin/CC: not found

Only Redhat AS 2.3 is supported at this time.

Again, you MUST purchase a license before installing DataStage.

By default, it runs in parallel. You can force it to run in sequential mode, just as you can with any stages.

Land it to a sequential file in server. In PX, pull it and use a regular lookup stage.