DSXchange

Don't know of one. You could of course modify your "list of things" so that it also includes the ordinal number.

Unfortunately developing quality training is a highly time consuming process and not, of itself, productive of revenue, so it's something bean counters tend to frown upon. It takes about 40 hours to produce one hour of good instructor-led training, about 60 hours for self-paced training, and somewhe...

This was also in the recent DSXchange webinar on Parameter Sets.

Vertical pivot.

You can not use 8 or 9 in octal constants.

You have a routine with an improper entry as a Parallel Routine.

Welcome aboard.

Probably the easiest solution is to create a routine that passes the value through unaltered, but invokes DSSendMail() - conditionally perhaps - when it's invoked.

Or, depending on the deal with the vendor, the software may have been supplied on a DVD. Check with the vendor/reseller.

In server jobs you're wrong. DataStage server jobs always return the smallest possible string from any arithmetic operation - this means trimming leading and trailing non-significant zeroes, whether you want that or not.

One small correction. I do have my own curriculum (which I happen to think is better than IBM's). Some of it fits niches that IBM's does not, some of it competes head to head. See my website for more information. I am only forced to use IBM's curriculum when contracting to IBM to present their train...

Use a Folder stage to read the file. This way you can get the file name. Then you can use a Row Splitter stage to get the separate records.

As noted in your other thread, _qsC_StateAbbreviation_USAREA should have been included in the output of the standardization job. I trust that you did perform standardization using the same rule set that you are trying to use for Match?

Please mark this thread as Resolved

Search for APT_STRING_PADCHAR environment variable.