Question on PAN/SQL versions and maintenance to be installed
search cancel

Question on PAN/SQL versions and maintenance to be installed

book

Article ID: 266774

calendar_today

Updated On:

Products

PAN/SQL

Issue/Introduction

What is the latest release of Pan/SQL?  Is there a 3.0 version?  How are PTFs applied to Easytrieve v11 to get the latest version of Pan/SQL?

Environment currently is Pan/SQL 2.4C.

Environment

Pan/SQL Release 2.4C

Resolution

First, there is not a Pan/SQL 3.0. Pan/SQL 2.4C (0203) is the most current.

Pan/SQL 2.5 is only for Oracle version.Right now release 11.6 is the latest and if you install via z/OSMF, then it also includes LU06812, our continuous delivery level set. 
That is very important. 
Easytrieve release 11.0 is not supported, so it is encouraged to upgrade to release 11.6 ASAP.  Again, Pan/SQL 2.4C works with both.

The PTFs for 2.4C are as follows and work with all releases of Easytrieve. 
RUNNING  PAN/SQL  FROM  WITHIN  LNKLST CAUSES ABEN - RO96846
ADD SUPPORT FOR DB2 BIGINT DATA TYPE - RO78062
ADD SUPPORT FOR DB2 BIGINT DATA TYPE  - RO77666
SQL RELEASE ALL PRIVATE UNSUPPORTED IN DB2V - RO20082
STATIC HOST VARIABLES DEFINED 10 P 15 OR HI - RO05809
-302 AND/OR NAMES >18 CHARS NOT RECOGNIZED  - QO93564
OVERLAY OF FIELD BEFORE SET CURRENT :HOSTVA - QO81778
LOOP OR S0C4 IN STATIC PROGRAM (V7 &  ABOVE - QO81095

Please note that Db2 BIG INT functionality corresponds within Easytrieve release 11.6.