Error messages from BSQL are shown when you enter an illegal BSQL command or attempt to execute an erroneous SQL statement.
The error messages for erroneous SQL statements are the same as the return codes found in the Mimer SQL Programmer's Manual.
Error messages that can be received for illegal BSQL commands are:
-1500 Illegal value for <%> -1400 Invalid numerical argument -1300 Only select statements can be used with PRINT -1200 Previous perform file is not finished -1101 Disk space exhausted -1009 Unspecified file open error -1008 ** Installation dependent ** -1007 ** Installation dependent ** -1006 Disk space exhausted -1005 Maximum number of opened files exceeded -1004 File locked -1003 File protection violation -1002 File not found -1001 Syntax error in file name -999 Too long statement -900 No buffer saved -801 Pending transaction, Commit or Rollback -800 Load/unload is not allowed within a transaction -777 Maximum header length exceeded -776 Maximum record length <%> exceeded -701 Help topic not found -700 Help databank not installed or inaccessible -666 Space area exhausted -600 The number of host variables cannot exceed 20 -400 Record too large for one page (<%> lines required) Increase value of LC/PL or set them to zero -300 Failed to read dictionary -207 Too many parameters -206 Unexpected end of command -205 Invalid numerical literal -204 Filenames must be enclosed in apostrophes -203 String expected -202 Undefined keyword -201 Syntax error -104 Missing statement terminator (@) -103 Missing semicolon -102 <%> command not valid in this context -101 Ambiguous command <%> -100 Undefined command <%> -5 Conflict. One of COMMIT or ROLLBACK and EXIT or CONTINUE -3 Too many files have been opened -2 File could not be opened -1 String exceeds 256 characters which is not allowed
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40