DSXchange

Actually the Teradata Connector does not require the table to be empty for FastLoad. Whoever engineered it found a way to bypass that "requirement".

I assume that PIX(5) actually means PIC X(5). Because there is no OCCURS DEPENDING ON clause Phone_Grp will always occur exactly three times. Presumably the unused fields are blank-filled. Since the data type is string, DataStage will happily read those strings; you can filter them out (replace with...

5. I'm fairly sure that the Join stage has always supported multiple (more than two) inputs.

Without knowing the property values with which you've programmed the FTP stage, we have no way of helping you.

... unless, of course, you reset the sequence in Before/SQL.

Is there a SEQUENCE that you can invoke in the INSERT statement?

1. Don't try to shoehorn 40 characters into a 9-character space. Your approach of excising the first nine characters is the solution here, but loses data. 2. Re-define (have the DBA re-define) the target column data type. If 40 characters is the maximum you'll ever process, that's the size needed fo...

Welcome aboard. The formula using system variables is guaranteed to generate unique numbers irrespective of the number of nodes.

You could even add a job parameter with the starting value.

All specifications should be in CHARACTERS. So the number of bytes per character is not an issue.
Do your data contain any double-width Chinese characters (that is, characters that take up two display positions, such as "double happy")? If so that might be affecting your file format.

How about you start with a bit more information about what you're trying to accomplish? If it's not too long, post the WSDL.

Why not use the quoting functions Quote(), SQuote() and/or DQuote()? Self-documenting, too. Bonus!

Or, if (when) you have the Data Rules stage (version 8.7 or later) you can test using a direct matches_regex rule.

Can you apply RAWTOHEX() function when extracting?

You wouldn't have missed much of it, so I've un-premiumed it.

Creating a DataStage project doesn't require a lot of space, but be aware that the project directory will grow over time as you create more and more DataStage objects that have to be stored there. WebSphere Application Server is located wherever whoever installed it specified. You might try /opt/IBM...