HP 3000 Manuals HP 3000 Manuals
Chapter 5 DATABASE TOOLS ALLBASE/SQL Enhancements by Trude Ko Commercial Systems Division The following ALLBASE/SQL tools were revised to support the POSIX.1 enhancement in MPE/iX Release 4.5: * ISQL * SQLGEN * SQLUTIL * C/PASCAL/COBOL/FORTRAN Preprocessors Privileged files such as ALLBASE/SQL DBECon files, DBEFiles, and LOGFiles cannot reside in the hierarchical file structure with this release of MPE/iX. ALLBASE/SQL only supports DBECon file, DBEFile and LOGFile names that conform to MPE naming conventions. All ALLBASE/SQL tools run under the POSIX.2 shell supported in MPE/iX Release 4.5. ISQL Both command files, ISQLPRO and ISQLSYN, can be set to POSIX file names through a file equation or an ISQL UDC. Modifications were made to the following ISQL commands to support POSIX files: * ERASE * INSTALL * LIST FILE * LIST INSTALL * LIST SET * LOAD * RECALL * RENAME * SET OUTPUT * SET EDITOR * START * STORE * UNLOAD SQLGEN The following SQLGEN commands can both prompt and create files that allow POSIX naming: * GENERATE Commands * GENERATE LOAD * SET SCHEMA SQLUTIL The SHOWDBE command is the only SQLUTIL command that creates an ASCII output file that allows POSIX naming. PREPROCESSORS The ALLBASE/SQL preprocessors, C, COBOL, FORTRAN, and PASCAL, were modified to support POSIX named ASCII files. For MPE/iX Release 4.5, only the C language supports calls to access POSIX functionality; therefore, applications written in C with embedded SQL statements may contain POSIX calls.