DSXchange

The Peek stage is intended to capture a sample of rows. If used as a target with no output link, all it can do is to capture that sample. It will write those few records into entries in the job log.

Use DataStage/SQL to insert new category records in DS_JOBS. From the operating system use the dssh command, and enclose the SQL in double quotes. Category records have a key of \\\category, have NRO in the READONLY column and the category in the CATEGORY column. Some examples, for the categories D...

The port number is 31538 for version 6.0 and later, 31438 for version 5.2 and earlier. You can find this with a command such as

Other port numbers are used for parallel jobs but, since you asked in the server forum, the above is a complete answer.

If you like. It's a good technique when incrementally developing a job. The Peek stage will eat all the rows you send to it, and send a sample of them to events in the job log.

What's your warnings limit? A value of 1 could certainly manifest this situation.

It may mean that your conversion from EBCDIC to ASCII was not done correctly. You don't convert binary (COMP) columns, for example.

There's nowhere else that a job name is stored, unless the CATEGORY index on DS_JOBS is out of date. But then a query on DS_JOBS would return strange results - errors maybe - if constrained on CATEGORY. I've run out of ideas on this one. If I get time I'll try to reproduce what you've done with an e...

Brain fart. Sorry.

ONLY if it is a string. If it is a date, you need to apply a date to string conversion function first.

There are other functions available that will extract date components directly from dates.

Define performance. Also, what network bandwidth is available between the putative multiple systems?

Transformer or Filter stage with 26 outputs (one for each letter) and one rejects/otherwise link.

A Switch stage is not appropriate; it switches on specific values, so you might need 140000 separate switch conditions!

Yes, but not in every record type. The record that holds the job name has as its key J\nnnn\ROOT where nnnn is the job number. The job name is in field #3, which has the column name NAME. But, for a clean removal, you must remove all objects that are part of the job. You can find the name and job nu...

You might have a whole lot of "@" characters, you may have a whole lot of NUL characters (0x00). Switch to hex mode to determine which it is.

Connector is not available until version 8.x.