DSXchange

Welcome aboard. If you read the manual or on-line help, you will learn that the CFF stage at this release does not support OCCURS DEPENDING ON or OCCURS INDEXED BY. I also note in your FD that the field PART-INDEX is not mentioned. Presumably it occurs later and you omitted to show it. Can you have ...

There is a one day certification preparation class (code DX224 ). It is being offered on the Sunday leading in to IOD 2007. Other than that, I am not aware of any specific preparation materials. The requirements for certification include completion of the class DX730 (QualityStage Essentials) plus s...

WAVES is separately purchaseable. It performs address validation by reference to a "database" (set of classification tables, really) that is kept updated by the vendor, which explains most of the additional cost. Create overrides in the usual way. There's nothing really different about how you actua...

If it really is urgent, purchase the services of a competent consultant with experience in this kind of conversion.

And then there's your assumption that tini is in the USA... Australia also has Central Time, defined as GMT +8.5 hours (some of it goes onto daylight saving in the Southern summer, some of it does not). There are some SDK Transforms for converting GMT, if my memory serves me correctly. You can also ...

The licence has expired.
Obtain a licence that has not expired.
The usual process involves giving your support provider money.

Eschew rows/sec as your measure of "performance". Prefer MB/min or simply elapsed time.

Support for attachments in the Notification Activity was introduced in version 7.5. It is not available in versions earlier than this. I can only assume (not having version 7.0 to check) that the same is true for the DSSendMail() function. However, since DSSendMail() ultimately calls the sendmail() ...

Changing T30FILE is the solution to this problem. Increase it to 1000. You will then need to stop, regenerate and restart the DataStage server. T30FILE is the total number of dynamic hashed files that can be open simultaneously. Although you assert that your job designs do not use hashed files, the ...

The error message tells you that the ODBC driver for DB2 could not be loaded on the machine where DataStage server resides. Check (using ODBC Administrator - run odbcad32 ) that a system DSN or file DSN of this name exists. DataStage can not use user DSNs. If the DSN exists, then look in the registr...

You can have them (unmapped output columns).

If RCP is on they will be blue and receive their values from identically-named input columns.
If RCP is off they will be red.
If there are no identically-named input columns you will get a fatal runtime error.

You're wrong. (You did ask!) There is only one record missing from DS_JOBOBJECTS, and it is the record relating to the job view (the design canvas). So you don't need to "pull" anything - it will suffice to re-import the job. Assuming the view definition is in the export file, all will be well. It i...

How did it get to be DECIMAL(38,10) in DataStage, if it's NUMBER(10) in the database? Did the database change after the table definition had been imported?

Perhaps your site has some metadata management issues that need to be addressed.

Use environment variable APT_STRING_PADCHAR to specify the padding character. You are right that is it is, by default, 0x00. You could change it to, say, a space character. Only CHAR data types are padded. You could also specify VARCHAR data types, which are not padded (unless writing to a fixed-wid...