DSXchange

What DataStage role has been assigned to "We"?

Gosh, that's also what IBM recommend in their manual.

That's an easy one. There is no difference (unless, perhaps, they have fixed any bugs).

Study the topic "dynamic arrays" in the DataStage BASIC manual. All will be revealed.

Thank you for sharing that. Everything you require is possible. And probably without using any exclamation marks at all.

Try putting the right hand operand for the concatenation operator in quotes. Trim(Trim(Trim(Trim(Trim(Trim(Trim(Trim(Trim(Trim(Trim(Trim (Column_Name),'','L'),'#','L'),'+','L'),'.','L'),'//','L'),'/','L'),'\','L'),'`','L'),'','L'),'','T'),'*','L'):'20' Use a single Convert() function to get rid of t...

What's the row count and the approximate corresponding volume of data? What are your trying to do with these data in the job?

Transformer stage, nested If..Then..Else structure.

If you're new to DataStage hire an experienced practitioner (perhaps from IBM, perhaps not) to do the upgrade and to mentor you in the process. It is long and complex, and fraught with little traps (like a spurious error message about unsupported operating system) that aren't documented.

Hi Guys , Can U plzz tel me in detail how to migrate the jobs from DS 7.5.2 Server edition to DS 8.1 Parallel edition as i am new to datastage and my task is to do migration.If u can explain me in detail That will be a great help. Thanks I don't know that U could do that. U is only a developer; he ...

Looks like you don't have access to the folder where the performance data XML files are to be captured (or the folder does not exist). Or maybe the XML files do exist but you don't have any permission to them.

Double click on the row number. Alternately right click on the row in the grid and choose Edit Row. Either of these will open the extended properties window.

Once you get to version 8 you will have the istool command to add to your list.

Surely all the details of these are in the pertinent manuals?

Every process - conductor, section leaders, players - in a parallel job runs osh.exe - it is the shell of the parallel execution engine. They should go away when that process finishes or, in some cases, when the conductor process performs its final cleanup of the job.

Note that a Funnel stage implements UNION ALL. You may require a downstream Remove Duplicates stage to remove duplicates.