home *** CD-ROM | disk | FTP | other *** search
- #-------------------------------------------------------------------------
- #
- # FILE
- # INSTALL.ORI
- # V2 installation script language interpreter file.
- #
- # DESCRIPTION
- # Installation file for the DOS SQL*Menu disk.
- #
- # MODIFIED
- # MRMILLER
- #
- #-------------------------------------------------------------------------
-
- #-------------------------------------------------------------------------
- # Generate symbols for Disk Volume label and Jacket label for disks.
- #-------------------------------------------------------------------------
- .LABELGEN
- u
- V60 MENU %u
- SQL*Menu Disk %u
-
- .FILES -NOCOPY
- INSTALL.ORI 15630
-
- .DISK_USAGE=64
- .PRODUCT_NAME=SQL*Menu
- .PRODUCT_VERSION=5.0.11.3.3
- .PRODUCT_NUMBER=6
- .UTIL_REQUIRED=1.0.9.0.2
-
- .CHECKREG %PRODUCT_NUMBER%
- PRODUCT
- VERSION
-
- .CHECKREG 2
- UTILS
- UTIL_VERSION
-
- .IF (%UTILS%=="" || %UTIL_VERSION% < %UTIL_REQUIRED%)
- .MESSAGE
- %WARNING%
-
- You have not installed Tools Utilities %UTIL_REQUIRED%.
- Please install Tools Utilities %UTIL_REQUIRED% or later
- and then install %PRODUCT_NAME%.
-
- .PAUSE
- .EXIT
- .ENDIF
-
- .CHECKREG 1
- RDBMS
- RDBMS_VERSION
-
- .<CHECK_INST>
-
- .IF (%INSTALL_CHECKED%!=1)
- .IF (%PRODUCT%=="")
- .IF (%DISK_USAGE% > %FREE_SPACE%)
-
- .SELECTPROMPT
- USER_RESP
- There is insufficient disk space on drive %ORACLE_DISK%: to install this product.
- Would you like to attempt to install anyway?
- <DISK_SPACE_HELP>
- 1 No
- 2 Yes
-
- .IF (%USER_RESP%==1 || %USER_RESP%==999)
- .EXIT
- .ENDIF
- .ENDIF
-
- .ELSE
- .SELECTPROMPT
- USER_RESP
- %PRODUCT_NAME% has already been installed.
- Would you like to reinstall it?
- <REINSTALL_HELP>
- 1 No
- 2 Yes
-
- .IF (%USER_RESP%==1 || %USER_RESP%==999)
- .EXIT
- .ENDIF
- .ENDIF
- .ENDIF
-
- .CLEARSCREEN
- .MESSAGE
- %NORMAL% SQL*Menu Installation Procedure
- This procedure installs SQL*Menu, ORACLE's menuing utility, which
- supports the creation, use and maintenance of an easy, menu-driven
- interface to virtually any application, simple or complex.
- .PAUSE
-
- .<RUNEXITL>
- .SELECTPROMPT
- RUNEXIT
- SQL*Menu 5.0 allows user exits from RUNMENU. User exits are
- programs written in a procedural language such as C which can be
- called from your SQL*Menu application.
- <RUNEXITHELP>
- 1 Install support for user exits
- 2 Do not install support for user exits
-
- .IF (%RUNEXIT%==999)
- .IF (%INSTALL_CHECKED%!=1 && (%DISK_USAGE%>%FREE_SPACE% || %PRODUCT%!=""))
- .GOTO <CHECK_INST>
- .ELSE
- .EXIT
- .ENDIF
- .ENDIF
-
- .<APPLTABSL>
- .APPLTABS=0
- .IF (%RDBMS%!="" && %RDBMS_VERSION%>=6)
- .CLEARSCREEN
- .MESSAGE
- %NORMAL% SQL*Menu requires that special tables be added to your database
- if you will be designing menus and developing applications. If
- you have previously installed SQL*Menu and these tables already
- exist in your database, they may need to be upgraded to work with
- this version of SQL*Menu.
-
- If you are installing SQL*Menu with a local ORACLE database, and
- the local ORACLE database has already been installed on this
- machine, this installation process can automatically add or
- modify these tables as necessary.
-
- If you would like to add these tables yourself, or if you are
- accessing a remote ORACLE database using SQL*Net, please see the
- section on SQL*Menu in the User's Guide.
-
- .PAUSE
- .SELECTPROMPT
- APPLTABS
- Do you want this installation procedure to automatically update or
- add the tables to your database?
- <APPLTABSHELP>
- 1 Update / Add the tables to the database
- 2 Do NOT add the tables to the database
-
- .IF (%APPLTABS%==999)
- .GOTO <RUNEXITL>
- .ENDIF
- .ENDIF
-
- .CLEARSCREEN
-
- .MESSAGE
- %HILITE% Creating directory %ORACLE_HOME%\MENU...
-
- .MKDIR
- %ORACLE_HOME%\MENU
-
- .MESSAGE
- %NORMAL% Copying Executables into %ORACLE_HOME%\PBIN...
-
- .FILES
- SQLMENU.PXE 1894951 %ORACLE_HOME%\PBIN\SQLMENU.PXE
- RUNMENU.PXE 1073073 %ORACLE_HOME%\PBIN\RUNMENU.PXE
- GENMENU.PXE 1023591 %ORACLE_HOME%\PBIN\GENMENU.PXE
- DOCMENU.PXE 271161 %ORACLE_HOME%\PBIN\DOCMENU.PXE
-
- .SYSCALL -QUIET
- COPY %ORACLE_HOME%\PBIN\PLOADR.COM %ORACLE_HOME%\PBIN\SQLMENU.COM >NUL
-
- .SYSCALL -QUIET
- COPY %ORACLE_HOME%\PBIN\PLOADR.COM %ORACLE_HOME%\PBIN\RUNMENU.COM >NUL
-
- .SYSCALL -QUIET
- COPY %ORACLE_HOME%\PBIN\PLOADR.COM %ORACLE_HOME%\PBIN\GENMENU.COM >NUL
-
- .SYSCALL -QUIET
- COPY %ORACLE_HOME%\PBIN\PLOADR.COM %ORACLE_HOME%\PBIN\DOCMENU.COM >NUL
-
- .MESSAGE
- %NORMAL% Copying message files into %ORACLE_HOME%\DBS...
-
- .FILES
- MNDUS.MSB 19456 %ORACLE_HOME%\DBS\MNDUS.MSB
- MNDHLPUS.R 385024 %ORACLE_HOME%\DBS\MNDHLPUS.R
-
- .MESSAGE
- %NORMAL% Copying SQL*Menu's SQL scripts into %ORACLE_HOME%\MENU...
-
- .FILES
- ALLORDS.SQL 767 %ORACLE_HOME%\MENU\ALLORDS.SQL
- ALLPROD.SQL 872 %ORACLE_HOME%\MENU\ALLPROD.SQL
- CCREDIT.SQL 817 %ORACLE_HOME%\MENU\CCREDIT.SQL
- CUSPROD.SQL 841 %ORACLE_HOME%\MENU\CUSPROD.SQL
- DATORDS.SQL 838 %ORACLE_HOME%\MENU\DATORDS.SQL
- DEMOINS.SQL 2232 %ORACLE_HOME%\MENU\DEMOINS.SQL
- DEMOGRT.SQL 2048 %ORACLE_HOME%\MENU\DEMOGRT.SQL
- ORDERS.SQL 38302 %ORACLE_HOME%\MENU\ORDERS.SQL
- ORDERS.INP 43886 %ORACLE_HOME%\MENU\ORDERS.INP
- ORDERS.DMM 16384 %ORACLE_HOME%\MENU\ORDERS.DMM
- ORDERS.FRM 10708 %ORACLE_HOME%\MENU\ORDERS.FRM
- CONVMENU.SQL 11426 %ORACLE_HOME%\MENU\CONVMENU.SQL
- MENUDEF.SQL 55476 %ORACLE_HOME%\MENU\MENUDEF.SQL
- MENUDROP.SQL 2500 %ORACLE_HOME%\MENU\MENUDROP.SQL
- MENUGRTS.SQL 3746 %ORACLE_HOME%\MENU\MENUGRTS.SQL
- MENUIDXS.SQL 3099 %ORACLE_HOME%\MENU\MENUIDXS.SQL
- MENUTABS.SQL 5955 %ORACLE_HOME%\MENU\MENUTABS.SQL
- MENUVWS.SQL 3374 %ORACLE_HOME%\MENU\MENUVWS.SQL
-
- .MESSAGE
- %NORMAL% Creating SQL*Menu batch files in %ORACLE_HOME%\BIN...
-
- .WRITEFILE
- %ORACLE_HOME%\BIN\MENUINS.BAT
- ECHO OFF
- ECHO
- REM
- REM Usage: MENUINS SYSTEM SYSTEM_Password
- REM
- IF NOT .%%1 == . GOTO MENUINS
- ECHO Usage: MENUINS SYSTEM SYSTEM_Password
- ECHO
- GOTO EXIT
-
- :MENUINS
- CLS
- ECHO Loading the SQL*Menu tables into the SYSTEM account.
- ECHO This procedure will take approximately fifteen minutes.
-
- INSTLOAD %%1/%%2 %ORACLE_HOME%\MENU\MENUTABS.SQL %ORACLE_HOME%\MENU\MENUTABS.LOG
- INSTLOAD %%1/%%2 %ORACLE_HOME%\MENU\MENUVWS.SQL %ORACLE_HOME%\MENU\MENUVWS.LOG
- INSTLOAD %%1/%%2 %ORACLE_HOME%\MENU\MENUGRTS.SQL %ORACLE_HOME%\MENU\MENUGRTS.LOG
- INSTLOAD %%1/%%2 %ORACLE_HOME%\MENU\MENUIDXS.SQL %ORACLE_HOME%\MENU\MENUIDXS.LOG
-
- :EXIT
-
- .WRITEFILE
- %ORACLE_HOME%\BIN\DEMOINS.BAT
- ECHO OFF
- ECHO
- REM
- REM Usage: DEMOINS SYSTEM SYSTEM_Password
- REM
- IF NOT .%%1 == . GOTO FILES
- ECHO Usage: DEMOINS SYSTEM SYSTEM_Password
- ECHO
- GOTO EXIT
- :FILES
- IF NOT EXIST %ORACLE_HOME%\MENU\ORDERS.SQL GOTO ABORT
- IF NOT EXIST %ORACLE_HOME%\MENU\DEMOINS.SQL GOTO ABORT
- GOTO DEMOINS
- :ABORT
- ECHO Error - could not access one of the following files:
- ECHO %ORACLE_HOME%\MENU\ORDERS.SQL
- ECHO %ORACLE_HOME%\MENU\DEMOINS.SQL
- GOTO EXIT
- :DEMOINS
- CLS
- ECHO Loading the SQL*Menu demo Order Application into the SYSTEM
- ECHO account. Output will be spooled to %ORACLE_HOME%\MENU\DEMOINS.LOG
- ECHO and %ORACLE_HOME%\MENU\ORDERS.LOG.
- ECHO This procedure will take approximately five minutes.
- ECHO
- ECHO Note: If other users besides SYSTEM wish to use the ORDER application,
- ECHO they must be given SQL*Menu authorization AND be granted access to the
- ECHO ORDER application by the DBA. This can be done by running DEMOGRT.
-
- INSTLOAD %%1/%%2 %ORACLE_HOME%\MENU\ORDERS.SQL %ORACLE_HOME%\MENU\ORDERS.LOG
- INSTLOAD %%1/%%2 %ORACLE_HOME%\MENU\DEMOINS.SQL %ORACLE_HOME%\MENU\DEMOINS.LOG
-
- :EXIT
-
- .WRITEFILE
- %ORACLE_HOME%\BIN\DEMOGRT.BAT
- ECHO OFF
- ECHO
- REM
- REM Usage: DEMOGRT SYSTEM SYSTEM_Password Demo_Userid
- REM
- REM Note: SQL*Plus must be installed
- REM
- IF NOT .%%3 == . GOTO FILES
- ECHO Usage: DEMOGRT SYSTEM SYSTEM_Password Demo_Userid
- ECHO
- GOTO EXIT
- :FILES
- IF EXIST %ORACLE_HOME%\MENU\DEMOGRT.SQL GOTO DEMOGRT
- ECHO Error - could not access %ORACLE_HOME%\MENU\DEMOGRT.SQL
- GOTO EXIT
- :DEMOGRT
- CLS
- ECHO Granting access to the SQL*Menu demo Order Application to %%3.
- ECHO Output will be spooled to %ORACLE_HOME%\MENU\DEMOGRT.LOG.
- ECHO This procedure will take approximately three minutes.
-
- SQLPLUS %%1/%%2 @%ORACLE_HOME%\MENU\DEMOGRT.SQL %%3 >%ORACLE_HOME%\MENU\DEMOGRT.LOG
-
- :EXIT
-
- .IF (%RUNEXIT%==1)
-
- .MESSAGE
- %HILITE% Making directory %ORACLE_HOME%\PRO...
-
- .MKDIR
- %ORACLE_HOME%\PRO
-
- .MKDIR
- %ORACLE_HOME%\PRO\LIB
-
- .MKDIR
- %ORACLE_HOME%\PRO\EXIT
-
- .MESSAGE
- %NORMAL% Copying User Exit Software into %ORACLE_HOME%\PRO...
-
- .FILES
- TESTEXIT.DMM 3072 %ORACLE_HOME%\PRO\EXIT\TESTEXIT.DMM
- TESTEXIT.SQL 5228 %ORACLE_HOME%\PRO\EXIT\TESTEXIT.SQL
-
- .FILES
- FRPPLS.OBJ 2117 %ORACLE_HOME%\PRO\LIB\FRPPLS.OBJ
- DMU.OBJ 3042 %ORACLE_HOME%\PRO\LIB\DMU.OBJ
- MNUXIT.LIB 21037 %ORACLE_HOME%\PRO\LIB\MNUXIT.LIB
- DMPDMY.LIB 3605 %ORACLE_HOME%\PRO\LIB\DMPDMY.LIB
- DMCLIB.LIB 53619 %ORACLE_HOME%\PRO\LIB\DMCLIB.LIB
- DMPLIB.LIB 28455 %ORACLE_HOME%\PRO\LIB\DMPLIB.LIB
- DMULIB.LIB 133107 %ORACLE_HOME%\PRO\LIB\DMULIB.LIB
-
- .ENDIF
-
- .IF (%APPLTABS%==1)
- .CLEARSCREEN
- .DBA_FOUND=1
-
- .TRANSLATE
- %DBA_AUTHORIZATION%
- DBA_AUTHORIZATION
-
- .IF (%DBA_AUTHORIZATION%=="")
-
- .DBA_FOUND=0
- .<DBAL>
- .STRINGPROMPT QUIET 6 32
- DBA_AUTHORIZATION
- Please enter your DBA authorization password.
- <DBA_HELP>
-
- .IF (%DBA_AUTHORIZATION%=="999")
- .GOTO <DBAL>
- .ENDIF
- .IF (%DBA_AUTHORIZATION%=="!TOOSHORT")
- .MESSAGE
- %WARNING%
- Error - password must be at least six characters.
-
- .GOTO <DBAL>
- .ENDIF
- .ENDIF
-
- .MESSAGE
- %HILITE%
- Starting up the database...
-
- .SYSCALL -QUIET
- SQLPME >NUL
-
- .SYSCALL -QUIET
- ORACLE6 >NUL
-
- .SPAWN
- SQLDBA STARTUP AUTHORIZATION=%DBA_AUTHORIZATION%
-
- .IF (%SPAWNRET%!=0)
- .MESSAGE
- %HILITE% Error - unable to start the ORACLE database using SQLDBA.
- SQL*Menu application tables will NOT be installed.
-
- .SYSCALL -QUIET
- REMPME >NUL
-
- .PAUSE
- .EXIT
- .ENDIF
-
-
- # OK so far; make sure we have the right password.
-
- .PASSWD=MANAGER
-
- .<LOOP>
- .SPAWN
- CHKALL -MENU SYSTEM %PASSWD%
- .IF (%SPAWNRET%<0)
- .MESSAGE
- %HILITE% Error - unable to spawn CHKALL.
- SQL*Menu application tables will NOT be installed.
-
- .SYSCALL -QUIET
- REMPME >NUL
-
- .PAUSE
- .GOTO <INSTEND>
- .ENDIF
- # Since we don't have a logical AND, we figure out the flags manually...
-
- .IF (%SPAWNRET%>=128)
- .UNKNOWN_ERR=1
- .SPAWNRET=%SPAWNRET%-128
- .ELSE
- .UNKNOWN_ERR=0
- .ENDIF
-
- .IF (%SPAWNRET%>=64)
- .DB_DOWN=1
- .SPAWNRET=%SPAWNRET%-64
- .ELSE
- .DB_DOWN=0
- .ENDIF
-
- .IF (%SPAWNRET%>=32)
- .USAGE_ERR=1
- .SPAWNRET=%SPAWNRET%-32
- .ELSE
- .USAGE_ERR=0
- .ENDIF
-
- .IF (%SPAWNRET%>=16)
- .NEED_CAT=1
- .SPAWNRET=%SPAWNRET%-16
- .ELSE
- .NEED_CAT=0
- .ENDIF
-
- .IF (%SPAWNRET%>=8)
- .FORMS_23=1
- .SPAWNRET=%SPAWNRET%-8
- .ELSE
- .FORMS_23=0
- .ENDIF
-
- .IF (%SPAWNRET%>=4)
- .FULL=1
- .SPAWNRET=%SPAWNRET%-4
- .ELSE
- .FULL=0
- .ENDIF
-
- .IF (%SPAWNRET%>=2)
- .PARTIAL=1
- .SPAWNRET=%SPAWNRET%-2
- .ELSE
- .PARTIAL=0
- .ENDIF
-
- .IF (%SPAWNRET%==1)
- .USER_GOOD=1
- .ELSE
- .USER_GOOD=0
- .ENDIF
-
- # Now, evaluate codes
-
- .IF (%USER_GOOD%==0)
- .CLEARSCREEN
- .<PASSWDL>
- .STRINGPROMPT
- PASSWD
- Please enter the current password for the SYSTEM account.
- <PASSWDHELP>
- %PASSWD%
-
- .IF %PASSWD%=="999"
- .GOTO <PASSWDL>
- .ENDIF
- .GOTO <LOOP>
- .ENDIF
-
- .CORRECT_PARTIAL=0
- .IF (%PARTIAL%==1)
- .STRINGPROMPT
- CORRECT_PARTIAL
- It appears that the SQL*Menu Designer tables have been partially
- installed in this database sometime in the past. Do you wish to
- remove these tables and install the complete set? Any applications
- stored in these tables will be lost.
- <PARTIAL_HELP>
- 1 Remove current tables and reinstall complete set
- 2 Leave tables as they are
-
- .IF (%CORRECT_PARTIAL%==1)
- .GOTO <FULL_JUMP>
- .ENDIF
-
- .ELSE
-
- .IF (%FULL%==0)
- .<FULL_JUMP>
- .CLEARSCREEN
- .MESSAGE
- %NORMAL% Adding SQL*Menu Designer tables to the database...
-
- .SPAWN
- INSTLOAD SYSTEM/%PASSWD% %ORACLE_HOME%\MENU\MENUTABS.SQL %ORACLE_HOME%\MENU\MENUTABS.LOG
- .IF (%SPAWNRET%!=0)
- .GOTO <NOINTERACT>
- .ENDIF
-
- .SPAWN
- INSTLOAD SYSTEM/%PASSWD% %ORACLE_HOME%\MENU\MENUVWS.SQL %ORACLE_HOME%\MENU\MENUVWS.LOG
- .IF (%SPAWNRET%!=0)
- .GOTO <NOINTERACT>
- .ENDIF
-
- .SPAWN
- INSTLOAD SYSTEM/%PASSWD% %ORACLE_HOME%\MENU\MENUGRTS.SQL %ORACLE_HOME%\MENU\MENUGRTS.LOG
- .IF (%SPAWNRET%!=0)
- .GOTO <NOINTERACT>
- .ENDIF
-
- .SPAWN
- INSTLOAD SYSTEM/%PASSWD% %ORACLE_HOME%\MENU\MENUIDXS.SQL %ORACLE_HOME%\MENU\MENUIDXS.LOG
- .IF (%SPAWNRET%!=0)
- .GOTO <NOINTERACT>
- .ENDIF
-
- .ELSE
- .MESSAGE
- %NORMAL% SQL*Menu Designer tables present and verified.
-
- .ENDIF
- .ENDIF
-
- .MESSAGE
- %HILITE% Shutting down the database...
-
- .SYSCALL -QUIET
- SQLDBA SHUTDOWN AUTHORIZATION=%DBA_AUTHORIZATION% >NUL
-
- .ENDIF
-
- .SYSCALL
- REMPME >NUL
-
- .<INSTEND>
- .MESSAGE
- %NORMAL% Updating product registration information...
-
- .REGISTERFILE
- %PRODUCT_NUMBER% %PRODUCT_NAME%
- %PRODUCT_VERSION%
- <DEINSTALL>
-
- .EXIT
-
- .<DISK_SPACE_HELP>
- %PRODUCT_NAME% requires %DISK_USAGE%00K to install. There is %FREE_SPACE%00K free on drive
- %ORACLE_DISK%:. You may try to proceed anyway. Unless you plan to install only a
- portion of it or you are reinstalling after an unsuccessful installation,
- ORAINST will probably terminate abnormally.
-
- .<REINSTALL_HELP>
- %PRODUCT_NAME% has an entry in REGISTER.ORA, indicating that it has
- been installed previously. You may either abort this installation and save
- the version you have already installed, or you may reinstall and overwrite
- the existing version. Entry in REGISTER.ORA follows.
-
- Product: %PRODUCT%
- Version: %VERSION%
-
- .<RUNEXITHELP>
- If you have a C compiler, you can write protected mode DOS user exits which
- can be called from your SQL*Menu applications. You must install the ORACLE
- Pro*C precompiler in order to compile and link these programs correctly.
- You can still build complex SQL*Menu applications without the use of user
- exits.
-
- .<APPLTABSHELP>
- In order to design menus, you must have certain tables installed in your
- ORACLE database. If you have already installed a local database, this
- install can automatically create these tables. Choose Yes if you would
- like these tables to be automatically created/updated. If you do not
- have a local database installed, or would like to create the tables at a
- later time, choose No.
-
- .<PASSWDHELP>
- This installation procedure needs to know the SYSTEM account's password
- in order to install the designer tables.
-
- .<PARTIAL_HELP>
- Some, but not all, of the tables required by SQL*Menu are
- present in your database. The designer will not work unless all of them
- are present. If you wish to correct this, this install can remove the
- tables currently present and replace them with a full set. Any data in
- the tables will be lost. Alternatively, you can run MENUINS.CMD.
-
- .<DEINSTALL>
- %ORACLE_HOME%\PBIN\SQLMENU.COM
- %ORACLE_HOME%\PBIN\RUNMENU.COM
- %ORACLE_HOME%\PBIN\GENMENU.COM
- %ORACLE_HOME%\PBIN\DOCMENU.COM
- %ORACLE_HOME%\MENU\MENUTABS.LOG
- %ORACLE_HOME%\MENU\MENUVWS.LOG
- %ORACLE_HOME%\MENU\MENUGRTS.LOG
- %ORACLE_HOME%\MENU\MENUIDXS.LOG
-