DSXchange

To summarize:

Get Red Brick Warehouse! World's best bulk loader, and automatic maintenance of aggregates.

(Is Aggre Gates the name of Bill's next child?)

What the message is telling you is that, in the 390 environment, DataStage will not allow two active stage types to be connected together; more exactly, that the Merge stage can not have an active stage type feeding its inputs. Consider the Join stage. Alternately, and probably better for your desig...

Have you tried CAST (ClobColumn AS LONGVARCHAR(60000)) in your extraction SQL? Just a thought.

For example [Tue Dec 9 2003] versus [Wed Dec 10 2003].

There are many variations on this. Here's just one solution. Note, though, that you need to do these transformations in a Transformer stage; in server jobs a Sequential File stage accesses data in the text file, without modifying it. Version 6 will allow you to pass the data through a filter, such a...

No, you wouldn't be expected to understand. $DSP.GetNext is the subroutine that retrieves the next row from the source. For some reason this has generated a fault type 11. _T0000 is the name of a temporary variable, and REJECTEDCODE is assigned in the event of an error. It's at this point you need t...

If you execute the UniVerse (DataStage Engine) command

you will be able to determine the statement that is executing at address b0. This may assist your diagnosis.

Reset the job, and look for an event in the log called something like "from previous run...". Alternately, find the records for the job and stage in the &PH& directory (in the project directory on the server). Post your findings. Without them, there is insufficient information for an informed diagno...

DataStage is three ETL products in one. Server jobs (with which you are becoming involved) generate BASIC and execute in the DataStage Engine environment. Parallel Extender is the result of Ascential's acquisition of Torrent Systems and their Orchestrate technology, which allows really huge volumes ...

Search on this forum for the topic BCI, you will find code samples. However, these require that your ODBC driver for Oracle be licensed. If you're on a Windows platform this isn't a problem, but I note that you're on a UNIX platform. ODBC licences shipped with DataStage are not licensed for use with...

... or you can write to a sequential file and then run a DataStage job to update the database. You might need to do this if you do not have ODBC drivers licensed for non-DataStage stage use.

For the UniVerse (DataStage Engine) database OPEN, READ, WRITE and CLOSE will do the job. For any other database for which you can establish an ODBC connection you can use the BCI functions. In this case you have to program using the conventions of the ODBC API, namely: allocate memory for environme...

:roll: Right now we are trying to resolve an issue with Ascential, in which they assert that ANY screen shot is their copyright and/or intellectual property. Negotiations have been taking place (with huge hiatuses on their part) since last May. It's lawyers, not technology that's the current proble...

Being a bit of a technology Luddite, I also use Print Screen (or Alt Print Screen), and tidy the image if necessary using that high-tech utility MS Paint! Works for me! Then paste into Word, or Powerpoint, or Acrobat.

Have you read the caveat in the long description of the Transform? In particular, are you using the same Transform more than once in the same process-chain in the job? You may find it easier/better to use a pair of stage variables in a Transfomer stage to detect change; and this approach does not us...