DB2 REXX SQL for VM/ESA^(R): Installation and Reference

Appendixes

Appendix A. Files Supplied by IBM

This appendix lists the load library and module, DB2 RXSQL HELP files, MACROs, EXECs, selected TEXT files, and corrective service files necessary for installing DB2 RXSQL.

Basic System Files

The basic system files that are built at installation time are:

EXECSQL MODULE

RXSQL MODULE

RXSQL LOADLIB.

Programs and HELP Files

The programs and HELP files that are provided for general use are:

RXSQL HELPMENU

RXCASE HELPRXSQ

RXSELECT HELPRXSQ

RXSQLANG HELPRXSQ

RXSQLEX HELPRXSQ

RXSQLHLP HELPRXSQ

RXSQLOP HELPRXSQ

RXSQLVL HELPRXSQ

RXCMDS HELPRXSQ

RXUSAGE HELPRXSQ

RXCASE EXEC

RXSQLANG EXEC

RXSQLEX EXEC

RXSELECT EXEC

RXSELECT XEDIT

RXMORE XEDIT

RXSQLHLP EXEC

RXSQLHLP XEDIT

RXSQLOP EXEC

RXSQLOP XEDIT

RXSQLVL EXEC.

Example EXECs

The example EXECs and the sample input file that are described in this manual are:

EMPCRE EXEC

EMPSEL EXEC

EMPPRP EXEC

EMPSELX EXEC

EMPPRPM EXEC

EMPUPD EXEC

EMPLOYEE INPUT.

Message Repository

The message repository for mixed-case American English is ELOUME TXTAMENG.

Installation Files

Files for installation are used to:

• Identify the product:

  |I5697ELO 071012

  |I5697ELO MEMO (Memo to Users)

• Contain the installation program:

  |I5697ELO EXEC

• Build MODULE and LOADLIB:

  ELOLKED EXEC

• Load the DB2 RXSQL package:

  ELOAMOD EXEC

  ELORXSQL MACRO

• Load the DB2 RXSQL message repository:

  ELOLANG EXEC

  ELOLANMS EXEC

• Build MODULE and LOADLIB by ELOLKED:

  EDCSPC TXTLIB

  EDCXMEM TEXT

  ELOCDECH TEXT

  ELOCDOFM TEXT

  ELOCECVT TEXT

  ELOCFCVT TEXT

  ELOCGCVT TEXT

  ELOCGECV TEXT

  ELOCHEXD TEXT

  ELOCHXDS TEXT

  ELOCHXTB TEXT

  ELOCLECV TEXT

  ELOCLFCV TEXT

  ELOCLGCV TEXT

  ELOCMEMM TEXT

  ELOCPRTF TEXT

  ELOCSBRK TEXT

  ELOCSCMP TEXT

  ELOCSPRT TEXT

  ELOCSSPN TEXT

  ELOCSSTR TEXT

  ELOCTFDL TEXT

  ELOCTOUP TEXT

  ELODUMMY TEXT

  ELOECREA TEXT

  ELOECXA TEXT

  ELOECNXA TEXT

  ELOEPENV TEXT

  ELOFCLOS TEXT

  ELOFCONN TEXT

  ELOFCREA TEXT

  ELOFDECL TEXT

  ELOFDESC TEXT

  ELOFDROP TEXT

  ELOFELUW TEXT

  ELOFEXEC TEXT

  ELOFFETC TEXT

  ELOFIMME TEXT

  ELOFOPER TEXT

  ELOFOPEN TEXT

  ELOFPREP TEXT

  ELOFPURG TEXT

  ELOFPUT TEXT

  ELOFSQL TEXT

  ELOFSTMT TEXT

  ELOFTRAC TEXT

  ELOFXPRE TEXT

  ELOLK33 TEXT

  ELOP TEXT

  ELOPA TEXT

  ELOPR TEXT

  ELOPV TEXT

  ELOPW TEXT

  ELOSBUIL TEXT

  ELOSCONV TEXT

  ELOSDBR TEXT

  ELOSDESC TEXT

  ELOSDTCH TEXT

  ELOSDTIN TEXT

  ELOSEXTD TEXT

  ELOSFETC TEXT

  ELOSFORM TEXT

  ELOSINFE TEXT

  ELOSLEX TEXT

  ELOSMEM TEXT

  ELOSREXX TEXT

  ELOSSCA TEXT

  ELOSSERR TEXT

  ELOSSSB TEXT

  ELOSSTEM TEXT

  ELOSUSER TEXT

  ELOXDTCO TEXT

  ELOXDTLO TEXT

  ELOXECOM TEXT

  ELOXGETE TEXT

  ELOXGETM TEXT

  ELOXGLBV TEXT

  ELOXLWRT TEXT

  ELOXMEM TEXT

  ELOXREXX TEXT

  ELORXSQL TEXT

  ELOXUPPE TEXT

  ELOXVAL TEXT

  EXECSQL TEXT

  RXSQL TEXT

  SQLEXEC TEXT

• Tailor the DB2 RXSQL MODULE:

  RXSQL ASSEMBLE

• Install DB2 RXSQL HELP text tables:

  ELOHLPLD EXEC

  ELOHELPI EXEC

  ELOSDBU MACRO

  ELO1S001 MACRO

  ELO2S001 MACRO.

Corrective Service Maintenance Files

Files for corrective service are used to:

• Install corrective maintenance:

  ELOSCOR EXEC

• Service the RXSQL HELP text tables:

  ELOSHLP EXEC.

National Language Support Files

Files for installing and deleting NLS HELP text:

ELOINLS EXEC

ELODNLS EXEC.

Migration Considerations

The files supplied by IBM for DB2 RXSQL Version 7 Release 1 do not correspond directly to the files supplied for releases of Version 3.

The following DB2 RXSQL Version 3 Release 1 files, used to build MODULE and LOADLIB, are not required to run DB2 RXSQL Version 7 Release 1 and can be deleted:

ELOCF TEXT

ELOCM TEXT

ELOCP TEXT

ELODE TEXT

ELODT TEXT

ELOFE TEXT

ELOFP TEXT

ELOLK TEXT

ELOMN55 TEXT

ELOMN6 TEXT

ELOOP TEXT

ELOUT TEXT

ELOSH TEXT

ELOSM TEXT

ELOSQ TEXT

ELOST TEXT

ELOTM TEXT

ELOTR TEXT

ELOXP TEXT

The following DB2 RXSQL Version 3 Release 2 files, used to build MODULE and LOADLIB, are not required to run DB2 RXSQL Version 7 Release 1 and can be deleted:

ELOCF TEXT

ELOCM TEXT

ELOCP TEXT

ELODE TEXT

ELODT TEXT

ELOFE TEXT

ELOFP TEXT

ELOGL TEXT

ELOLK TEXT

ELOMN55 TEXT

ELOMN6 TEXT

ELOOP TEXT

ELOUT TEXT

ELOSH TEXT

ELOSM TEXT

ELOSQ TEXT

ELOST TEXT

ELOTM TEXT

ELOTR TEXT

ELOXP TEXT

The following DB2 RXSQL Version 3 Release 3 files, used to build MODULEs and LOADLIB, are not required to run DB2 RXSQL Version 7 Release 1 and can be deleted:

ELOPC TEXT

ELOPE TEXT

ELOPF TEXT

ELOPP TEXT

ELOPS TEXT

ELOPU TEXT

The following DB2 RXSQL Version 3 Release 4 files, used to build MODULEs and LOADLIB, are not required to run DB2 RXSQL Version 7 Release 1 and can be deleted:

I5688ELO 034004

I5688ELO MEMO

I5688ELO EXEC