DSXchange

The repository tables for DataStage version 9.1 are, essentially, the same as for versions earlier than 9.1. There are two repositories, in fact. There is the local, project, repository, which is the original design (from version 1.0), and there is the common metadata repository introduced by IBM in...

That's what the Terminator activity is for. You have a small amount of research ahead of you.

The number of records in a Data Set is given by If you want just the number use the -n option

In DataStage BASIC (and therefore in sequences) you have ByteLen() rather than RawLength(). There is also LenDP() which is the length of a string in terms of the number of character positions needed to display it, catering primarily for double width characters encountered in some Asian character set...

Welcome aboard. In this case it is your expectation that needs to be managed. You have three input rows and three pivoted columns. This is correct behaviour.

What you are trying to achieve can be accomplished using a Transformer stage.

Somewhat off topic (more a data quality issue), why does IN decode to "Pakistan"?

Concatenate is a string operator.

If applied to a Date data type then an implicit conversion to String is performed.

There is no implicit conversion for going the other way (string to date) so you have to specify an explicit data type conversion function such as StringToDate().

You have to split the date from the time and convert them separately. DataStage BASIC has no knowledge of timestamps in any form. And, in particular, there is no internal format of a timestamp in DataStage BASIC. Curiously, perhaps, the supplied SDK Transforms and Routines do provide such a thing, t...

chulett wrote:You can't with DataStage out of the box, true. A script is not the only solution however, a custom routine could be written to do this.

Search DSXchange for DSSendMail to learn how to do it.

Pretty sure this is coming from somewhere on your UNIX system, perhaps from some add-on security module. Do you get the same message when logging in via a telnet session?

Here's how to get SubVersion up and running with Information Server Manager. This was done on a version 8.5 site, but should still be current. A newer version of SubVersion's Eclipse plug-in probably exists by now. Open Information Server Manager. From the Help menu choose Software Updates ; from it...

I would use Transformer stage for this requirement, either using LastRecordInGroup(col1) as a constraint expression or following the Transformer with a Remove Duplicates stage set to "Last" and grouping on col1.
Within the Transformer populate the column if the incoming value is non-empty.

Assuming you're using a Connector stage, there are check boxes on the reject tab (when you have the reject link selected in the stage editor) to specify what you wish to appear on the rejects link. By default nothing is selected.

Perfectly. These routines have been in use since version 3.

Which activity in the sequence throws this error? What is the complete error message?