DSXchange

Any two-digit year will be converted to a year in the century defined by the CENTURYPIVOT configuration parameter in uvconfig. By default this is the century 1930 through 2029. A four digit year of the form 00xx appears to be being treated as a two digit year. This is inconsistent with the behaviour...

On system B is the C compiler identical to, or 100% compatible with, the C compiler on system A? Are you totally confident that PX is correctly installed on system B? Do parallel jobs that do not involve C++ (that is, that don't have Transformer stages or Custom stages) compile OK on system B? (Thes...

One job creates one conductor process, one section leader process per processing node, and up to one process for each operator. You can reduce the total number of processes by allowing operators to combine into the same process. You can reduce the total number of processes by starting fewer jobs at ...

Some of us sleep occasionally. If you want a response within four hours, as the timings of your posts suggest, sign up with a premium support provider. Your second post is timed at 01:37 Saturday where I am. Further, you haven't really supplied enough information to aid accurate diagnosis. What (exa...

I believe that Amos is suggesting that you read the untruncated VarChar, truncate it yourself and issue warnings yourself.

If you haven't already you will need to enable the viewing of Generated OSH in the Administrator (check box on Parallel tab of project properties). You then view the generated OSH via the Generated OSH tab in job properties, after the job has been compiled.

Select from Oracle, convert the delimiter character ";" to a line terminator (x0D) and write to a Sequential File. Then read from the Sequential File. In spite of running sequentially, it's amazingly quick. Each row read from the sequential file will now have a single name=value pair. The rest is ug...

If you have MetaStage you have the files. Use a search in Windows Explorer to find them (at worst, find them on your MetaStage CD).

As far as I am aware, only the vendor offers MetaStage training. Since you have elected not to state a location in your profile, I can only direct you to the vendor's generic website - you need to find Ascential MetaStage Essentials there or on one of the region-specific web sites you can access fro...

Most of what you want can be done within the object properties. For example in a Sequential File stage you can click Load on both the Format and the Columns tab. The file name is often prefixed with a directory pathname job parameter. (Should always be, if you ask me.) In terms of the file name, the...

The SQL statement in DataStage is a single string. So, yes, it's treating everything after the -- as comment. Remove the comment completely and it should work OK. It should always have been thus - you've been relying on a bug in the earlier version that's been fixed!

If that's EBCDIC you need the ASCII() function, and not to have NLS enabled.

Have you installed the custom GUI on your client machine?

All good questions from Vincent. How would you go about it if you didn't have DataStage? (It's not a trivial problem.) A DataStage approach might be to manage the keys within DataStage during processing. An alternative approach is to select the max value once processing has been completed. Selecting...

Yes, the invocation ID must be set at run time. The only property available at design time is "Allow multiple instances". You do not, cannot, set the invocation ID at design time in the job. When you fill in the job name in the Job Activity in a job sequence, use the dot notation - jobname.invocatio...