DSXchange

I believe that your approach - using FTP and comparing locally - is the only one that will work. How can you get the Compare stage even to refer to something in a different LPAR? However, I'd be quite happy to be proven wrong on this one.

How about FINDSTR, which is a partial match in a dynamic array? You have to convert your delimiters to dynamic array delimiters. TempString = Convert("*", @FM, InString) FindStr "CA" In TempString Setting FMC,VMC,SMC Then Ans = TempString<FMC> End Else Ans = "" ...

Here's one example, following ISO 8601 standard for presenting date and time. *strat of MYCODE here Call DSLogInfo("FileName: ":FileName, "MYCODE") Call DSLogInfo("AccessTime : ":Oconv(AccessTime,"MTS:") , "MYCODE") Call DSLog...

At Ascential Developer Net they announced that certification would be available in Q4 2004 (they'd better hurry!), and provide an email address where you can seek more information, namely Certification@Ascential.com

What have you read in on-line help (topic Exception Activity Properties)?
What have you read in the DataStage Designer's Guide (coredev.pdf), particularly page 6-24?

What else do you need to know? The above seem entirely clear to me.

Welcome aboard! :D The Aggregator stage, as you'll discover by searching this Forum, is notorious for not coping with large (or even medium) volumes of unsorted data. Workarounds are: pre-sort the data to be aggregated (for example using ORDER BY when selecting from a database) - but avoid the Sort ...

Try

insead of

The Fmt function delivers the six decimal places with trailing zeroes.

How long is a piece of string? You have 2600 osh processes (which does seem a lot on an 8 CPU machine!). On average that's 33MB of swap (85GB/2600) per osh process. You say that you have "heavy" processing. In that case, maybe 33MB isn't unreasonable. What "load" do you want to reduce? Your machine ...

Given that it's complaining about !/bin/vsh, it may also be the case that a script has not been correctly formed. The first line of any QualityStage script should be #!/bin/vsh (note the # character designating a comment).

When you install QualityStage, one of the installation steps is to create a symbolic link called /bin/vsh that points to the Bourne shell (usually /bin/sh).

See page 1-5 of the QualityStage UNIX, Linux and Windows NT Server Guide.

Did you ("they") do this?

Logical partitions are a way of making one set of hardware behave as if it's more than one. I am not aware of any way of processing from more than one LPAR at a time from one process. Why not try it, and let us know? PX runs in multiple processes, and can run in an MPP environment. However, whether ...

Only if you post your job design to show us how you are detecting existence of the row in the target table. Wrap your design in Code tags (which gives a fixed width font) and play with Preview until it's obvious that your design is clear to someone else. For example: HashedFile1 HashedFile2 | ^ | | ...

We use a BAT file that exports to a shared drive (one that is backed up daily), first taking a copy of yesterday's export. So at any time we've got DSExport.dsx and DSExport.dsx.bak on disk, and anything older can be recovered from backup. We don't bother with compression; there's plenty of free dis...

RT_LOGnn is almost certainly corrupted. Did it reach 2GB? Have you been purging it regularly? A very large log can give the impression of Directory hanging; it performs a full table scan to find those records that satisfy the current filter setting. It wasn't really hanging; it was waiting. And you ...

There's nothing really direct. You could push them into MetaStage, then import them from there using QualityStage Designer (open the DataFile Definitions part of a QS project, choose File > Import > Datafile Definition > From MetaStage). Some time ago I created DataStage BASIC code to dump table def...