Consultor Eletrônico

ICL System 25 Release Notes

910729-jom01

ADDITIONAL NOTES FOR THIS RELEASE


PLATFORM: ICL SYSTEM 25
MEDIA TYPE: Cartridge Tape
SOFTWARE RELEASE: 6.2G
EXTRACT COMMAND: cpio -iudcvBm </dev/rmt/0m
install COMMAND: ./proinstall


MACHINE NOTES:


OPERATING SYSTEM NOTES:


TERMINAL NOTES:


SOFTWARE NOTES:

o This release was ported with ORACLE Version 6.
o This release supports Embedded SQL (HLI) for C.

o Online Backups
--------------
The use of the -o (overlap factor) is not supported in this
release; you must restore the incremental backups exactly the
same way as you did when you backed them up or you will have
problems. For example,

proshut demo -C online /dev/rst8
proshut demo -C online /dev/rst8 incremental -o 2

After restoring the full backup, if you skip any of the
incrementals, you receive an error message indicating that
the tapes are out of sequence and the restore fails.

Workaround: Make sure all backups are restored in exact order.

o Fast Track (convft)
-------------------
If you use the convft utility to convert your database to a
Fast Track database, you must set the PROEXE environment
variable first:

PROEXE=/usr/dlc/_progres;export PROEXE
convft database-name

o Fast Track (500 file limit)
---------------------------
Unlike earlier versions, Fast Track Version 6.2F and above
enables you to choose from more than 500 files when creating QBF's,
reports or forms. Now there is no limit to the number of
files you can select. However, because of internal changes to
the Fast Track code, you must recompile any QBF's or menus
generated with earlier versions of Fast Track to run them
under Version 6.2F and above.

o Index Deactivation
------------------
If you are deactivating indexes, do it through the Index
Editor. Deactivating indexes through the Admin menu in
the Dictionary will deactivate the top index.
For example: In the customer file there are three indexes,
Cust-num, State, and Zip. If you choose to deactivate Zip, it
deactivates Cust-num as well as Zip.

o ORACLE ldemo
------------
The ldemo script that resides in subdirectory ora in
the directory where you install PROGRESS
(e.g., /usr/dlc/ora/ldemo) will not work with the
Query/Runtime or Runtime product. It makes schema
modifications which these products do not support.

o REMOTE GATEWAYS
---------------
o In PROGRESS Version 6.2F and above , you can remotely
access an Oracle or RMS database. To do this, you must install
a Version 6.2F (or later) core PROGRESS product (for example,
PADS, 4GL&RDBMS, Query Report, or Runtime) on the machine
where you are running your PROGRESS application and on the
machine hosting your non-PROGRESS database.

o Progress Version 6.2F and above does not trap the CTRL-C
if you use it with Remote Oracle Gateway. If you use CTRL-C
within a transaction, you are disconnected from the Remote
Oracle server with the following message on your client:
** Disconnected by the server, code 7 (706).
Also, the Remote Oracle server's log will have the following
error messages:
SERVER: SYSTEM ERROR: oratmstrt: transaction already
started (1473)
SERVER: ** Please save file name core for analysis by PSC. (439)
SERVER: logout usernum 0, userid, on (739).

o From Progress Version 6.2G on, Oracle and Rdb gateways only
use one index-cursor per buffer. (Prior to version 6.2G, there
was one index cursor for each different WHERE clause.) This
change enables the Next option in the RESULTS Query Module to
work with these gateways.

As a result, you cannot use code similiar to the following:

FOR EACH cust WHERE name BEGINS "a":
FOR EACH cust WHERE cust-num > 1: ....
END.
END.

This type of code produces a "No nested FOR EACH" error message.

Instead, define a buffer for each inner FOR EACH loop. For
example, you can use code similiar to the following:

DEFINE BUFFER cust-buf FOR cust
FOR EACH cust WHERE name BEGINS "a":
FOR EACH cust-buf WHERE cust-num > 1: ....
END.
END.

o To run RESULTS for version 6 with Oracle or Rdb Gateway, the
gateway must be Version 6.2G or later.

o PROBUILD
--------
o When running PROBUILD, the $PROLOAD/eucapp/euc.pl file must
have at least read and write permissions (rw-rw-rw-), otherwise
you will get the error:

** Cannot find or open euc.pl errno 13

To avoid this error, change the permissions on the euc.pl
file as follows:

chmod 666 $PROLOAD/eucapp/euc.pl

where $PROLOAD is an environment variable set to where
you have the dlcload directory installed - /usr/dlcload
by default.

o You can now use PROBUILD to build an executable with a remote
gateway configurable element. For example, if you need to
access a remote Oracle database, just select your networking
protocols and REMOTE ORACLE GATEWAY at the CONFIGURABLE
ELEMENTS screen.

If you need to access your non-PROGRESS database locally,
you need to purchase the PROGRESS 4GL&RDBMS software and
the Database Gateway software. If you do not have this
combination of products, you cannot load the standard
gateway in your executable. See Chapter 1 in the PROGRESS
3GL Interface Guide for more information.

o Connecting Databases
--------------------
You must use the -Nv 12 startup option to connect a 6.2F01 client
to a Version 5 or 6.2A-6.2F PROGRESS server.

o Multi-Volume Databases - prostrct add
-------------------------------------
If you define a variable length extent and then use the
"prostrct add" command to add another variable length extent,
the command does not work correctly. It should convert the
previous variable-length to a fixed-length extent, but it does not.

To workaround this problem, do not use the "prostrct add" command.
Instead, create a new structure file (.st). Define all of the
extents you want to use, including any new extents. Create a
new void multi-volume database and use the "procopy" command (or
the "probkup" and "prorest" commands) to copy the old database to
the new one.

Progress Software Technical Support Note # 9144