DSXchange

You give your vendor lots of $$$$, they provide the software, whether by download or on CD/DVD or other media. That's how it works. Given that you are in a reseller arrangement, IBM will not talk to you. That's their rules - they seek to keep the reseller "in the loop" with regards to any problems y...

Rather than asking "will it work?" why not try it?

DataStage database stages themselves use cursors or similar techniques, so that you don't have to.

Is hashed file write cache enabled on one system and not on the other? Have you tried pre-sizing the hashed file - creating with a non-default MINIMUM.MODULUS value? Are you using rows/sec as your metric? Please report the run time of the Transformer stage (rather than the run time for the job) for ...

Otherwise two output links from the Transformer stage, each into the DB2 stage. One link manages the deletes, the other manages the inserts.

i have to abort the job in Afterjob sub routine ..... can this be done??.... how can i use this ???.. 1. Why? All rows that have been sent to the database have been committed by the time an after job subroutine is being executed. Aborting a job in an after job subroutine makes as much sense as buyi...

Search the forum. You will learn that IDoc access is supported, but through a separately-purchased component.

It must be the directory that contains the file whose name ends in ".dsp". This might be on the CD, or it might be that you have copied the CD to disk.

Set the environment variable APT_STARTUP_STATUS to True to see what's involved in the startup phase. Or you could take the Advanced DataStage class. It's quite complex; kumar_s did not mention composing the score, distributing the score, checking licensing, just to mention a few. As to the source of...

For (distant) historical reasons - teletypewriters only had upper case - UniVerse has always had case inversion switched ON by default. It made sense, because most identifiers, table names and so on were upper case, so you used the Shift key less often. DSguruji has shown you the command to disable ...

Research in The Adventures of Barry McKenzie

Try IBM DeveloperWorks - there are forums there for DB2/UDB questions.

Please post this rogue query. How large and complex are the views? How large and complex is the join between the two views? As an exercise in resource estimation, create the query without reference to the views - that is, with direct reference to the queries that define the views. That exercise may ...

The answer to the original question, whether variables declared to be in a COMMON area of memory can be used in the same job, is maybe. The rule is that they can be used repeatedly in the same process . For example, the before-stage subroutine, any routines called, and the after-stage subroutine in ...

I have not used any Australian native or Maori words thus far. Nor do I go searching for words; every word I've ever posted here is in my own vocabulary or is a technical term from the product suite. There is certainly scope. For example one Australian language has a word for "there he goes, foaming...