RELEASE NOTES SQRSH 1.1-1 2003/11/30 Added support to "profile" to allow it to distinguish between local and global procedures. It assumes that there is one space between the begin-procedure and the procedure name, and that the '(', if any, immediately follows the procedure name. If the local keyword is given, it assumes that is is separated by a space from the procedure name. Added support to "profile" to correctly represent single-quotes and exclaimation points in code. Known Defects ------------- The "profile" function doesn't handle if, while, begin-procedure, etc that extend onto multiple lines. You may need to modify the generated code so that the debugp line falls after the last line of the command. SQRSH 1.1-0 1999/08/07 NOTES 1) SQR versions earlier than 3.0 (for example, 2.5.x) You should modify sqrsh.sqr and sqrsh.gen so that "#define SQR-DATABASE UNKNOWN" (which appears near the top of each of these files) reflects instead the database that that you are using. For example "#define SQR-DATABASE ORACLE". Under versions 3.0 and later, SQR-DATABASE is a pre-defined variable. Documented values for SQR-DATABASE under SQR 3.0: Allbase, DB2, Informix, Ingres, Oracle, Rdb, SQLBase, SYBASE. Documented values for SQR-DATABASE under SQR 4.0: DB2, INFORMIX, INGRES, ORACLE, SQLBASE, SYBASE, ODBC. RELEASES 1.1-0 1999/08/07 Added the optimize module. Added help for help, end, exit, quit, show, more, host. Added a mechanism to allow most modules to save a backup copy of the output file if it already exists, and to use a temporary file while processing to prevent loss of the original file. This is a little crude as it only allows one backup file per module. 1.0-3 1997/06/11 Compile was failing for SQR V2.5.x due to parameters passed using 3.0 parameter passing mechanism allowed for before= and after= procedures. Reverted to using globals. 1.0-2 1997/06/10 Compile was failing for SQR V2.5.x due to on-error procedures which used the parameter passing mechanism introduced in 3.0. Code was modified to no longer use this feature; the values are now passed as globals to the on-error procedures. 1.0-1 1997/06/09 Compile was failing for SQR V2.5.x due to undefined substitution variable {SQR-DATABASE}, which was not introduced until 3.0. Added default definition of #define SQR-DATABASE UNKNOWN. Unfortunately this requires that ORACLE users modify this line in under versions of SQR earlier than 3.0. 1.0-0 1997/06/07 Initial release