Obtaining a list of 2.5 compatible tools

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

  1. In Windows, open a command prompt.
  2. 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.

  3. 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.

  4. 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;
  5. Close the log file:
    spool off
  6. Exit SQL*Plus:
    EXIT
  7. Close the command prompt.