DSXchange

What happens when you execute the command cat /.dshome ?

Is yours an "-itag" server installation?

DSHOME must point to the Engine directory.

There is a separate manual for writing server plug-in stages called, from memory, DataStage Plug-In Writer's Guide . It does not ship with the usual set of manuals, but can be requested through your vendor. I would counsel great caution before embarking on this task. Most who have investigated have ...

Of course it's possible, except that you must have a priori knowledge of the metadata to be able to design it! This doesn't just appear out of thin air!

Clearly you did not attend one of the training classes that I ran! If you had a bad experience, do let IBM know. They seem to be quite genuine in wanting to improve the training classes.

1. "UNIX Support Systems" - a mechanism for running UNIX in a partition of a mainframe (typically AIX on OS/390).

2. The prefix used for names of vessels in the United States navy.

You need to look in the job log to find out what processes were involved.

There is an Orchestrate Operators manual among the Orchestrate manuals. Your vendor ought to be able to supply you with a set at no cost. They're also handed out on IBM's DataStage EE classes.

Surely alnum("000034A3c") would return true, since every character is alphanumeric? Where does it require a leading alphabetic character?

Mind over matter. Despite an ageing body, I still play and umpire baseball (and thereby get to think and do other things, outside "work"). And I have a number of strategies to relax, including taking an afternoon out just to play sitar.

Bulk loaders maintain their own log file and their own rejected records file. You can specify where these are. The bulk loader program (bcp in your case) processes the data file only after DataStage has finished writing rows into the data file. Thus you can not capture rows rejected by bcp within th...

Not possible out of the box. DataStage is driven by metadata. The metadata must be in place first.

If you use a UNIX sort you need to specify the UNIX sort command options that identify the sort key (usually -k, but this might be qualified by other options such as the delimiter option, the sort order option, and so on). On UNIX execute man sort to learn what the options are on your particular UNIX.

You need to make sure that every process (conductor, section leaders, players) associated with the jobs is logged out, is not holding any locks, network resources, file units or other resources.

Make the field either nullable or non-nullable consistently (both sides of the Aggregator stage and elsewhere in the job).

More generally, don't do anything that annoys the product.

From memory, the CFF stage is specifically documented as NOT handling more than one OCCURS DEPENDING ON clause.