Query the database to identify any delivered or custom 2.5 compatible server tools compatible with Parlance 2.5. Examples of such tools are GlobalEd, or any custom tools you may have built at the time.
Procedure
- In Windows, open a command prompt.
- Open a SQL*Plus prompt by entering the following command:
sqlplus DATABASE/PASSWORD
where DATABASE is the name of your database and PASSWORD is the password to access it.
- Create a log file by entering the following command:
spool TEMPDIR/25_TOOLS.LOG
where TEMPDIR is a temporary directory such as c:\temp and 25_TOOLS.LOG is the name of the log file you want to create.
- Write a list of 2.5 tools to this log file by running the following command:
select SUBSTR(TOOL.NAME,1,30) NAME,
SUBSTR(OBJECTTYPE.name,1,30) OBJTYPE
from TOOL, OBJECTTYPE
where TOOL.OBJECTTYPE = OBJECTTYPE. OBJECTTYPE and
(TOOL_CLASS!=1 and TOOL_CLASS!=2) and
(TOOL_CLASS=6 or TOOL_CLASS=4 or TOOL_CLASS=3 or TOOL_CLASS=5) and
IS_2X_TOOL=1;
- Close the log file:
- Exit SQL*Plus:
- Close the command prompt.