DSXchange

Not if some of the aggregating data are generated within the ETL process itself.

You won't find it on the forum. DataStage Installation and Upgrade Guide (dsupgde.pdf) is part of the documentation set. It's installed with your client software (C:\Program Files\Ascential\DataStage\Docs) and it's on your client CD. Just out of curiosity, why do you need to reinstall? It's a highly...

Are you, or is anyone else in the organization, clearing log files using CLEAR.FILE? This is a common cause of this problem. Clearing the log file using Director, on the other hand, guarantees that there's a first entry (the one that reports that the log was cleared). What's happening is that the co...

No. There are limited ways in which server jobs can be incorporated into parallel jobs (see Parallel Job Developer's Guide , end of Chapter 2), but there's a performance penalty for doing it this way, and many restrictions on the type of server job that can be so encapsulated. You're better off, if ...

What stage type are you using? Given that it's a full outer join, either A1 or B1 might be NULL. Joins are defined the same way as in SQL. If you fail to find a row, NULL is returned. So you need, in your example, to test whether A1 is null.
(Is this really PX? Your description suggests server.)

Do you have any output constraints on that link?

Otherwise, richdhan's advice about null values seems apposite.

You get one by enrolling in the Ascential class. Any other source is illegal.

As far as I am aware, there is no MetaStage tutorial. My personal opinion is that this is not a piece of software that can be self-taught. Enrol on one of the Ascential instructor-led classes. Seriously. What MetaStage does is very high-tech, very complex, vital to understand properly so that you ca...

The short answer is no but, if you're invoking from DataStage, then the conversion could be done "up front". Some FTP clients also have the ability to translate from EBCDIC to ASCII.

David,
I think you missed it. The OP signed up with DSX only, AFTER DataStageXchange had closed. These folks currently can't get at the white papers area.

Can't find it.
Care to post a link?

You can create hashed files in any directory on any local file system. I think you know how to do this. You can create a pointer to that file using the SETFILE command. You can also create hashed files as UV tables in any directory on any local file system. The syntax of CREATE TABLE has DATA and DI...

Explore the Iconv function with conversion codes like "MX0C" and "MY" in the on-line help. Select the one that is most likely to suit your needs. Because you specify \x0001 is being loaded into CHAR(2), I'm assuming you're using ASCII or some other single-byte character set. Beware of two problems. ...

Edit the job properties of the Job Sequence, and look at the generated code on the Job Control tab. This is the code that (in compiled form) is executed when you request a job sequence run. See if this helps you to determine how the Routine Activity is calling Routine AcsDsLogBegin. For example, doe...

I've heard it argued that it helps to be certifiable to be a DataStage consultant!