DSXchange

This is a piece of text extracted from the Datastage help (F1). User Variables activity properties Use the user variable stage to define global variables within a sequence. These variables can then be used elsewhere in the sequence, for example to set job parameters. Variables are used in the form s...

It's not a counted loop. I'm building a sequence using the loop/endloop activities to loop through a string - list of tablenames delimmited by commas. I need a variable to use as counter. The example you gave doesn't show how to change the original value. The manual says clearly that it can be done ...

Hi Ray, Thanks for you reply. What we have here is two UDVs activities : UDV1 and UDV2 in the UDV1, there's a variable x and it's content is initalized with 0. In the next UDV2 (within a loop), theres a variable y and its expression is UDV1.x = UDV1.x + 1. Pretty simple and it compiles although afte...

Hello Just wondering if anyone has been successful in changing the content of user defined variable by other downstream user defined variable activity. Basically, I am trying to implement is a loop that increments a user defined variable. The datastage help says it can be done but it hasn't work for...

We have just installed 8.5 and are learning and testing it's capabilities. We successfully migrated very simple jobs from 8.1.2 into 8.5 and used the Oracle Connector Migration tool to convert Oracle Enterprise stages to Oracle Connector stages. It worked wonderfully and so simply. We then decided t...