We are planning for an Easytrieve migration from 6.4, to 11.6. I would like to know how to find if the Oracle Interface Option was enabled in the last installation.

Document ID : KB000044360
Last Modified Date : 14/02/2018
Show Technical Document Details

 

Introduction:

CA Easytrieve 6.4 to 11.6 upgrade querry.
 

Question:

We are planning for an Easytrieve migration from 6.4, to 11.6.
I would like to know how to find if the Oracle Interface Option was enabled in our last installation. 
 

Environment: 

Easytrieve using Oracal(PAN/SQL 2.5)
 

 

Answer: 

EZORAC00200 Oracal(PAN/SQL 2.5) - It is delivered with the  Easytrieve base. 
It is a separate cost option, and there are no unique Easytrieve product modules, 
(check for PAN/SQL modules) DQS*.

 

Additional Information:

 

When executing an SQL program via EZTPA00, Easytrieve PAN/SQL 
determines which database (DB2, Datacom,IDMS, Oracle) to use as follows;
If there is an SQL statement in the
Easytrieve application, always the same module names are being called.   
                                                                         
But the modules itself are not the same, because you have to concatenate 
the appropriate Pan/SQL load library in the EZTPA00 step.  
Many names are equal, but not their sizes.