DSXchange

There are no indexes unless you created them.

Provided you have a VOC pointer, you can use the TCL command

Port number for the dsrpcd process is, indeed, 31538 (by default) on both UNIX or Windows.

Probably the best place to look is the services file for TCP (/etc/services on UNIX, %WINNT_ROOT%\System32\drivers\etc\services on Windows).

Even so, but I thought I'd have a crack at this one purely as an intellectual exercise. My opinions follow. They are not necessarily those of my employer nor of anyone else. (1) Yes. (2) IBM has a bigger picture for Information Management than just ETL, but the DataStage ETL tool is a vital part of ...

It's IBM intellectual property when it's embedded in QualityStage, but an internet search will reveal the algorithm, from Robert L. Taft's original to the latest incarnations.

A Google search for "NYSIIS algorithm" returns over 20,000 hits.

SBSA_DW2 wrote:Does Datastage go down to table level via the view definition and retrievce the metadata or does it assume lengths and data types?

No. Just the view definition itself.

Not in a server job. At least not yet.

OK you're feeding one of the Merge stage inputs with a Reject link from a Sequential File stage. A reject link has no metadata associated with it, so you won't be able to specify the key to use to effect the merge (I suspect you want a Join in any case). Insert a Column Import stage into the Reject ...

CurrentTime()

Not possible if you have a reject link.

You can, of course, create a regular output link and use as its constraint an expression that captures rejects. But the automatic capture of rejects from database stages will no longer be available.

Your description is not clear.

Is this a server job or a parallel job? Can you please draw a picture of your job design (or publish an image of it and link to that from here)?

You will probably not be able to start the DataStage telnet service because the MKS Toolkit telnet daemon is already bound to port 23.

Try using a different port number, perhaps 2300.

telnet hostname 2300

Welcome aboard.

Why not FTP? The same volume of data will be moved.

Probably a function like TimestampFromSecondsSince() using 3600 * hours as the offset.

All you get on the reject link is the raw string (line) from the input file. You can't edit the metadata. However you can write it to a file.

Generally (world-wide) or only for one particular time zone? Do they have daylight saving time to be taken into consideration?