DSXchange

I have been asked to do an upgrade from version 4 to 7. Having not even been born when version 4 was around I wonder what are the major problems I will encounter.

I have searched the forum but not found anything really specific to v4 but have heard that v4 hash tables are going to be awkward.

Do I have to stage it via a different version for example v5

I am waiting to speak to the customer to get more information (platform, data vols, stages used etc) but am writing this to get a head start.

Any info greatly received

Tx

pls give more information i.e Both( versioin 4 and 7.5.x) OS and Databases information required.

The DataStage hashed files have not changed, so there ought not be issues there. It used to be possible to change DataStage job parameter values within the job and this was occasionally taken advantage of; this will no longer work at version 7.

The best way to do that is to create back ups(export) of your projects (.dsx) files. Uninstall version 4. Install version 7.x, and import your projects (.dsx)files in version 7.x.

There is no upgrade available from verison 4 to version 7.x. At least did not existed when I tried to upgrade over a year ago.

Link ordering is a critical issue. You will have to go thru every job and make sure your link ordering is correct. The reject link has to be the last link in the order.

You will also have to make sure that all functions do not manipulate passed arguments. This change requires you to edit each function and rename the argument variables to something else, then inside the function logic you can copy the argument to the original name as a local variable.

Ex: Old function had Arg1 and inside the function it did Arg1 = TRIM(Arg1). This is now illegal. Fix it by changing argument Arg1 to NewArg1 and inside the logic put a line at the top of Arg1=TRIM(NewArg1)