DSXchange

I have just been playing with the Language Pack for DataStage, a separately licensed component that gives one the capability to effect transliteration or translation on language. What you get is a new stage type, called the Language stage. This stage operates in one of two modes, called transliterat...

Is there a line terminator at the end of line number 101?

Either of those would be very unusual as a record delimiter! Are you sure you aren't confusing the properties Record Delimiter and Field Delimiter?

Use a three-digit decimal ASCII code, namely 032.

Only the RMM (Read My Mind) stage. You cannot effect transformation without naming the columns in the transformation, with very limited exceptions in the Modify stage (which does not have If..Then..Else capability).

The only way to achieve that would be to have the projects on different tiers. Engine credentials are set per-Engine.

Welcome aboard.

1. This is not a WTX (formerly DataStage TX) question.

2. Sequences do not execute in parallel. Just that. There is one sequence of control, not many.

3. What exactly do you wish to accomplish?

Welcome aboard. XML is free-format. DataStage does not generate "pretty" XML - it generates functional XML. There are lots of tools out there for prettifying XML.

Setting the Message Read property to "Keep" prescribes precisely this behaviour. If you want to destroy the messages on the input queue, change the Message Read property.

You should be able to generate this using Metadata Workbench. There's nothing in the dsjob command that will do it.

The default in Connector stages is SELECT and FROM clauses only.
To get a WHERE clause you need either the Builder or user-defined SQL.

You will find the source code for ExecSH in the Routines branch of the Repository. Use QuickFind to find it.

You should really be asking whoever is providing data into the queue. It does look somewhat like an EOW marker.

Easily. Calculate the Flag1, Flag2 and Flag3 column in an upstream Transformer stage. Flag1 <== (col1 = 1) Flag2 <== (col1 = 2) Flag3 <== (col1 = 3) Sum these in Aggregator stage. You may also need to create a dummy grouping column that contains a constant (the Aggregator stage should have a groupin...

How long does it take Optim alone to perform this masking? DataStage data masking acts as a wrapper that processes the data and invokes Optim data masking. So you'd expect some overhead but probably not a lot. How complex are the masking algorithms? Keep in mind that you can require that the statist...