DSXchange

Red Brick can also pick up the user ID and password from the RBUSER environment variable. Since you already have a working solution this knowledge comes a bit late, but may assist someone else.

TipIf you do change LongVarChar to VarChar, also change the derivation of each such column to CAST(colname AS VARCHAR(2000)). This will avoid metadata mismatch warnings.

DECODE can have more than two options. Most databases' SQL has a CASE construct that you can use if there is no DECODE available. SELECT CASE WHEN '#CountryParameter#' = '' THEN SRC_CNTRY_CD WHEN '#CountryParameter#' IS NULL THEN SRC_CNTRY_CD ELSE '#CountryParameter#' END AS CNTRY_CODE FROM #SchemaN...

Sending data to a hashed file does not, of itself, create the hashed file. Do you have the "Create" check box checked in the Hashed File stage? If so, there should be a message in the job log indicating that the hashed file was created. Can you see such an entry? A hashed file must have at least one...

Especially check the ulimit for data and stack for the user id under which DataStage jobs run. Get your UNIX administrator to set both (and file size ulimit) to unlimited.

Welcome aboard! :D There are some databases, such as UniVerse and UniData, that allow you to have not just one value, but also more than one value in a column in a row. Typically this is a list of some kind, such as a person's qualitications or dependants' names. In the terminology of these database...

You should be able to use the XML Reader stage. Is your job compiling successfully? If not, what messages are emitted? Does your job run OK? If so, what's in the output? If not, what messages are logged? Do you have a custom style sheet and, if so, have you mentioned it in the custom properties of t...

That said, it's an unconventional database in a number of ways. The main one that will thwart your desires is that there are different record structures withnin the same table. For example, the Sequential File stage record in DS_STAGETYPES has substantially more columns than the Red Brick stage. Fur...

Still no. And the danger of publishing it is that "they" can change it at any time. And will, soon, if current gossip is correct.

DRS is a plug-in stage. It is written according to the C Plug-In API specifications.

Can you try one without the MetaSQL tags?
If that's OK, can you move the MetaSQL tags to the Derivation column in the Columns grid, and switch to generated SQL? What happens in that case?

In your original post you were specifying to use a DRS with a hashed file. Go back and read it. Using a DRS with a DataStage hashed file is not possible.

Locks are there for a reason, so it is dangerous to release them by force without some understanding of the potential ramifications. A running job will take a lock to prevent the code that it is executing from being re-compiled while it is trying to execute it. The only time that it is safe to relea...

You attempt to delete and re-create the project may have left things in an inconsistent state. You must have Administrator rights to do this. This problem is addressed in a different thread. Assuming your project is intact, use the command DS.REINDEX ALL to re-build all the indices in the Repository...

The problem here is one of incompletely deleting all references to the project from the system tables. From the Administrator client command window or from a telnet session in which you have invoked dssh , and logged in with administrator access, execute the following command: VERIFY.SQL SCHEMA Proj...

Can you tell us what other stage types you are using? In particular, what passive stage type are you using on the link that you assert is generating the error? DSP.Open is invoked when establishing a connection to data from a plug-in stage. Therefore this problem is unrelated to Transfomer stage or ...