DSXchange

You could partition the single-row maximum value using Entire partitioning algorithm. That way it would be the same on every node.

You can execute DS.REINDEX ALL from the Administrator client Command window. Just be sure that you have exclusive access to the project.

As Arnd says, this may not the the entire fix required but, then again, it may be. Worth trying, in any case.

"Can't see it" is usually a symptom that the repository needs re-indexing. Or it may be that your local DataStage repository has somehow gotten out of synchronization with the XMETA common repository. It won't do any harm to try DS.REINDEX ALL against your DataStage repository, if you have exclusive...

There are only two new stages in version 8.0 (call it 8.0.0); the Connector stage and the Slowly Changing Dimension stage. The Lookup stage has been enhanced to support range lookups, either on the stream or on the reference input link. New stages can come along at any time. For example a Teradata E...

Hi again, Suppose I have a column with 5 japanese characters with Single byte kana (Katakana). That should be converted to 10 Japanese characters with double byte kana. I am not sure how it can be done in DataStage since there is no conversion function like that. Can anyone help me out on this issu...

There's no way to prevent it, apart from making sure that the hashed file name is not the same as the link name. I too find this "feature" annoying. I'd prefer the old way (pre version 4 if my memory serves) where the file name was not tied to the link name at all - but lazy developers complained th...

"Use" the table name? That's a bit vague. You can pass the table name as an argument. You can load up the table name into a job parameter or environment variable and interrogate that. You can use a number of system variables, like @USER0. The best approach may even be to have the routine code interr...

Each column in the record schema has a Drop On Input property that you can use to specify that that particular column does not get read into the job.

This is only true in the parallel job Sequential File stage.

Grammar Check Ajay, The second person personal pronoun in English is spelled "you", not "u". U is a common Burmese name, and is the name of one of the posters on DSXchange. The appropriate present tense form of the verb "to be" is spelled "are", not "r". The second person personal possessive pronou...

I produced such a document for one of my clients. It runs to 215 pages. There is a lot that is different. Unfortunately, this document is covered by a non-disclosure agreement. Contact IBM through your sales rep; they should be able to provide a "what's new" document. One ships with the version 8.0 ...

Almost certainly your repository database needs to be reindexed. When you can get exclusive access to the project, connect with the Administrator client and execute this command in the Command window.

Setting the second argument (ErrorCode) of an after-job routine will abort the job. If you are using ExecSH or ExecDOS it should be sufficient to execute a command that will fail, for example mr mxyzpltk

Let's assume that the project directory exists, and that there is a correct entry in UV.ACCOUNT for it but no entry for it in UV_SCHEMA. To determine whether that is the case, use VERIFY.SQL with the SCHEMA keyword, the pathname of the project directory (note: NOT the project name) and without the F...

Begin by determining that there is an entry for the project in both the UV.ACCOUNT and UV_SCHEMA system tables. SELECT @ID,PATH FROM UV.ACCOUNT WHERE @ID = '<<ProjectName>>'; SELECT SCHEMA_NAME, PATH FROM UV_SCHEMA WHERE SCHEMA_NAME = '<<ProjectName>>'; Let's make sure that your Step 1 is correct ne...

A Connector is something new in version 8, in which you can store the connection/authentication information as a re-usable component in the Repository. The plug-in stage is a typical stage, where the connection/authentication information has to be supplied to the stage at design time (perhaps via jo...