DSXchange

Hello, Does anyone run Datastage v8.1 on a Development Machine? (I'm referring to Datastage on IBM's AIX using OS v5.3) Has anyone promoted code from a Datastage v8.1 to a higher datastage environment (e.g DVLP --> TEST, TEST --> PROD) which runs a Datastage version older than v8.1? Are there any co...

Sorry, my mistake

The question is about Datastage

Hello, Does anyone run Datastage v8.1 on a Development Machine? (I'm referring to Datastage on IBM's AIX using OS v5.3) Has anyone promoted code from a Datastage v8.1 to a higher datastage environment (e.g DVLP --> TEST, TEST --> PROD) which runs a Datastage version older than v8.1? Are there any co...

Hi all,
We are now planning to upgrade from version 8.0.1 to version 8.1.
We have 4 environments.
Does code generated in version 8.1 can run on version 8.0.1 without any worry?

Hi
Where can I find information about the executable file created after compilation?
I want to know in what time the last compilation Occurred
In the previous version of DataStage we have this information on the manager, but now , with only the designer I can't find any information about it

Can you collaborate more on "3.) Use hash file with combined rows"?
My source is about 100k records and my reference is about 10 million
The match possibility is 0-n
thank's

Hi
We need to perform a cursor lookup in order to find more than one row in the reference link
Our job design is a source from oracle table from one DB and another oracle table in the reference link.
Any ideas?

This was my solution also, can you explain why the cursor lookup work like that?
It smells like a bug

Yes, but I can't move my key to the RDBMS stage ,the way to do it is by using the lookup stage

I need to select all records from a DB2 table that matches the key from a flat file I've got, When trying the do it with the lookup stage and choosing the cursor lookup type, the generated program retrieves a lot of rows from the table until it encounters the rows that matches the lookup condition, ...

chulett wrote:Enable the Filter option in the stage and then put a command in the filter that returns a simple list of filenames, something like:

Code: Select all

ls -1

...

and value shuld i fill in the file name field ?

Hi I want to design a job that inserts rows into DB2 by using a relational stage, Whenever a row rejected from the database for any reason, I want to write it into a file that collects the rejected rows, I use the offer reminded in the forum (linkname.REJECTEDCODE = DSE_TRXLINK) on the constraint fo...

Hi I want to design a job that inserts rows into DB2 by using a relational stage, Whenever a row rejected from the database for any reason, I want to write this row into a file that collects the rejected rows, I use the offer reminded here (linkname.REJECTEDCODE = DSE_TRXLINK) on the constraint for ...

mohandl wrote:Hi all,
Please let me know the follwoing Questions answers

1) When MVS edition was launched
2) Any Successful projects using MVS edition getting used

Regards,
Mohan

We have used the MVS ed. successfully in projects in a couple off major banks

I'm working on the mvs edition,
Does any one know how can I change the default values of a fixed withed flat file such as unit?
I want to change the default value of unit from sysda to something else/