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:
-1 String exceeds 256 characters which is not allowed -2 File could not be opened -3 Too many files have been opened -5 Conflict. One of COMMIT or ROLLBACK and EXIT or CONTINUE -100 Undefined command <%> -101 Ambiguous command <%> -102 <%> command not valid in this context -103 Missing semicolon -104 Missing statement terminator (@) -201 Syntax error -202 Undefined keyword -203 String expected -204 Filenames must be enclosed in apostrophes -205 Invalid numerical literal -206 Unexpected end of command -207 Too many parameters -300 Failed to read dictionary -400 Record too large for one page (<%> lines required) Increase value of LC/PL or set them to zero -600 The number of host variables cannot exceed 20 -666 Space area exhausted -700 Help databank not installed or inaccessible -701 Help topic not found -776 Maximum record length <%> exceeded -777 Maximum header length exceeded -800 Load/unload is not allowed within a transaction -801 Pending transaction , Commit or Rollback -802 Invalid transaction number, must be between 1 and <%> -803 Server version and BSQL version must be the same when using READLOG -804 The READLOG statement cannot be used within a transaction -805 Invalid string literal, missing delimiter (') -806 Error when reading from terminal -807 <%> logging has not been activated with the LOG command -900 No buffer saved -999 Too long statement -1001 Syntax error in file name -1002 File not found -1003 File protection violation -1004 File locked -1005 Maximum number of opened files exceeded -1006 Disk space exhausted -1007 ** Installation dependent ** -1008 ** Installation dependent ** -1009 Unspecified file open error -1101 Disk space exhausted -1200 Previous perform file is not finished -1300 Only select statements can be used with PRINT -1400 Invalid numerical argument -1500 Illegal value for <%> -1600 The routine is overloaded. Use describe specific instead. -1700 Maximum number of result items exceeded, limited to 300. -1800 Maximum number of input items exceeded, limited to 300.
Mimer Information Technology AB
Phone: +46 18 780 92 00