Consultor Eletrônico

Status: Verified

GOAL:

How to convert V7/V8 server schema to V9 server schema?

GOAL:

This solution intends to describe the steps to upgrade a Progress/400
server schema from version 7 or 8 to version 9.

GOAL:

How to upgrade the Progress/400 DataServer to the latest version

FACT(s) (Environment):

IBM AS/400 (RISC)
Progress 7.x
Progress 8.x
Progress 9.x
Progress/400 DataServer

FIX:

1. Install the Progress/400 DataServer version 9 product.
2. Back up your version 7 or 8 dictionary library and data files.
3. Back up your schema holder.
4. Create an empty server schema using the version 9 command DUPPRODB.

note: Step 4 is used if you are performing the Copy/Convert Method only. This method provides a way not to lose the
previous version of the server schema in case the upgraded version did not work properly.

5. Convert the version 7 or 8 server schema into a version 9 by using the version 9 command CVTPRODCT.

note: DO NOT USE the CVTSRVSCH command.

6. Create the new version 9 schema holder on the client machine.
7. Recompile the application.


Details:

Based on the default value of the parameter CVTSRCDCT in the CVTPRODCT convert command in step 5 you could perform the conversion
in two ways:

- Copy/Convert Method Default value CVTSRCDCT(*NO)

In this method the CVTPRODCT copies the server schema to the specified dictionary library (the one created in the step 4 with DUPPRODB)
and updates certain information to allow it to work with the version 9 server schema.


- Convert in-place Method value CVTSRCDCT(*YES)
In this method the CVTPRODCT command converts an existing Version 7 or 8 server schema directly into a version 9 server schema rather than
simply copying it. In this method you don't need to create an empty schema server as described on step 4 above. After you convert in place,
the original Progress/400 DataServer Product version 7 or 8 CANNOT access the upgraded dictionary library or server schema, only the version 9 can.