v9.1a to v9.1b SCO OpenServer

Posted by LegacyUser on 29-Dec-2000 15:28

We have a client who wishes to install v9.1b. We have 9.1a in house. Will code compiled under 9.1a run on 9.1b? It is my understanding that minor releases have involve no re-compiles, but I have been told this is not so for the 9.1a to 9.1b. We don't want to buy yet another database for in-house use unless we have to.

All Replies

Posted by LegacyUser on 15-Jan-2001 15:30

The cases that require recompilation are:

Running ADM 2.0 Code with 9.1B

RN#: 091A-00211

Progress r-code compiled in a release of the product such as 9.0A or 9.0B is expected

to run successfully without recompilation in a later release within the same version

number, such as 9.1B. This includes SmartObject Applications. However, you must keep

in mind that the ADM consists of a body of 4GL code, some of it in compiled objects such

as super procedures, and some of it in include files. Obviously it is not possible for a

SmartObject application to see enhancements to the ADM or bug fixes in this 4GL code

without recompiling the application.

Thus, with Version 9.1B you have two choices:

1. Recompile with V9.1B -- This lets you take advantage of the enhancements in ADM 2.1. This requires resolving any discrepancies between customizations you might have made to the earlier ADM code with the new versions of the ADM code shipped with the new release.

2. Copy the V9.x ADM with your application code to V9.1B -- With this technique, you do not have to recompile. You must keep all compiled application objects including the compiled super procedures and any other support procedures from the earlier release, and continue to run the application on the new Progress executable without using any of the new ADM 2.1 code. However, maintaining code from an earlier version of the product in the Version 9.1B1B AppBuilder is not supported because of dependencies between the AppBuilder and code that supports the ADM.

DataServer Support for Dynamic Queries

RN#: 091A-00259

  • DataServer for ODBC:

Starting in 9.1A, Dynamic Queries were implemented in the ODBC DataServer. As a result of adding this functionality, any 4GL application that uses the ODBC DataServer that has not been compiled prior to Version 9.1A must be recompiled to run on Version 9.1B.

Existing Stored Procedures and Triggers Must Be Recompiled

RN#: 091A-00581

With the release of SQL-92 V9.1, compiled stored procedures and triggers in existing databases will not work. These will need to be recompiled. If you try to use them with out recompiling, you will get an error.

Because we do not have an explicit 'compile' command for stored procedures and triggers,

we have provided a java program (SQLConvertSPTP) in the sample code area of your installation area. This can be run by the DBA to convert all the procedures and triggers in your database or by an individual to convert their own. If you do not have a Java Virtual Machine available on the machine with your database, you may run this

utility across the network from a machine that does have a JVM. .../...

Regards,

Salvador

"psmith" wrote:

>

>We have a client who wishes to install v9.1b. We have

>9.1a in house. Will code compiled under 9.1a run on

>9.1b? It is my understanding that minor releases have

>involve no re-compiles, but I have been told this is

>not so for the 9.1a to 9.1b. We don't want to buy yet

>another database for in-house use unless we have to.

Posted by LegacyUser on 03-Feb-2001 02:18

Please, does anyone have any suggestions for the best way of migrating databases, programs from Progress ver. 7.3c to Progress ver. 8.2a.

Thank you !

Posted by LegacyUser on 05-Feb-2001 05:40

"pedja" wrote:

>

>Please, does anyone have any suggestions for the best

>way of migrating databases, programs from Progress ver.

>7.3c to Progress ver. 8.2a.

>

>Thank you !

Posted by LegacyUser on 07-Feb-2001 03:13

Please, does anyone have any suggestions for the batch process of migration databases from Progress ver.7.3c to Progress ver. 8.2a. I've more then 50 servers with more then 100 databases and I mast create batch process for that job, but command conv78 doesn't work in batch process.

Thank you !

This thread is closed