Numbered Messages

Note:

Two digits (nn) appear as replacement markers in the messages. Descriptions of these replacement markers are listed with the message. The messages contain the proper value when they appear on the screen.

Table 92. Numbered Messages  000001 to 000999

Error Number

Error Message

Suggestion/Interpretation

000001

Error while opening the message file: '`01' (`02): `03

Try reloading sqrerr.dat from the release media. If the error persists, contact technical support. `01 = Name of the error message file `02 = System error code `03 = System error message

000002

Error while reading the message file. (`01): `02

Try reloading sqrerr.dat from the release media. If the error persists, contact technical support. `01 = Name of the error message file `02 = System error code `03 = System error message

000004

Error while seeking the message file. (`01): `02

Try reloading sqrerr.dat from the release media. If the error persists, contact technical support. `01 = Name of the error message file `02 = System error code `03 = System error message

000005

Corrupt message file: Invalid header information.

Try reloading sqrerr.dat from the release media. If the error persists, contact technical support.

000006

Corrupt message file: Invalid count (Got `01, Should be `02).

The header contains an invalid entry count. Ensure SQRDIR points to the correct directory. Try reloading sqrerr.datfrom the release media. If the error persists, contact technical support. `01 = The value read from the header `02 = What the value should be

000010

Invalid SEMCode encountered: `01.

An invalid code was passed to the error message handler. Try reloading the files from the release media. If the error persists, contact technical support. `01 = Invalid code

000011

Unknown conversion type (`01) for code `02.

Try reloading sqrerr.dat from the release media. If the error persists, contact technical support. `01 = Invalid type `02 = Internal error code

000012

Message `01 must be either Preload or BuiltIn.

The type error code is not correct. Try reloading sqrerr.dat from the release media. If the error persists, contact technical support. `01 = Error code

000013

Cannot point to message `01.

The error handler cannot position to the desired error code. Try reloading sqrerr.dat from the release media. If the error persists, contact technical support. `01 = Error code

000014

The required environment variable `01 has not been defined.

Define the named environment variable and restart Production Reporting. `01 = Environment variable name

000015

The Meta ESC characters do not match (Got '`01', Should be '`02').

The meta escape character defined in the header does not match what the error message handler expects. Try reloading sqrerr.dat from the release media. If the error persists, contact technical support. `01 = What was found in the header `02 = What was expected to be found

000016

`01() called to process (`02) and the message file is not open.

The specified error routine was called but the error message file was not open. Try reloading the files from the release media. If the error persists, contact technical support. `01 = Name of the routine `02 = Error code

000017

Message `01 must be ReportParameters or CopyrightNotice.

Try reloading sqrerr.dat from the release media. If the error persists, contact technical support. `01 = Error code

000028

Cannot access the initialization file: `01 (`02): `03

The initialization file specified by the -ZIF command line flag cannot be accessed. `01 = Name of the file `02 = System error code `03 = System error message

000029

Unknown encoding name: `01

The encoding name specified by the -ZEN command line flag is not valid `01 = Encoding name

000202

DPUT: Bad field number.

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support.

000203

DARRAY: Unknown command number.

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support.

000204

`01: Cannot find `02 command.

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support. `01 = Name of the routine `02 = Name of the command

000205

DDO: DO arguments do not match procedure's.

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support.

000206

SDO: Bad params for DO command.

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support.

000207

SDO: Bad params for BEGIN-PROCEDURE command.

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support.

000209

SGOTO: Bad goto function parameters.

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support.

000210

SGOTO: Could not find beginning of section or paragraph.

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support.

000211

SGOTO: Bad label: from parameters.

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support.

000212

COMPAR: Unknown relational (numeric) operator.

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support.

000213

COMPAR: Unknown relational (string) operator.

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support.

000214

DONBRK: Unknown case for putlin.

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support.

000216

GARRAY: Unknown command number.

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support.

000217

GCMDS: No Gfunc found.

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support.

000218

GDOC: Unknown document type.

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support.

000219

GLET: Bad operator.

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support.

000220

GLET: Stack incorrect for expression - arg `01.

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support. `01 = Number of the argument

000221

GLET: Unknown operator type.

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support.

000222

GLET: Unknown operator in expression.

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support.

000223

GPARS: Column not SCOL, TCOL, or NCOL type.

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support.

000224

GPARS: Bad parameter format: `01 =`02=

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support. `01 = Internal command format string `02 = Bad format field found

000225

GPARS: No end of required word in parfmt: `01

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support. `01 = Internal command format string

000226

GPARS: Bad parfmt entry: `01

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support. `01 = Internal command format string

000227

GPARS: Bad parameter string.

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support.

000228

GPARS: Repeat count bad: `01

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support. `01 = Internal command format string

000229

GPARS: Only a,b,8,9 allowed for repeats: `01

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support. `01 = Internal command format string

000230

GPARS: Missing required x: `01

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support. `01 = Internal command format string

000231

GPARS: Bad type in 'ckvrpr()'.

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support.

000232

GPROC: No Gfunc found.

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support.

000233

GRDWRT: Unknown command number.

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support.

000234

GSHOW: Unknown SHOW option.

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support.

000235

PGMPARS: 'addvar()' passed maxlen but not column.

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support.

000238

PGMPARS: '`01' passed invalid parameter number: `02.

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support. `01 = Routine name `02 = Invalid parameter number

000239

PGMPARS: 'fxclrf()' encountered bad column reference type: `01.

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support. `01 = Internal variable type code

000240

PLCMNT: 'getplc()' passed invalid element number: `01.

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support. `01 = Invalid element number

000241

RDPGM: Command array size exceeded (change COMDMAX to at least `01).

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support. `01 = Maximum internal command number supported.

000242

RDPGM: Bad match adding internal variable: `01

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support. `01 = Internal variable name

000243

RDPGM: No cmdget function found for BEGIN_S.

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support.

000244

Function `01 not included in run-time package.

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support. `01 = Name of the SQR routine

000245

SETSQL: Could not find variable '`01', in Run Time.

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support. `01 = Variable name

000249

SPINIT: Bad parameters.

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support.

000251

DBFFIX: DBDATLEN returned out of range status.

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support.

000252

DPRPST: Error converting Sybase type for EXECUTE.

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support.

000254

SETSQL: Could not find variable entry in list.

(Oracle) Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support.

000255

DBDESC: SQLD not = number of select columns.

(DB2 and Informix) Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support.

000256

DBFETCH: Unknown variable dbtype encountered: `01 (`02)

(DB2 and Informix) Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support. `01 = Variable name `02 = Unknown database type

000257

WRITE_SPF: Unknown code encountered: `01

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support. `01 = Unknown SPF code

000258

`01: Cannot find LOAD-LOOKUP table: `02

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support. `01 = Name of the routine `02 = Name of the table

000259

PGMPARS: '`01' called with wrong variable '`02'

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support. `01 = Name of the routine `02 = Name of the variable

000261

MODIFYVAR: Attempt to change variable which is not xVAR (`01).

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support. `01 = name of the variable

000262

MODIFYVAR: Incompatible variable types (`01) and (`02).

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support. `01 = Variable type (from) `02 = Variable type (to)

Table 93. Numbered Messages  001000 to 001999

Error Number

Error Message

Suggestion/Interpretation

001201

Cannot open the argument file: '`01'. (`02): `03

Depends on the system error message. `01 = Name of the file `02 = System error code `03 = System error message

001202

Cannot close the

argument file. (`01): `02

Depends on the system error message. `01 = System error code `02 = System error message

001203

Cannot open the -MFile: '`01'. (`02): `03

Depends on the system error message. `01 = Name of the file `02 = System error code `03 = System error message

001204

Minimum value for '`01' in the -MFile is `02.

Correct the -Mfile entry. `01 = Keyword in question `02 = Minimum value allowed

001205

Maximum value for '`01' in the -Mfile is `02.

Correct the -Mfile entry. `01 = Keyword in question `02 = Maximum value allowed

001206

Invalid -MFile entry: '`01'.

Correct the -Mfile entry. `01 = The line from the -Mfile

001207

Cannot close the -MFile. (`01): `02

Depends on the system error message. `01 = System error code `02 = System error message

001209

The minimum value for '`01' (`02) is `03.

Value out of range. `01 = Entry name `02 = Specified value `03 = Minimum value

001210

The maximum value for '`01' (`02) is `03.

Value out of range. `01 = Entry name `02 = Specified value `03 = Maximum value

001211

The value for '`01' (`02) is not an integer number.

Value must be a integer value. `01 = Entry name `02 = Specified value

001300

Bind list does not match query (do not use '@__p' string).

Production Reporting reserves the variable names that start with "@__p" for internal use. Edit the source code and use different variable names.

001301

Forward references not permitted in select list bind variables.

Within the body of BEGIN-SQL paragraphs, forward references to &column names are not permitted. Move the BEGIN-SQL paragraph after the &column definition.

001303

Error in SQL (perhaps missing &name after expression):

The database server has determined that the SQL statement is in error. The actual error text from the server follows this message. Correct the SQL statement.

001304

Check SELECT columns, expressions and 'where' clause for syntax.

The database server has determined that the SQL statement is in error. The actual error text from the server follows this message. Correct the SQL statement.

001305

CMPSQL: Unknown data type in database: `01.

Contact technical support with the version of the database you are connected to. `01 = Datatype in question

001307

CMPSQL: DBDEFN failed.

(ODBC, Oracle, Informix) Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support.

001308

`01: Could not bind column `02.

(ODBC, Oracle, Informix) Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support. `01 = Name of the SQR routine `02 = Name of the column

001309

The type for '&`01' (`02) does not match the type from the database (`03).

Correct the source code. `01 = Name of the column/expression pseudonym `02 = User specified type `03 = Database type

001400

Only numerics allowed for arithmetic.

Only #numeric variables, &columns, and literals are permitted in the arithmetic commands. Correct the source code.

001401

Optional qualifier is ROUND=n (0-`01).

Correct the syntax. `01 = Maximum value for ROUND=

001402

Optional qualifiers for DIVIDE are ON-ERROR={HIGH|ZERO} and ROUND=n.

Correct the syntax.

001403

Attempting division by zero.

Use the ON-ERROR = HIGH | ZERO option to prevent this error from halting the program.

001404

Bad number of digits to ROUND or TRUNC (0-15).

Correct the syntax.

001405

WARNING: The ROUND or TRUNC qualifier is greater than the number's precision.

Correct the syntax.

001500

Array element out of range (`01) for array '`02' on line `03.

Correct the source logic. `01 = Element number passed `02 = Name of the array `03 = Program line number

001501

Field element out of range (`01) for array '`02', field '`03', on line `04.

Correct the source logic. `01 = Element number passed `02 = Name of the array `03 = Name of the field `04 = Program line number

001502

WARNING: Attempting division by zero on line `01. Array field '`02' unchanged. Run continuing...

The ARRAY-DIVIDE command has attempted division by zero. The division has been ignored; the result field is unchanged. Add logic to account for this possibility. `01 = Program line number `02 = Name of field

001601

'FILL' not appropriate for numeric data.

The FILL argument to the PRINT command may be used only for text fields. Move the #numeric variable to a $string variable, and then print the string variable.

001700

Report '`01': Columns must be between 1 and the page width (`02).

The specified value is wider than the width of the page. Correct the source line. `01 = Name of the current report `02 = Page width

001702

Report '`01': GOTO-TOP=`02 must be between 0 and the page depth (`03).

The value specified on the GOTO-TOP argument of the NEXT-COLUMN command was either less than 1 or greater than the page depth. Correct the source line. `01 = Name of the current report `02 = Goto-Top value `03 = Page width

001703

Report '`01': ERASE-PAGE=`02 must be between 0 and the page depth (`03).

The line number specified on the ERASE-PAGE argument of the NEXT-COLUMN command is greater than the page depth. Correct the source line. `01 = Name of the current report `02 = Erase-Page value `03 = Page width

001704

Report '`01': The NEXT-COLUMN command is not legal in the `02 section with the qualifier AT-END=NEWPAGE.

Correct the source line. `01 = Name of the current report `02 = Name of the section

001705

Report '`01': Column number `02 is not defined.

The column number specified with the USE-COLUMN command is greater than the highest column defined in the COLUMNS command. Correct the source line. `01 = Name of the current report `02 = Column number

001800

Format for CONNECT: username/password [ON-ERROR=procedure[(arg1[,argi]...)]]

Correct the syntax.

001801

Cannot use CONNECT while SQL statements are active.

Correct the program logic to ensure that all BEGIN-SELECT paragraphs have completed before executing the CONNECT command.

001802

Logoff failed prior to CONNECT.

The database server returned an error while trying to log off from the database. SQR aborts the program run since it cannot continue.

001803

CONNECT failed. Perhaps username/password incorrect.

The specified connectivity information is incorrect or there might have been a network failure. Use the ON-ERROR flag to trap any errors during the program run; otherwise SQR aborts the program run.

001804

Sybase extensions SET and SETUSER not permitted in SQR.

Remove SET and SETUSER from the source.

001805

USE allowed once in SETUP section only, not in BEGIN-SQL. Elsewhere, specify db.[user].table...

Correct the source.

001807

The requested database connection (`01) is already active.

The -Cnn value specified is being used by another BEGIN-SELECT paragraph that is currently selecting data. Use another connection number. `01 = Connection number

001808

Cannot find inactive database cursor. Program too large.

Too many BEGIN-SELECT and BEGIN-SQL paragraphs are active at the same time. Reduce the complexity of the program.

001809

Database commit failed.

(DB2, ODBC, Oracle) Should never occur during normal operations. Record the steps leading up to the error and contact your system administrator.

001810

Database rollback failed.

(DB2, ODBC, Oracle) Should never occur during normal operations. Record the steps leading up to the error and contact your system administrator.

001811

Cannot open database cursor.

(ODBC, Oracle) Should never occur during normal operations. Record the steps leading up to the error and contact your system administrator.

001901

Variable for date-time must begin with '&'.

Correct the syntax.

001913

Format code must be SYYYY when specifying signed year.

Correct the edit mask.

001914

Bad input data (`01) for edit mask: '`02'.

Correct the input. `01 = Data being converted `02 = Edit mask

001915

Year cannot be zero.

Correct the date.

001916

Year must be between ‑4713 and 9999 inclusive.

Correct the date.

001917

Ambiguous date-time.

Correct the date.

001918

'`01' is not a valid date part.

Correct the date part. `01 = Date part.

001919

Invalid day of week.

Correct the date.

001920

Format code cannot appear in date input format: '`01'.

Correct the edit mask. `01 = Improper format characters.

001921

Bad date mask starting at: '`01'.

Correct the edit mask. `01 = Improper format characters.

001922

Seconds past midnight must be between 0 and 86399.

Correct the date.

001923

Seconds must be between 0 and 59.

Correct the date.

001924

Minutes must be between 0 and 59.

Correct the date.

001925

Month must be between 1 and 12.

Correct the date.

001926

Day must be between 1 and `01.

Correct the date.

001927

Hour must be between 1 and 12.

Correct the date.

001928

Hour must be between 0 to 23.

Correct the date.

001929

HH24 precludes the use of meridian indicator.

Correct the edit mask.

001930

HH12 requires meridian indicator.

Correct the edit mask.

001931

Day of year must be between 1 and 365 (366 for leap year).

Correct the date.

001932

Date string too long.

Correct the date.

001933

The month (`01) is not valid for the current locale or database.

Correct the date. `01 = Name of the month.

001934

The format mask must be a literal when the date-time is not loaded into a variable.

Correct the format mask. The format mask must be a literal when the date-time is not loaded into a variable.

001935

Date-time format too long.

Correct the format mask.

001936

Bad date-time format.

Correct the format mask.

001937

Bad SQL for default date-time. (Table DUAL required for syntax.)

(Oracle) Possibly the format mask needs to be corrected; otherwise, there is a problem with the database server.

001937

Bad SQL for default date-time. (Table DUAL required for syntax.)

(DB2) Possibly the format mask needs to be corrected; otherwise, there is a problem with the database server.

001938

Cannot recompile sql.

A fatal error relating to the SQL statement used to retrieve the date-time was encountered. Record the steps leading up to the error and contact your system administrator.

001939

Problem executing cursor.

A fatal error relating to the SQL statement used to retrieve the date-time was encountered. Record the steps leading up to the error and contact your system administrator.

001940

Error fetching row.

A fatal error relating to the SQL statement used to retrieve the date-time was encountered. Record the steps leading up to the error and contact your system administrator.

001941

Cannot redefine variable addresses.

A fatal error relating to the SQL statement used to retrieve the date-time was encountered. Record the steps leading up to the error and contact your system administrator.

001942

The date '`01' is not in the format:

SYYYYMMDD[HH24[MI[SS[NNNNNN]]]].

When specifying an SQR date, at a minimum, the date must be specified; the time is optional. `01 = The invalid date.

001943

The date '`01' is not in one of the accepted formats listed below:

MM/DD/YYYY [BC | AD] [HH:MI[:SS[.NNNNNN]] [AM | PM]]

MM-DD-YYYY [BC | AD] [HH:MI[:SS[.NNNNNN]] [AM | PM]]

MM.DD.YYYY [BC | AD] [HH:MI[:SS[.NNNNNN]] [AM | PM]]

SYYYYMMDD[HH24[MI[SS[NNNNNN]]]]

The date specified with the INPUT command was not in one the default formats. Please re-enter the date in a valid format. `01 = The invalid date.

001944

The date '`01' is not in the format specified by SQR_DB_DATE_FORMAT or in one of the accepted formats listed below:

DD-MON-YY

SYYYYMMDD[HH24[MI[SS[NNNNNN]]]]

(Oracle) The date was not in one of the expected formats for this database. `01 = The invalid date.

001944

The date '`01' is not in the format specified by SQR_DB_DATE_FORMAT or in one of the accepted formats listed below:

Mon DD YYYY [HH:MI[:SS[.NNN]][AM | PM]]

Mon DD YYYY [HH:MI[:SS[:NNN]][AM | PM]]

YYYYMMDD [HH:MI[:SS[.NNN]][AM | PM]]

YYYYMMDD [HH:MI[:SS[:NNN]][AM | PM]]

SYYYYMMDD[HH24[MI[SS[NNNNNN]]]]

(Sybase) The date was not in one of the expected formats for this database. `01 = The invalid date.

001944

The date '`01' is not in the format specified by SQR_DB_DATE_FORMAT or in one of the accepted formats listed below:

Mon DD YYYY [HH:MI[:SS[.NNN]][AM | PM]]

Mon DD YYYY [HH:MI[:SS[:NNN]][AM | PM]]

YYYYMMDD [HH:MI[:SS[.NNN]][AM | PM]]

YYYYMMDD [HH:MI[:SS[:NNN]][AM | PM]]

SYYYYMMDD[HH24[MI[SS[NNNNNN]]]]

(ODBC) The date was not in one of the expected formats for this database. `01 = The invalid date.

001944

The date '`01' is not in the format specified by SQR_DB_DATE_FORMAT or in one of the accepted formats listed below:

Mon DD YYYY [HH:MI[:SS[.NNN]][AM | PM]]

Mon DD YYYY [HH:MI[:SS[:NNN]][AM | PM]]

YYYYMMDD [HH:MI[:SS[.NNN]][AM | PM]]

YYYYMMDD [HH:MI[:SS[:NNN]][AM | PM]]

SYYYYMMDD[HH24[MI[SS[NNNNNN]]]]

(DDO) The date was not in the one of the expected formats for this database.

`01 = The invalid date.

001944

The date '`01' is not in the format specified by SQR_DB_DATE_FORMAT or in one of the accepted formats listed below:

YYYY-MM-DD HH:MI:SS.NNN

SYYYYMMDD[HH24[MI[SS[NNNNNN]]]]

(Informix) The date was not in one of the expected formats for this database. `01 = The invalid date.

001944

The date '`01' is not in the format specified by SQR_DB_DATE_FORMAT or in one of the accepted formats listed below:

YYYY-MM-DD[-HH.MI.SS[.NNNNNN]]

MM/DD/YYYY

DD.MM.YYYY

SYYYYMMDD[HH24[MI[SS[NNNNNN]]]]

(DB2) The date was not in one of the expected formats for this database. `01 = The invalid date.

001944

The date '`01' is not in the format specified by SQR_DB_DATE_FORMAT or in one of the accepted formats listed below:

YYYY-MM-DD

SYYYYMMDD[HH24[MI[SS[NNNNNN]]]]

(Teradata) The date was not in the one of the expected formats for this database.

`01 = The invalid date

001946

The date variables are incompatible with each other.

The SQR function references two date variables which cannot be logically be used together (for example, DateDiff of 'date-only' and 'time-only' dates).

Table 94. Numbered Messages  002000 to 002999

Error Number

Error Message

Suggestion/Interpretation

002000

Procedure name used more than once: '`01'.

Give the procedure a unique name. `01 = Procedure name

002001

Could not find procedure: '`01'.

Check for a misspelled procedure name. `01 = Procedure name

002002

DO arguments do not match procedure's.

The argument lists for the DO and BEGIN-PROCEDURE commands must match in both type and count. Correct the source line.

002003

DO argument must be $string or #number to accept returned value.

Correct the syntax.

002100

Edit string too long.

The edit mask must be less than 255 characters. Reduce the length of the edit mask.

002101

Bad numeric 'edit' format: `01

The numeric edit mask contains an invalid character. See the PRINT command for the valid numeric edit mask characters. `01 = Invalid character

002103

DOLLAR-SYMBOL must be a single alphanumeric character or its decimal value enclosed in brackets: <nnn>.

Correct the syntax.

002104

DOLLAR-SYMBOL cannot be any of the following characters: `01

Correct the syntax. `01 = List of invalid characters

002106

MONEY-SYMBOL must be a single alphanumeric character or its decimal value enclosed in brackets: <nnn>.

Correct the syntax.

002107

MONEY-SYMBOL cannot be any of the following characters: `01

Correct the syntax.

002200

ENCODE string too large; maximum is `01.

Break up the ENCODE command. `01 = Maximum length of an ENCODE string supported by this version of SQR

002300

EXIT-SELECT failed.

The database command to cancel the query returned an error. Try running the SQR program again. The error could be related to a network or server problem. If the error persists, contact your system administrator.

002301

EXIT-SELECT valid only within SELECT paragraph.

Remove the EXIT-SELECT command.

002400

Duplicate label's - do not know which one to GOTO.

Labels must be unique within the section or paragraph where they are defined. Give each label a unique name.

002401

(Labels must be in same section or paragraph as GOTO.) Cannot find a matching label for GOTO command.

Check the source code.

002500

Error getting INPUT.

The C routine "fgets()" returned an error and SQR aborts the program run.

002501

Unknown INPUT datatype: type={char|number|integer|date}

Correct the syntax.

002502

INPUT STATUS= must reference #variable.

Correct the syntax.

002503

Unknown qualifier for INPUT.

Correct the syntax.

002506

Too long. Maximum `01 characters.

The response to the INPUT statement was too long. Re-enter the data. `01 = Maximum characters allowed

002507

Incorrect. Format for floating point number: [+|-]99.99[E99]

Invalid number was entered for an INPUT request. Re-enter the data.

002508

Incorrect. Format for integer: [+|-]999999

Invalid integer was entered for an INPUT request. Re-enter the data.

002510

A format mask can only be specified when TYPE=DATE is used.

Correct the syntax.

002511

The format mask cannot be stored in a date variable.

Correct the syntax.

002512

The input variable type does not match the TYPE qualifier.

Correct the syntax.

002513

Number too large for INTEGER. Valid range is -2147483648 to 2147483647.

The number was too large to be stored as an integer. Values are from -2147483648 to 2147483647. Re-enter the data.

002514

Enter a date in one of the following formats:

MM/DD/YYYY [HH:MI[:SS[.NNNNNN]] [AM | PM]]

MM-DD-YYYY [HH:MI[:SS[.NNNNNN]] [AM | PM]]

MM.DD.YYYY [HH:MI[:SS[.NNNNNN]] [AM | PM]]

SYYYYMMDD[HH24[MI[SS[NNNNNN]]]]

The date cannot be blank. Enter a date in one of the specified formats.

002515

`01 required user interaction but user interaction was disabled by the -XI command line flag.

The specified command required user interaction, but user interaction was disabled by the -XI command line flag. `01 = Name of the command

002600

LOAD-LOOKUP table '`01' has not been defined.

Add a LOAD-LOOKUP command. `01 = Load lookup table name

002601

Missing value for `01= in LOAD-LOOKUP.

Correct the syntax. `01 = Name of missing required parameter

002602

Bad value for `01= in LOAD-LOOKUP.

Correct the syntax. `01 = Name of the parameter

002603

LOAD-LOOKUP `01= cannot reference a variable in the Setup section.

Either move the LOAD-LOOKUP command from the Setup section or remove the variable reference. `01 = Name of the parameter

002604

LOAD-LOOKUP names must be unique.

Give each LOAD-LOOKUP array a unique name.

002605

Cannot compile SQL for LOAD-LOOKUP table '`01'.

The database server returned an error while trying to compile the SQL statement needed to process the LOAD-LOOKUP command. Check the column and table names. Also check the WHERE= clause for errors. `01 = Load lookup table name

002606

Could not set up cursor for LOAD-LOOKUP table '`01'.

The database server returned an error while trying to compile the SQL statement needed to set up the LOAD-LOOKUP command. Check the column and table names. Also check the WHERE= clause for errors. `01 = Load lookup table name

002607

Problem executing the cursor for LOAD-LOOKUP table '`01'.

The database server returned an error while trying to execute the SQL statement needed to process the LOAD-LOOKUP command. `01 = Load lookup table name

002609

Integers only allowed in numeric lookup keys.

Correct the source line.

002610

Numeric lookup keys must be <= `01 digits.

Correct the source line. `01 = maximum length supported

002611

Bad return fetching row from database in LOAD-LOOKUP table '`01'.

The database server returned an error while fetching the data. `01 = Load lookup table name

002613

Loading '`01' lookup table ...

This message can be inhibited by using the QUIET argument on the LOAD-LOOKUP command. `01 = Name of the load lookup table `02 = Number of rows loaded

002615

Warning: `01 duplicate keys found in '`02' lookup table.

This message can be inhibited by using the QUIET argument on the LOAD-LOOKUP command. `01 = Number of duplicate keys `02 = Name of the load lookup table

002616

LOAD-LOOKUP `01= must reference a numeric variable or literal.

Correct the source line. `01 = Name of the parameter

002617

LOAD-LOOKUP `01= must reference a string variable or literal.

Correct the source line. `01 = Name of the parameter

002618

LOAD-LOOKUP `01= variable '`02' has not been defined.

Correct the source line. `01 = Name of the parameter `02 = Name of the undefined variable

002619

LOAD-LOOKUP cannot support `01 rows; maximum is `02.

Reduce the ROWS= value. `01 = ROWS= value `02 = Maximum value allowed

002620

`01 command not allowed with -XL option in effect.

Either use the #IF command to conditionally compile the program when -XL is being used or do not execute this SQR report with the -XL option. `01 = SQR command

002700

Line to stop erasing for 'NEW-PAGE' is larger than the page depth.

Correct the source line.

002800

'ON-BREAK' not appropriate for numeric data.

The ON-BREAK argument to the PRINT command may be used only for text fields. Move the #numeric variable to a $string variable, and then print the $string variable.

002801

SET= and LEVEL= must be >= zero when indicated.

Correct the source line.

002802

Cannot use old style PROCEDURE= with BEFORE= or AFTER=.

Correct the syntax.

002804

SET= must be same for all ON-BREAKs in Select.

All the ON-BREAKS in a query must belong to the same SET. Use SET= to differentiate between ON-BREAKs in different queries. Correct the source line.

002805

ON-BREAK with BEFORE or AFTER must be inside Select.

Correct the source line.

002806

SAVE= must be a $string variable.

Correct the syntax.

002900

Record :types are FIXED, VARY, or FIXED_NOLF (default is VARY).

Correct the syntax.

002901

STATUS variable for `01 must be #Numeric.

Correct the syntax. `01 = SQR command affected

002902

OPEN missing required qualifiers: RECORD={rec_len} FOR-READING|FOR-WRITING|FOR-APPEND

Correct the syntax.

002903

Too many external files opened; maximum is `01.

Reduce the number of open external files needed by the program. `01 = Maximum number of open external files supported by this version of SQR

002904

File number already opened.

Check your program logic.

002905

Cannot open file '`01' AS `02.(`03): `04

SQR aborts. `01 = Filename `02 = File number `03 = System error code `04 = System error message

002906

Cannot close file `01 (`02): `03

SQR aborts. `01 = File number `02 = System error code `03 = System error message

002907

Problem closing user file(s) at the end of run.

This message may indicate system problems.

002908

Warning: Cannot CLOSE file `01 -- file not opened.

While not an error, this message indicates a problem with your SQR code. `01 = File number.

002909

Missing or invalid character set encoding: '`01'.

Specify a valid encoding: UCS-2, ASCII, EBCDIK1027, etc.

002910

This has been declared a UCS-2 file; however, the Byte-Order-Mark is missing or invalid.

A UCS-2 file must contain a Byte-Order-Mark.

002911

Cannot use `01 without setting UseUnicodeInternal to TRUE in SQR.INI.

The UseUnicodeInternal setting in the DEFAULT-SETTINGS section of the SQR.INI must be set to TRUE in order to use this functionality.

002912

The encoding `01 cannot be supported without the use of unicode. Set the UseUnicodeInternal setting in SQR.INI to TRUE.

The UseUnicodeInternal setting in the DEFAULT-SETTINGS section of SQR.INI must be set to TRUE in order to use this encoding.

002913

Invalid Unicode character representation used in the UNICODE Let function.

The string of hex characters representing a set of Unicode characters must be in the format '[whitespace|U+|u]XXXX' for the UNICODE Let function.

002914

The encoding `01 is not compatible with `02 unless unicode is used internally. Set the UseUnicodeInternal setting in the INI file to TRUE and rerun.

Certain encodings are not compatible unless unicode is used. The UseUnicodeInternal setting in the DEFAULT-SETTINGS section of SQR.INI must be set to TRUE in order to use these encodings in the same run.

002915

The file encoding `01 is not compatible with `02 unless unicode is used internally. Set the UseUnicodeInternal setting in the INI file to TRUE and rerun.

Certain encodings are not compatible unless unicode is used. The UseUnicodeInternal setting in the DEFAULT-SETTINGS section of SQR.INI must be set to TRUE in order to use these encodings in the same run.

002916

The SQT encoding `01 is not compatible with `02. Set the UseUnicodeInternal setting in the INI file to TRUE and rerun.

Certain encodings are not compatible unless unicode is used. The SQT was not generated using unicode; therefore, the encodings specified are incompatible.

Reset the encoding in conflict or regenerate the SQT with the UseUnicodeInternal setting in the DEFAULT-SETTINGS section of SQR.INI to TRUE in order to use these encodings in the same run.

002917

The SQT file was created using an SQR executable that does not support unicode. Please run the SQT using the appropriate executable.

(EBCDIC) The SQT file was created using SQR that does not support unicode. Therefore, it must be run with a non-unicode SQR or SQRT executable.

002918

An operation was detected that requires unicode; however, this executable cannot perform unicode processing. Relink or use the appropriate executable.

Unicode processing is required; however, the executable has not been linked with the Rosette Unicode library. Either relink the executable with the Rosette library or, for EBCDIC platforms, use the alternate executable that supports unicode processing.

002919

The field length `01 is invalid for I/O with UCS-2 data.

By definition, UCS-2 requires two bytes per character; however, the length specifier was odd. Make the length a multiple of two.

002920

:length must be a numeric literal, variable, or column.

Correct the syntax.

002921

Bad :length (`01) for OPEN command.

The length must be greater than zero.

`01 = Length value

Table 95. Numbered Messages  003000 to 003999

Error Number

Error Message

Suggestion/Interpretation

003000

PAGE-NUMBER strings too long.

The pre-and post-PAGE-NUMBER strings must be less than 74 characters. Correct the source line.

003100

Cannot find document marker referenced in POSITION command.

Defines the specified @ marker in a BEGIN-DOCUMENT paragraph. Check for a misspelled @ marker name.

003101

Only 'COLUMNS nn...' allowed after document marker in POSITION command.

Correct the syntax.

003200

Specified file number not opened for reading.

Files must be opened for reading in order to use the READ command with them. Correct the program logic.

003201

Line `01: Error reading the file. (`02): `03

`01 = Program line number `02 = System error code `03 = System error message

003202

Specified file number not opened for writing.

Files must be opened for writing in order to use the WRITE command with them. Correct the program logic.

003203

Line `01: Error writing the file. (`02): `03

`01 = Program line number `02 = System error code `03 = System error message

003204

Length of variables exceeds record length.

The total of the lengths indicated in the command must be less than the RECORD= argument used on the OPEN command. Check for a typographical error or recalculate the RECORD= value.

003205

Numeric binary transfer allowed with FIXED or FIXED_NOLF records only.

By default, all files are opened in VARY (variable length) mode, thus prohibiting the transfer of numeric binary data. Add the:FIXED or FIXED_NOLF option to the RECORD= argument on the appropriate OPEN command.

003206

Command not complete.

Correct the syntax.

003207

File number must be a numeric literal, variable, or column.

Correct the syntax.

003208

Missing required :length in READ command.

Correct the syntax.

003209

Bad :length (`01) for READ or WRITE command.

The length must not be less than zero.

`01 = Length value

003210

$String or #numeric variables required for READ.

Correct the syntax.

003211

#Numeric variables and literals must have :length of 1, 2 or 4 bytes.

Correct the syntax.

003212

#Numeric variables and literals on CDC may only have :length of 1 or 3 bytes.

Correct the syntax.

003214

:length must be a numeric literal, variable, or column.

Correct the syntax.

003300

Unknown qualifier for STOP.

Correct the syntax.

003301

Program stopped by user request.

Informational message.

003400

Wrap not appropriate for numeric data.

The WRAP argument to the PRINT command may be used only for text fields. Move the #numeric variable to a $string variable first, and then print the $string variable.

003401

Max `01 chars/line for reverse WRAP.

Reduce the number of characters specified. `01 = Maximum number of characters supported by this version of SQR.

003402

Max `01 chars/line for WRAP with ON= or STRIP=

Reduce the number of characters specified. `01 = Maximum number of characters supported by this version of SQR

003403

Bad <number> in WRAP qualifier.

The number inside the angled brackets must be a valid ASCII number (1 - 255). Correct the source line.

003404

Missing '>' in WRAP qualifier.

A leading "<" in the ON= or STRIP= qualifier indicates that a numeric value is following, which must be ended by a closing ">". Correct the source line.

003405

The value for '`01' (`02) must be `03 0.

The value specified for the specified qualifier is invalid. Correct the program logic. `01 = Qualifier name `02 = Value encountered `03 = Relation to zero (<,<=,=,>=,>)

003500

PUT, GET or ARRAY-xxxx command incomplete. Required word missing.

Correct the syntax.

003501

Did not find end of literal.

The ending quote character (') was not found at the end of the literal. Add the ending quote character.

003502

Literal too long.

Literal strings can be up to 256 characters long. Break up the literal into smaller pieces and combine using the LET command.

003503

Unknown variable type.

Variable names must begin with $, #, or &. Correct the source line.

003504

Cannot find 'array_name (#element)'.

The element number was not specified. Correct the source line.

003505

'(#Element)' variable not found for array.

Each GET or PUT command must indicate the element or row number to access in the array. Correct the source line.

003506

Array specified not defined with CREATE-ARRAY.

Use the CREATE-ARRAY command to define each array before referencing that array in other commands. Check for a misspelled array name.

003507

Bad element reference for array (#variable|123).

The element number is larger than the number of rows defined in the CREATE-ARRAY command. Check program logic to make sure that the element number was not inadvertently changed.

003508

Did not find ending ')' for field.

The "occurs" number for an array field is missing a right parenthesis. Correct the source line.

003509

Field not defined in array: `01

Check for a misspelled field name against the CREATE-ARRAY command. `01 = Undefined field name

003510

More variables than fields specified in array command.

The ARRAY command must not have more variables listed to the left of the array name than there are matching fields defined for the array. Check against the CREATE-ARRAY command.

003511

More variables in command than fields in array.

The ARRAY command must not have more variables listed to the left of the array name than there are matching fields defined for the array. Check against the CREATE-ARRAY command.

003512

Only numeric variables and fields allowed with array arithmetic commands.

The ARRAY-ADD, ARRAY-SUBTRACT, ARRAY-MULTIPLY, and ARRAY-DIVIDE commands may have only numeric variables or literals as the source fields. Move the string data into a #numeric variable and then reference the #numeric variable.

003513

GET can only be used with $string or #numeric variables.

You can move array fields only into $string variables or #numeric variables. Correct the source line.

003514

PUT and GET variables must match array field types.

When moving data into or out of arrays, the source or destination variables must match the array fields in type. CHAR fields can be stored into/from strings, NUMBER fields into/from numeric variables. Check the CREATE-ARRAY command.

003515

More fields than variables found in array command.

The ARRAY command must not have more variables listed to the left of the array name than there are matching fields defined for the array. Check against the CREATE-ARRAY command.

003516

Too many arrays defined; maximum is `01.

Reduce the number of arrays needed by the program. `01 = Maximum number of arrays supported by this version of SQR

003517

Missing '=specifier' in qualifier: `01

Correct the syntax. 01 = Name of missing required parameter

003518

Duplicate array name: `01

Change the name of the array. `01 = Array name in question

003519

Too many fields defined; maximum is `01.

Reduce the number of fields. `01 = Maximum number of fields allowed per array

003520

Missing ':type' in CREATE-ARRAY FIELD= `01

Correct the syntax. `01 = The name of the field

003521

Duplicate FIELD name: `01

Change the name of one of the fields. `01 = The name of the field

003522

Optional :nn for FIELD must be between 1 and 64K.

Correct the source line.

003523

CREATE-ARRAY FIELDS :type must be one of the following: `01

Correct the syntax.

003525

Missing NAME= in CREATE-ARRAY.

Correct the syntax.

003526

Missing or incorrect SIZE= in CREATE-ARRAY.

Correct the syntax.

003527

Missing FIELD= statements in CREATE-ARRAY.

Correct the syntax.

003529

Missing or invalid initialization value for field `01.

Correct the syntax. 01 = Name of the field

003530

Invalid EXTENT= value in CREATE-ARRAY.

Correct the syntax.

003600

Missing 'ask' variable name.

Correct the syntax.

003603

WARNING: Substitution variables do not vary when saved with run-time.

Informational message.

003605

No substitution variable entered.

The C routine "fgets()" returned an error and SQR aborts the program run.

003700

Did not find end of paragraph: `01

Missing the END-paragraph command to match the specified paragraph. Correct the source file. `01 = BEGIN-paragraph in question

003701

Invalid command.

Check for a misspelled command.

003702

Command not allowed in this section: `01

Correct the syntax. `01 = Offending command name

003703

Paragraph not allowed inside procedure.

The BEGIN-paragraph command is not allowed here. Check your SQR code for a misplaced paragraph.

003704

Missing procedure name.

Correct the syntax.

003705

Extra argument found.

Correct the syntax.

003706

Missing Comma.

Correct the syntax.

003707

Bad Argument List.

The DO or BEGIN-PROCEDURE command has an error in its argument list, possibly extra characters after the final right parentheses. Correct the source line.

003708

Empty Argument.

The DO or BEGIN-PROCEDURE command has an error in its argument list, possibly two commas in a row inside the parentheses. Correct the source line.

003709

Only $string and #number variables allowed for BEGIN-PROCEDURE parameters.

Correct the syntax.

003710

Unknown argument type.

An argument in a DO or BEGIN-PROCEDURE command is incorrect. Check for a misspelled variable type.

003711

Indicate :$string or :#number returned values in BEGIN-PROCEDURE only.

Correct the syntax.

003712

Missing ).

Correct the syntax.

003713

`01 paragraph not allowed with -XL option in effect.

Either use the #IF command to conditionally compile the program when -XL is being used or do not execute this SQR report with the -XL option. `01 = Name of the BEGIN-paragraph

003714

Bad database connection number.

The -Cnn value must be a non-zero value. Correct the source line.

003715

Did not find end of paragraph: `01 (No 'from...' clause found.)

Correct the source code. `01 = BEGIN-command in question

003716

Error in SQL statement.

The database server has determined that the SQL statement is in error. The actual error text from the server follows this message. Correct the SQL statement.

003717

Extra characters after expression continuation.

Remove the extra characters after the dash.

003718

Did not find end of expression.

An expression in a SELECT list must end with either a &column variable or a position parameter "(Row,Col,Len)". Correct the source line.

003719

Columns names and expressions must be unique or be given unique pseudonyms (&name).

Columns retrieved from the database are assigned names by prepending an "&" to the beginning of the name. You are trying to select the same &column name more than once. Change the assigned &column name by using an alias after the name.

003720

Bad number specified for 'LOOPS=' on 'BEGIN-SELECT; Maximum is 32767'.

If your program logic requires that you stop processing after more than 32767 rows have been retrieved, you could count the rows manually and use the EXIT-SELECT command to break out of the SELECT loop.

003721

Bad param found on 'BEGIN-SELECT' line; Format is: BEGIN-SELECT [DISTINCT] [-Cnn] [-Bnn] [LOOPS=nn] [ON-ERROR=procedure[(arg1[,argi]...)]]

(DB2) Correct the syntax.

003721

Bad param found on 'BEGIN-SELECT' line; Format is: BEGIN-SELECT [DISTINCT] [-Cnn] [LOOPS=nn] [ON-ERROR=procedure[(arg1[,argi]...)]]

(Informix) Correct the syntax.

003721

Bad param found on 'BEGIN-SELECT' line; Format is: BEGIN-SELECT [DISTINCT] [-Cnn] [LOOPS=nn] [ON-ERROR=procedure[(arg1[,argi]...)]] [-DB=database]

(ODBC) Correct the syntax.

003721

Bad param found on 'BEGIN-SELECT' line; Format is: BEGIN-SELECT [LOOPS=nn] [ON-ERROR=procedure[(arg1[,argi]...)]] [BEFORE=procedure[(arg1[,argi]...)]] [AFTER=procedure[(arg1[,argi]...)]]

(DDO) Correct the syntax.

003721

Bad param found on 'BEGIN-SELECT' line; Format is: BEGIN-SELECT [DISTINCT] [-Cnn] [-Bnn] [LOOPS=nn] [ON-ERROR=procedure[(arg1[,argi]...)]]

(Oracle) Correct the syntax.

003721

Bad param found on 'BEGIN-SELECT' line; Format is: BEGIN-SELECT [DISTINCT] [-Cnn] [-XP] [LOOPS=nnn] [ON-ERROR=procedure[(arg1[,argi]...)]]

(Sybase) Correct the syntax.

003721

Bad param found on 'BEGIN-SELECT' line; Format is: -SELECT [DISTINCT] [-Cnn] [-Bnn] [LOOPS=nn] [ON-ERROR=procedure[(arg1[,argi]...)]]

(Teradata) Correct the syntax.

003722

Could not set up cursor.

An error occurred while trying to compile the SQL statement. Look closely at any $string variable references. Correct the SQL statement or use the ON-ERROR= option to trap the error during the program run.

003723

Problem executing cursor.

An error occurred while trying to execute the SQL statement. Look closely at any $string variable references. Correct the SQL statement or use the ON-ERROR= option to trap the error during the program run.

003724

Could not exit query loop.

The database command to cancel the query returned an error. Try running the SQR program again. The error could be related to a network or server problem. If the error persists, contact your system administrator.

003725

Bad return fetching row from database.

The database returned an error status for the last row that was fetched, commonly due to the buffer not being large enough. If selecting expressions, make sure that the length of the first expression will be adequate for all rows selected.

003726

Literal in SQL expression missing closing quote.

Literals must be surrounded by single quotes ('). To embed a quote within a literal use two single quotes in sequence (''). Correct the source line.

003727

SQL expression not ended, perhaps parentheses not balanced.

An expression in a SELECT list must end with either a &column variable or a position parameter "(Row,Col,Len)". Correct the source line.

003728

SQL expression not ended, perhaps missing &name.

An expression in a SELECT list must end with either a &column variable or a position parameter "(Row,Col,Len)". Correct the source line.

003729

SQL expression is missing &name or has unbalanced parentheses.

An expression in a SELECT list must end with either a &column variable or a position parameter "(Row,Col,Len)". Correct the source line.

003730

Incorrect arguments for BEGIN-SQL: [-Cnn] [ON-ERROR=procedure[(arg1[,argi]...)]]

(DB2) Correct the syntax.

003730

Incorrect arguments for BEGIN-SQL: [-Cnn] [ON-ERROR=procedure[(arg1[,argi]...)]]

(Informix) Correct the syntax.

003730

Incorrect arguments for BEGIN-SQL: [-Cnn] [-NR] [ON-ERROR=procedure(arg1[,argi]...)]] [-DB=]

(ODBC) Correct the syntax.

003730

Incorrect arguments for BEGIN-SQL: [-Cnn] [ON-ERROR=procedure[(arg1[,argi]...)]]

(Oracle) Correct the syntax.

003730

Incorrect arguments for BEGIN-SQL: [-Cnn] [ON-ERROR=procedure[(arg1[,argi]...)]] [-Connection=]

(DDO) Correct the syntax.

003730

Incorrect arguments for BEGIN-SQL:

[-Cnn] [-XP] [ON-ERROR=procedure[(arg1[,argi]...)]]

(Sybase) Correct the syntax.

003730

Incorrect arguments for BEGIN-SQL: [-Cnn] [ON-ERROR=procedure[(arg1[,argi]...)]]

(Teradata) Correct the syntax.

003731

Did not find 'END-SQL' after 'BEGIN-SQL'.

Correct the source file.

003732

ON-ERROR= for 'BEGIN-SQL' in SETUP section must be STOP, WARN or SKIP.

Correct the syntax.

003733

Could not create procedure for SQL.

(Sybase) SQR could not create a stored procedure for the SQL statement. The most likely cause for failure is that the user name you are using to run the report under does not have the proper privileges. Either grant the user CREATE PROCEDURE privilege or use the -XP command line option to inhibit SQR from creating temporary stored procedures for SQL statements.

003734

Could not compile SQL.

Correct the SQL statement or use the ON-ERROR= option to trap the error during the program run.

003735

Could not execute SQL.

An error occurred while trying to compile the SQL statement. Correct the SQL statement or use the ON-ERROR= option to trap the error during the program run.

003736

Please use BEGIN-SELECT - END-SELECT section for SELECT statements.

(Informix, ODBC, Oracle, DDO) Correct the source code.

003737

Bad fetch buffer count.

(Oracle, Sybase) The -B flag specifies an illegal value. Correct the source code.

003738

Report interrupted by request.

Informational message.

003741

Dynamic column must be $string variable.

Correct the syntax.

003742

Dynamic column missing '`01'.

Correct the syntax. `01 = Missing character

003743

Dynamic columns must have a &pseudonym.

Correct the syntax.

003745

Only a variable name may be between the '`01' and '`02' characters.

Correct the syntax. `01 = Leading character `02 = Trailing character

003746

When dynamic columns are used all non-dynamic columns and expressions must be defined with &name=type.

Add &name=type to all expressions and non-dynamic columns.

003747

When the table name is dynamic each column and expression must be defined with &name=type.

Add &name=type to all expressions and non-dynamic columns.

003748

When selecting multiple rowsets, they must have the same columns (order, type, width).

Non-contiguous rowsets selected in ROWSETS=().

003749

The highest numbered rowset named in ROWSET=() must be less than 10.

Rowset upper bound exceeded in ROWSETS=().

003750

Correct syntax is ROWSETS=(-n,m,n-m,i-) or (all).

Correct the syntax in ROWSETS=().

003751

Cannot select more than 25 Rowsets in a single BEGIN-SELECT.

Correct the syntax in ROWSETS=().

003752

One of the selected fields ('`01') was not found in the specified row set(s). The available fields are: '`02'.

Field not found in BEGIN-SELECT.

003755

Rowsets must be listed in ascending order, and may not include duplicates.

Bad rowset numbering sequence in BEGIN-SELECT.

003800

Too many document paragraphs; maximum is `01.

There are too many BEGIN-DOCUMENT paragraphs. Reduce the number of DOCUMENT paragraphs needed by the program. `01 = Maximum number supported by this version of SQR

003801

Too many document markers; maximum is `01.

There are too many BEGIN-DOCUMENT paragraphs. Reduce the number of DOCUMENT paragraphs needed by the program. `01 = Maximum number supported by this version of SQR

003802

Duplicate document marker.

Give the document marker a unique name.

003803

Did not find 'END-DOCUMENT' after 'BEGIN-DOCUMENT'.

The BEGIN-DOCUMENT paragraph must end with END-DOCUMENT. Correct the source code.

003900

EXECUTE command is incomplete.

Correct the syntax.

003901

Bad -Cnn connection number for EXECUTE.

The -Cnn value must be a nonzero value. Correct the source line.

003902

@#Return_status must be #numeric (missing #).

(Sybase) Correct the source line.

003902

@#Return_status must be #numeric (missing #).

(ODBC) Correct the source line.

003902

@(# or $)Return_status must be #numeric or $variable.

(Oracle) Correct the source line.

003902

@#Return_status must be #numeric (missing #).

(DB2) Correct the source line.

003903

Missing '=' after `01.

Correct the source line. `01 = The parameter in question

003904

Unknown variable type.

Variable names must begin with $, #, or &. Correct the source line.

003905

OUT[PUT] variables for EXECUTE may only be $variable or #variable.

Correct the syntax.

003906

The only EXECUTE option is WITH RECOMPILE.

Correct the syntax.

003907

You must EXECUTE ... INTO &columns.

Correct the syntax.

003908

Unknown datatype for EXECUTE...INTO &columns.

Check for a misspelled data type. If the data type is correct, then contact customer technical support so SQR can be updated.

003909

EXECUTE...INTO &columns must be unique.

The &column name assigned to the column must be unique throughout the report. Give the column a unique name.

003910

Missing (length) for datatype in EXECUTE.

Correct the source line.

003911

Datatype should not have (length) in EXECUTE.

Correct the source line.

003912

DO= in EXECUTE requires INTO... variables.

Correct the syntax.

003913

Could not EXECUTE stored procedure.

(Sybase) Record the database error message displayed with this message. If needed, contact your system administrator.

003913

Could not EXECUTE stored procedure.

(ODBC) Record the database error message displayed with this message. If needed, contact your system administrator.

003913

Could not EXECUTE stored procedure or function.

(Oracle) Record the database error message displayed with this message. If needed, contact your system administrator.

003913

Could not EXECUTE stored procedure or function.

(DB2) Record the database error message displayed with this message. If needed, contact your system administrator.

003914

Bad return fetching row from database.

Record the database error message displayed with this message. If needed, contact your system administrator.

003915

Could not set up EXECUTE cursor.

The database server returned an error while trying to compile the SQL statement needed to set up the EXECUTE command.

003918

Missing Stored Procedure or Function - '`01'.

(Oracle) A describe of the store procedure or function could not be performed.

`01 = Procedure or function name

003918

Missing Stored Procedure - '`01'.

(DB2) A describe of the store procedure or function could not be performed.

`01 = Procedure or function name

003920

The EXECUTE command had an erroneous return status data type of '`02' declared. The Stored Function expects a return status of '`01'.

(Oracle) The wrong data type has been specified for the return status of a Stored Function.

`01 = Expected Data Type

`02 = Return Data Type

003921

The EXECUTE command detected an erroneous data type of '`02' declared for the IN/OUT parameter - name/position: `03/`04. The Stored Function or Procedure expects a parameter data type of '`01'.

(Oracle) The wrong data type has been specified for the return variable of a Stored Procedure.

`01 = Expected Data Type

`02 = Return Data Type

`03 = Name of Parameter

`04 = Position of Parameter

003921

The EXECUTE command detected an erroneous data type of '`02' declared for the IN/OUT parameter - name/position: `03/`04. The Stored Procedure expects a parameter data type of '`01'.

(DB2) The wrong data type has been specified for the return variable of a Stored Procedure.

`01 = Expected Data Type

`02 = Return Data Type

`03 = Name of Parameter

`04 = Position of Parameter

003922

The maximum number of allowable IN/OUT parameters was reached. No more than '`01' can be processed by the EXECUTE command.

(DB2) The maximum number of allowable IN/OUT parameters was reached.

`01 = Maximum Number of Parameters

003923

The procedure was found in multiple schemas and will not be processed. The '`01.`02' procedure was also found in the '`03' schema.

(DB2) The request procedure was found in multiple schemas and can not be processed.

`01 = Schema Name

`02 = Stored Procedure Name

`03 = Alternate Schema Name

003924

No match was found for the named parameter - '`01'.

(Oracle, DB2) No match was found for one of the input or output parameters with those returned from the describe of the stored procedure or function.

Check the names of the stored procedure's or function's input or output parameters and make the necessary corrections.

`01 = Parameter Name

003925

The EXECUTE command detected a data type of '`02' declared for the INTO parameter - name/position: '`03 / `04'. The Stored Function or Procedure expects a parameter data type of '`01'.

(Oracle) The wrong data type has been specified for the INTO variable of a Stored Procedure.

`01 = Expected Data Type

`02 = Return Data Type

`03 = Parameter Name

`04 = Parameter Position

003926

The EXECUTE command detected that '`02' INTO parameters were requested. No more than '`01' can be processed by this Stored Function or Procedure.

(Oracle) The maximum number of allowable INTO parameters was exceeded.

`01 = Number of Allowable Parameters

`02 = Number of Parameters Entered

003927

The EXECUTE command detected a weak reference cursor.

(Oracle) A weak reference cursor has been detected. No validation on the data types for the INTO parameters is made.

003928

The wrong number of IN/INOUT parameters were found.

(DB2) The wrong number of IN/INOUT parameters were found. This Stored Function or Procedure requires that '`01' parameters be entered.

`01 = Required Number of Parameters

Table 96. Numbered Messages  004000 to 004999

Error Number

Error Message

Suggestion/Interpretation

004000

Result #variabe or $variable or '=' missing in expression.

The LET command is not properly formatted. Correct the source line.

004001

Expression too complex.

The expression is either too long or is too deeply nested. Break the expression into smaller expressions.

004002

Parentheses unbalanced in expression.

A left or right parenthesis is missing. Correct the source line.

004003

Too many variables; maximum is `01.

Break the expression into smaller expressions. `01 = Maximum number supported by this version of SQR

004004

Empty expression.

The expression is invalid. Correct the source line.

004005

Extra comma in expression.

An argument is missing after a comma in the expression. Correct the source line.

004006

Unknown operator '`01'. Do you mean `02 ?

The concatenation operator is ||. Correct the source line.

004007

Too many &column forward references in expression; maximum is `01.

The expression contains too many forward references. Break the expression into smaller expressions. `01 = Maximum number supported by this version of SQR

004008

Unknown function or variable in expression: `01

The specified function is not an SQR built-in function nor does it exist in the user-modifiable file UFUNC.C. Check for a misspelled function name. `01 = Function name

004009

Function '`01' missing parentheses.

All functions in an expression must be followed by their arguments enclosed in parentheses. Correct the source line.

004010

Empty parentheses or expression.

A pair of parentheses were found with nothing inside them. Remove the () in question from the source line.

004011

User function '`01' has incorrect number of arguments.

Look at the file UFUNC.C to determine the correct number and type of arguments required for the specified function. `01 = User function name

004012

Function '`01' has incorrect number of arguments.

Correct the syntax of the function. Functions are described under the LET command. `01 = SQR function name

004013

Missing operator in expression.

Correct the source line.

004014

Operator '`01' missing argument.

Correct the syntax of the function. Functions are described under the LET command. `01 = Operator

004015

Function '`01' missing argument.

Correct the syntax of the function. Functions are described under the LET command. `01 = SQR function name

004016

Function or operator '`01' missing arguments.

Correct the syntax of the function. Functions are described under the LET command. `01 = SQR function name

004017

User function '`01' requires character argument.

Look at the file UFUNC.C to determine the correct number and type of arguments required for the specified function. `01 = User function name

004018

User function '`01' requires numeric argument.

Look at the file UFUNC.C to determine the correct number and type of arguments required for the specified function. `01 = User function name

004019

User function '`01' requires $string variable.

Look at the file UFUNC.C to determine the correct number and type of arguments required for the specified function. `01 = User function name

004020

User function '`01' requires #numeric variable.

Look at the file UFUNC.C to determine the correct number and type of arguments required for the specified function. `01 = User function name

004021

User function '`01' has incorrect argument type list. Must be of: c,n,C,N

The UFUNC.C file has a bad definition for the specified function. Correct the UFUNC.C program file; recompile UFUNC.C; and recreate the SQR executable. `01 = User function name

004022

User function '`01' missing arguments.

Look at the file UFUNC.C to determine the correct number and type of arguments required for the specified function. `01 = User function name

004023

User function '`01' has incorrect return type. Must be c or n.

The UFUNC.C file has a bad definition for the specified function. Correct the UFUNC.C program file; recompile UFUNC.C; and recreate the SQR executable. `01 = User function name

004024

'isnull' requires a &column, $string, or $date argument.

#numeric variables cannot be NULL. Correct the source line.

004025

'nvl' requires a &column, $string, or $date as its first argument.

#numeric variables cannot be NULL. Correct the source line.

004026

Function or operator '`01' requires character argument.

Correct the source line. `01 = Function or operator

004027

Function or operator '`01' requires numeric argument.

Correct the source line. `01 = Function or operator

004028

IF or WHILE expression must return logical result.

The expression used must evaluate a statement that will be TRUE or FALSE. Correct the source line.

004029

Attempting division by zero in expression.

The expression tried to divide a number by zero. Use the COND() function to check if the divisor is zero; then divide by something else (for example, 1).

004030

Attempting division by zero with '%'.

An attempt was made to divide a number using the " %" operator. Use the COND() function to check if the divisor is zero; then divide by something else (for example, 1).

004031

The number used with '%' (`01) is out of range.

The "%" operator works with integers only. Correct the program logic. `01 = Maximum value allowed

004032

User function has unknown return type -- expecting n or c -- need to recompile Run-Time file?

SQR detected an error while processing a user defined function. If you are running an .sqt file, it probably needs to be recompiled because the user function has changed its definition. If you are running an .sqr file, then you need to correct the UFUNC.C program file; recompile UFUNC.C, and recreate the SQR executable.

004033

In user function use C type with allocated string to change $variable.

SQR detected an error while processing a user defined function. Correct the UFUNC.C program file recompile UFUNC.C and recreate the SQR executable.

004034

Could not find array '`01' in ARRAY function.

Check for a misspelled array name. `01 = Array name

004035

Could not find array field '`01' in ARRAY function.

Check for a misspelled array field name. `01 = Array field name

004036

Math error in expression (usually over- or under-flow).

Most of the SQR mathematical built-in functions have a corresponding C library routine. One returned an error. Break the expression into discrete expressions in order to identify the function that caused the error.

004037

Error executing expression.

Record the steps leading up to the error and contact technical support.

004038

Out of space while processing expression;

Use -Mfile to increase EXPRESSIONSPACE.

The expression requires more temporary string storage than is currently allocated. Use the -Mfile flag on the command line to specify a file that contains an entry that increases by a greater value than is currently defined.

004039

'`01' assumed to be a variable name, not an expression.

Warning message. `01 = Expression in question

004040

The array '`01' has not been defined.

Define the array using the CREATE-ARRAY command. `01 = Array name

004041

The field '`01' is not valid for array '`02'.

Correct the source code. `01 = Field name `02 = Array name

004042

The array reference '`01' has an incorrect number of parameters specified.

Correct the source code. `01 = Array name

004043

The array reference '`01' requires numeric parameters for the element and occurs arguments.

Correct the source code. `01 = Array name.

004045

Function or operator '`01' requires date argument.

Correct the source code. `01 = Array name

004046

Incompatible types between expression and variable.

Correct the source code.

004047

The field '`01' is must be 'char' or 'float'.

Correct the source code. `01 = Field name

004048

Function or operator '`01' must be a string or date argument.

Correct the source line. `01 = Function or operator

004049

Unknown transform value '`01' in TRANSFORMATION function.

Check for a misspelled transform value. `01 = Transform value

004100

Use 'print' command to format data outside SELECT query.

You must precede PRINT command arguments (WRAP, ON-BREAK.) with an explicit PRINT command when outside of a BEGIN-SELECT paragraph. Correct the source line.

004101

Cannot find required parameter.

Correct the syntax.

004102

Bad number found.

A command expecting a numeric literal or :#numeric variable reference found an illegal number definition or a reference to a string variable or column. Correct the source line.

004103

Cannot find required numeric parameter.

Correct the syntax.

004104

Cannot find placement parameters.

The position qualifier "(Row,Col,Len)" was not found. Check for a missing parentheses.

004105

Placement parameter incorrect.

The "Row", "Column" or "Length" fields are invalid or ill-formed. Correct the source line.

004106

Invalid second function on line.

An SQR command used as a qualifier for a primary command (for example, PRINT) is incorrect. Correct the source line.

004107

Second function must be FORMAT type.

The PRINT command may have format command qualifiers such as WRAP, CENTER, or FILL. Other qualifier commands are not permitted.

004108

Missing operator =, <, >, ...

Correct the source line.

004109

Invalid operator.

Correct the source line.

004110

Missing variable.

Correct the syntax.

004111

Please give this expression a &pseudonym.

Expressions selected in BEGIN-SELECT should be given an &Name or be followed by a print position "(Row,Col,Len)". Correct the source line.

004112

Wrong variable type.

Correct the syntax.

004113

Command incomplete, expected '`01'.

Correct the syntax. `01 = What was expected

004114

Expecting '`01', found '`02'.

Correct the syntax. `01 = What was expected `02 = What was encountered

004115

Unknown command or extra parameters found (missing quotes?).

Correct the syntax.

004116

Duplicate references to parameter '`01'.

Correct the syntax. `01 = Duplicated parameter

004117

Unexpected equal sign found with '`01'.

Correct the syntax. `01 = Parameter name

004118

Qualifier '`01' cannot be used with the following qualifiers:

Correct the syntax. `01 = Qualifier name

004119

Expecting numeric column, found string column.

Correct the syntax.

004120

Date variables (`01) cannot be used with this command.

Correct the syntax. `01 = Parameter name

004200

Page width and depth must be > 0 and < 32767.

The values specified with PAGE-SIZE are out of bounds. Specify legal values.

004300

Missing end of placement (...) in SHOW.

The placement parameter is ill-formed. Correct the source line.

004301

Bad (...) location in SHOW.

Screen positions must be valid numbers. Correct the source line.

004302

Missing literal or variable name to EDIT in SHOW.

The literal or variable name must immediately precede the EDIT, NUMBER, MONEY, or DATE keywords.

004303

Missing edit mask in SHOW.

The word EDIT must be followed by a valid edit mask. Correct the source line.

004304

Only string variable allowed for dynamic edit mask.

Dynamic edit masks may only be stored in $Variables. Correct the line.

004305

Unknown option for SHOW.

Correct the syntax.

004406

Number `01 not allowed.

Use a different value. `01 = Internal number

004407

Referenced variables not defined:

References were made to column variables (&var) that were not defined in the program. The list of variable names follows this message.

004501

Use '+' and negate variable for reverse relative placement.

The use of "-#Variable" is not legal here. Negate the #Variable value and use "+#Variable".

004503

Fixed line placement #variable must be > 0. Use relative positioning, (+#line,10,0).

Correct the source line as indicated.

004504

Fixed column placement #variable must be > 0. Use relative positioning, (5,+#col,0).

Correct the source line as indicated.

004505

Length placement #variable must be >= 0.

The length field cannot be a negative value. Correct the source line.

004600

CODE not appropriate for numeric data.

The CODE qualifie rin PRINT may only be used for text fields. Move “#Variable” to “$Variable” first and then print “$Variable”.

004601

Unknown option for GRAPHIC command: BOX, HORZ-LINE, VERT-LINE or FONT

Correct the syntax.

004602

GRAPHIC BOX out of bounds. Row: `01, Column: `02, Width: `03, Depth: `04

SQR aborts the program run. `01 = Row `02 = Column `03 = Width `04 = Depth

004603

GRAPHIC VERT-LINE out of bounds. Row: `01, Column: `02, Length: `03

SQR aborts the program run. `01 = Row `02 = Column `03 = Length

004604

GRAPHIC HORZ-LINE out of bounds. Row: `01, Column: `02, Length: `03

SQR aborts the program run. `01 = Row `02 = Column `03 = Length

004605

Cannot draw the box; values are out of bounds. Row: `01, Column: `02, Width: `03, Height: `04

SQR aborts the program run `01 = Row `02 = Column `03 = Width `04 = Height

004606

Cannot draw the vertical line; values are out of bounds. Row: `01, Column: `02, Height: `03

SQR aborts the program run `01 = Row `02 = Column `03 = Height

004607

Cannot draw the horizontal line; values are out of bounds. Row: `01, Column: `02, Width: `03

SQR aborts the program run `01 = Row `02 = Column `03 = Width

004700

Cannot open the program file: '`01' (`02): `03

Depends on the system error message. `01 = Name of the program file `02 = System error code `03 = System error message

004701

Cannot logon to the database.

Connectivity information is either incorrect or the database server is unavailable. Check connectivity information and the server availability.

004702

Line found outside paragraph.

All commands must be within BEGIN-... END statements. Correct the source code.

004703

Cannot close the program file. (`01): `02

Depends on the system error message. `01 = System error code `02 = System error message

004704

#ENDIF not found for #IF.

Missing an #ENDIF to complete conditional compilation. Correct the source code.

004705

Program line too long; maximum is `01.

Break the program line into smaller lines. `01 = Maximum line length supported by this version of SQR

004706

Substitution variable {`01} would cause this line to exceed the maximum line length of `02 characters.

The substitution variable value would cause this line to exceed the maximum line size. Break the program line into smaller lines. `01 = Name of the substitution variable `02 = Maximum line length supported by this version of SQR

004707

No value found for substitution variable: {`01}

An empty value was found for the substitution variable. Check for a misspelled name. `01 = Name of the substitution variable

004708

#ELSE without preceding #IF.

Missing an #IF or #IFDEF or #IFNDEF to begin conditional compilation. Correct the source code.

004709

#ENDIF without preceding #IF.

Missing an #IF or #IFDEF or #IFNDEF to begin conditional compilation. Correct the source code.

004710

#IF's nested too deeply; maximum is `01.

Reduce the number of nested #IF directives. `01 = The maximum depth supported by this version of SQR

004711

#INCLUDE files nested too deeply; maximum is `01.

Reduce the number of nested #INCLUDE directives. `01 = The maximum depth supported by this version of SQR

004712

Include file name too long; Modify -I flag.

The combined -I directory name with the #INCLUDE file name exceeds the maximum length permitted for a complete pathname. Check the spelling of both the -I command flag and the #INCLUDE filename.

004713

Cannot open the #INCLUDE file: '`01' (`02): `03

`01 = Include file name `02 = System error code `03 = System error message

004714

Cannot close the #INCLUDE file: '`01' (`02): `03

`01 = Include file name `02 = System error code `03 = System error message

004716

'BEGIN-PROGRAM' command not found in program.

This section is required for all reports. Correct the source code.

004717

Cannot open the report output file: '`01' (`02): `03

`01 = Output file name `02 = System error code `03 = System error message

004719

Cannot logoff the database.

The database server returned an error while trying to log off from the database. SQR aborts the program run.

004720

Cannot open the run-time file: '`01'. (`02): `03

SQR aborts the program run. `01 = Run-Time file name `02 = System error code `03 = System error message

004721

Cannot close the run-time file. (`01): `02

SQR aborts the program run. `01 = System error code `02 = System error message

004722

Error reading the run-time file. (`01): `02

SQR aborts the program run. `01 = System error code `02 = System error message

004723

Run time file must be recreated for this version of SQR.

The run-time file was created by a earlier version of SQR and is incompatible with the current version. Recreate the .sqt (run-time) file.

004724

The -XL option cannot be specified with this run-time file because access to the database is required.

Do not use the -XL option.

004725

Cannot open cursor.

The database server returned an error indicating that a new database cursor or logon could not be completed. See the error message from the database server.

004726

Cannot create procedure for SQL statement.

(Sybase) SQR could not create a stored procedure for the SQL statement. The most likely cause for failure is that the user name you are running the report under does not have the proper privileges. Either grant the user CREATE PROCEDURE privilege or use the -XP command line option to inhibit SQR from creating temporary stored procedures for SQL statements.

004727

Error writing the run-time file. (`01): `02

`01 = System error code `02 = System error message

004729

Cannot find inactive database cursor. Program too large.

(DB2, Oracle) The program has too many concurrent database cursors. Reduce the complexity of the program.

004730

Run-time saved in file: `01

Informational message. `01 = Name of the .sqt file created

004735

Unknown variable type encountered in run-time file: `01

SQR aborts loading the run-time file. `01 = Variable type

004736

Unexpected End-Of-File while processing the run-time file.

SQR aborts loading the run-time file.

004737

Cannot load the run-time file because it was built for the `01database and `02 is built for the `03 database.

SQR aborts loading the run-time file. `01 = Database name from run-time file `02 = SQR image name `03 = Database that SQR is built for

004738

'END-REPORT' not paired with 'BEGIN-REPORT'.

Correct the source code.

004739

'END-PROGRAM' not paired with 'BEGIN-PROGRAM'.

Correct the source code.

004743

#INCLUDE filename must be enclosed in quotation marks.

Correct the syntax.

004744

#INCLUDE command format is: #Include 'filename'.

Correct the syntax.

004747

The SQT file is corrupted and cannot be processed.

SQR aborts loading the run-time file.

004748

The user function '`01' needs to be defined as entry `02 in the user function table. It requires a definition of: Return Type = '`03' Arg Count = `04 Arg Types = "`05"

The SQT file requires that the specified user function be defined. `01 = User function name `02 = Entry in the user function table `03 = Return type `04 = Argument count `05 = Argument types

004749

An attempt was made to move `01 characters into '`02'. The maximum allowed is `03 characters.

An attempt was made to move too much data into an SQR string variable. `01 = Number of characters to be moved `02 = Variable name `03 = Maximum characters allowed

004750

SQR has reached the architectural limit for '`01' (`02).

While attempting to increase an internal table, SQR reached its architectural limit for that table. Processing will stop as SQR cannot continue.

`01 = Internal table classification

`02 = Architectural limit

004802

PRINTER TYPE must be HTML, HPLASERJET, POSTSCRIPT, or LINEPRINTER.

Correct the syntax.

004805

Both BEFORE-BOLD and AFTER-BOLD must be specified.

Correct the syntax.

004807

Unknown DECLARE qualifier.

Correct the syntax.

004901

Date variables (`01) cannot be used in BEGIN-SQL or BEGIN-SELECT paragraphs.

Correct the source code. `01 = Variable name

Table 97. Numbered Messages  005000 to 005999

Error Number

Error Message

Suggestion/Interpretation

005000

Report '`01' heading section size exceeds the page depth.

Reduce the size of the heading or increase the page depth.

005001

Report '`01' footing location must be less than the page depth.

Reduce the size of the footing or increase the page depth.

005002

Check 'BEGIN-HEADING' commands: Discovered 2nd page-initialization while heading in progress.

The BEGIN-HEADING procedure either caused an overflow of the current page or it issued a command that caused a page eject to occur. Check any procedure invoked by the BEGIN-HEADING section to ensure that the commands do not overflow the page or cause a page eject.

005003

Check 'BEGIN-FOOTING' commands; perhaps number of footing lines is too small. Discovered 2nd page-write while footing in progress.

The BEGIN-FOOTING procedure either caused an overflow of the current page or it issued a command that caused a page eject to occur. Check any procedure invoked by the BEGIN-FOOTING section to ensure that the commands do not overflow the page or cause a page eject.

005004

Attempt to execute the `01 command while processing the `02 section.

Change the SQR program logic to prevent the command from executing while the specified section is active. `01 = Command name `02 = Section name

005005

Report '`01' already has been assigned a `02 section.

Correct the source code. `01 = Report name `02 = Duplicated section name

005006

You cannot define more than one default '`01' section.

Correct the source code. `01 = Duplicated section name

005007

Report '`01' has overlapping heading and footing sections.

Correct the source code. `01 = Report name

005008

TOC '`01' already has been assigned a `02 section.

Correct the source code. `01 = Table of Contents name `02 = Duplicated section name

005009

The name can only contain characters [0-9 A-Z _ -].

Correct the source code.

005010

The name cannot be the reserved names 'none' or 'default'.

Correct the source code.

005011

This name has already be used.

Correct the source code.

005012

The specified `01 (`02) does not exist.

Correct the source code.

`01 = Heading or Footing

`02 = Heading/Footing name

005013

FOR-REPORTS and FOR-TOC cannot be specified when NAME= is used.

Correct the source code.

005014

TOC (`01) has already been defined as the default.

Correct the source code.

`01 = Default TOC name

005100

'IF', 'WHILE', 'EVALUATE' commands nested too deeply; maximum is `01.

Reduce the nested commands. `01 = Maximum depth allowed by this version of SQR

005101

'BREAK' found outside 'WHILE' or 'EVALUATE' statement.

The BREAK command is valid only in the context of a WHILE or EVALUATE statement. Correct the source code.

005103

END-WHILE found without matching 'WHILE'.

Correct the source code.

005104

'IF' or 'EVALUATE' command not completed before 'END-WHILE'.

Correct the syntax.

005105

'ELSE' found without matching 'IF'.

ELSE can be used only within the context of an IF command. Correct the source code.

005106

Single 'ELSE' found inside 'WHILE' or 'EVALUATE' statement.

ELSE can be used only within the context of an IF command. Correct the source code.

005107

Only one 'ELSE' allowed per 'IF'.

Rewrite the source code to use nested IF statements.

005108

Found 'END-IF' without matching 'IF'.

Each IF command must have a matching END-IF command. Correct the source code.

005109

'WHILE' or 'EVALUATE' command not completed before 'END-IF'.

You are missing a closing END-WHILE or END-EVALUATE command before END-IF. IF, WHILE, and EVALUATE statements can be nested, but they cannot cross each other's boundaries. Each inner statement must be complete before a closing statement is ended. Correct the source code.

005110

EVALUATE statements nested too deep; maximum is `01.

Reduce the number of nested statements. `01 = Maximum depth supported by this version of SQR

005111

'WHEN' found outside 'EVALUATE' clause.

WHEN may be used only in the context of an EVALUATE clause. Correct the source code.

005112

'IF' or 'WHILE' not completed before 'WHEN' statement.

Correct the syntax.

005114

Incorrect types for comparison. Both must be of the same type (string, numeric or date).

Correct the source line.

005115

'When-other' found outside 'Evaluate' statement.

WHEN can be used only in the context of an EVALUATE statement. Correct the source code.

005116

'IF' or 'WHILE' not ended before 'WHEN-OTHER' command.

Correct the syntax.

005117

Only one 'WHEN-OTHER' allowed per 'EVALUATE'.

Correct the syntax.

005118

Found 'END-EVALUATE' without matching 'EVALUATE'.

Each EVALUATE command must have a matching END-EVALUATE command. Correct the source code.

005119

'IF' or 'WHILE' command not completed before 'END-EVALUATE'.

Correct the syntax.

005120

'WHEN-OTHER' must be after all 'WHEN's.

Correct the syntax.

005121

No 'WHEN's found inside 'EVALUATE' statement.

Correct the syntax.

005122

'IF', 'EVALUATE' and 'WHILE' statements cannot cross sections or paragraphs.

These commands must be contained within a single section or paragraph. Correct the source code.

005123

'CONTINUE' found outside 'WHILE' statement.

The CONTINUE command is valid only in the context of a WHILE statement. Correct the source code.

005200

Did not find '>' after <....

A leading left angled bracket "<" indicates that you are beginning an ASCII value, which must be ended by a right angled bracket ">". Correct the source line.

005201

Bad ascii character in <...>.

Numbers in angled brackets <> must be between 1 and 255. Correct the source line.

005202

Bad ascii number in <...>.

Numbers in angled brackets <> must be between 1 and 255. Correct the source line.

005203

<...> string is too long; maximum is `01 characters.

Reduce the length of the string. If this is not possible, use PRINT-DIRECT in BEGIN-REPORT or END-REPORT . `01 = Maximum number of characters supported by this version of SQR

005300

Did not find '=' after qualifier: `01

Correct the syntax. `01 = Qualifier name

005301

Qualifier '`01' requires a numeric value.

Correct the syntax. `01 = Qualifier name

005302

Incorrect value for qualifier '`01'. Valid values are:

Correct the source line. `01 = Qualifier name

005303

Invalid qualifier '`01'. Valid qualifiers are:

Correct the source line. `01 = Qualifier name

005304

Qualifier '`01' requires a numeric literal, variable, or column.

Correct the source line. `01 = Qualifier name

005305

Qualifier '`01' references a numeric variable that has not been defined.

Correct the source line. `01 = Qualifier name

005306

Qualifier '`01' requires a string literal, variable, or column.

Correct the source line. `01 = Qualifier name

005307

List not terminated.

Correct the syntax.

005308

Missing comma in list.

Correct the syntax.

005309

Required argument '`01' was not specified.

Correct the source line. `01 = Qualifier name

005310

Qualifier '`01' has already been specified.

Correct the source line. `01 = Qualifier name

005311

Qualifier '`01' requires a string literal.

Correct the source line. `01 = Qualifier name

005312

Qualifier '`01' requires a list of values: (val [,val]...).

Correct the source line. `01 = Qualifier name

005313

Qualifier '`01' requires a integer value.

Correct the source line. `01 = Qualifier name

005314

Invalid character in variable name '`01'.

Correct the source line. `01 = Invalid character

005315

Qualifier '`01' references a string variable that has not been defined.

Correct the source line. `01 = Qualifier name

005316

Qualifier '`01' uses an invalid Unit-Of-Measure suffix. Valid suffixes are: dp pt mm cm in

Correct the source line. `01 = Qualifier name

005317

Qualifier '`01' can only reference string literals or variables.

Correct the source line. `01 = Qualifier name

005318

Qualifier '`01' can only reference string or numeric literals.

Correct the source line. `01 = Qualifier name

005319

Qualifier '`01' requires a valid position value.

Correct the source line. `01 = Qualifier name

005320

Qualifier '`01' is not allowed.

Correct the source line. `01 = Qualifier name

005400

Second page write attempted while writing current page. Check BEFORE-PAGE, AFTER-PAGE procedures.

Check any procedure invoked by BEFORE-PAGE or AFTER-PAGE to ensure that the commands do not overflow the page or cause a page eject.

005402

String cannot be placed on page: `01 -- placement specified is out of range. (`02,`03,`04)

Ensure the values are within the page limits. `01 = Text value `02 = Row `03 = Column `04 = Length

005403

Error writing the output file. (`01): `02

`01 = System error code `02 = System error message

005404

Cannot open the Postscript startup file: `01 (`02): `03

`01 = Name of the file `02 = System error code `03 = System error message

005405

SQR trial copy exiting after `01 pages.

`01 = Number of pages.

005406

Exiting after requested number of test pages (`01).

`01 = Number of pages

005408

Program stopped by user request.

Informational message.

005500

Cannot set parse_only option.

(Sybase) The DB-Library routine dbsetopt() returned an error. This should never happen. Contact technical support.

005501

Cannot reset parse_only option.

(Sybase) The DB-Library routine dbclropt() returned an error. This should never happen. Contact technical support.

005502

Cannot drop SQR generated stored procedure: `01.

(Sybase) See the database server error message that was also output. This should never happen. Contact technical support. `01 = Stored procedure name

005503

Cannot use `01 datatype as bind variable.

(Sybase) Use another database column. `01 = The database datatype.

005504

Unknown datatype for bind variable: `01 Cannot create stored procedure.

(Sybase) Please contact technical support. `01 = Unknown database datatype

005505

SQL too large to create stored procedure.

(Sybase) The size of the SQL text needed to create the stored procedure is too large for SQR to handle. Add -XP to BEGIN-SQL or BEGIN-SELECT.

005506

SQR's EXECUTE command not available for this version of Sybase.

(Sybase) Some early versions of Sybase SQL Server or Microsoft SQL Server do not support Remote Procedure Calls (RPCs). Update your database server.

005507

Could not add param to remote procedure call.

(Sybase) A DB-Library routine returned an unexpected error. See the error message from the database.

005508

The number of EXECUTE...INTO &columns does not match the procedure.

(Sybase) Check the definition for the stored procedure you are referencing.

005509

Incorrect number of INTO &columns defined in EXECUTE.

(Sybase) Check the definition for the stored procedure you are referencing.

005510

Error converting OUTPUT Sybase type for EXECUTE.

(Sybase) The DB-Library routine dbconvert() failed to convert the data from the stored procedure. Contact technical support.

005511

Number of OUTPUT parameters from EXECUTE is incorrect.

(Sybase) Check the definition for the stored procedure you are referencing.

005512

Missing default database name for USE.

(Sybase) Correct the syntax.

005512

Missing default database name for USE.

(ODBC) Could not connect to the specified datasource.

005513

You may only specify 'USE db' once, before any SQL statements are executed.

(Sybase) Only one USE command is allowed in a report. Place the SETUP section at the beginning of the SQR report.

005515

Undefined variable referenced in -DB flag: `01

(ODBC) Check for a misspelling. `01 = Variable name

005523

Database commit failed.

The database command to perform a commit returned an error. Try running the SQR program again. The error could be related to a network or server problem. If the error persists, contact your system administrator.

005524

Cannot close database cursor.

The database command to close the database cursor returned an error. Try running the SQR program again. The error could be related to a network or server problem. If the error persists, contact your system administrator.

005528

DB2 SQL `01 error `02 in cursor `03:

(DB2) `01 = Routine name `02 = Error code `03 = SQR cursor number

 

INFORMIX SQL `01 error `02 (ISAM: `03) in cursor `04: `05

(Informix) `01 = Routine name `02 = Error code `03 = ISAM code `04 = SQR cursor number `05 = Error message from database

 

ODBC SQL `01 error `02 in cursor `03: `04

(ODBC) `01 = Routine name `02 = Error code `03 = SQR cursor number `04 = Error message from database

 

ODBC SQL `01 error `02 in cursor `03: `04

(DDO)

`01 = Routine name

`02 = Error code

`03 = SQR cursor number

`04 = Error message from database

 

ORACLE `01 error `02 in cursor `03: `04

(Oracle) `01 = Routine name `02 = Error code `03 = SQR cursor number `04 = Error message from database

 

Sybase `01 error in cursor `02: `03

(Sybase) `01 = Routine name `02 = SQR cursor number `03 = Error message from database

 

Teradata SQL `01 error `02 in cursor `03:

(Teradata)

`01 = Routine name

`02 = Error code

`03 = SQR cursor number

005532

System 10 files are missing.

(Sybase) Contact your system administrator.

005533

Not a System 10 SQL Server.

(Sybase) The CT-Library version of SQR can only connect to a System 10 server. Use the DB-Library version of SQR to connect to a pre-System 10 server.

005534

SQL too long for PREPARE/DECLARE; maximum `01 characters.

(Teradata) The SQL statement is too large.

`01 = Maximum number of characters supported by this version of SQR

005536

Unknown error message number: `01.

(DB2) `01 = Error message number

005537

Empty error message returned from system for error number: `01.

(DB2) `01 = Error message number

005538

Invalid SELECT statement; COMPUTE clauses are not supported.

(Sybase) The select statement contains a COMPUTE clause that is not supported.

005539

Could not connect to datasource specified in -db variable: '`01'.

(ODBC) Could not connect to the specified datasource.

005540

Not connected to a database, database access is not allowed.

The SQR program is no longer connected to a database. Commands that access the database can no longer be used. This situation can occur if the CONNECT fails and the ON-ERROR option was used.

005543

Specify the Oracle DLL name in SQR.INI in [Environment:Oracle] section for ORACLE_DLL entry, such as ORACLE_DLL=orant71.dll

(Oracle) SQR was unable to load the Oracle DLL. By default, SQR looks first for “ociw32.dll” or the DLL specified by the ORACLE_DLL entry in the [Environment:Oracle] section of SQR.INI. If that DLL could not be loaded, then SQR attempts to load 'orant71.dll'.

005600

GETWRD: Word too long; maximum is `01.

Reduce the length of the "word". `01 = Maximum size of a "word" supported by this version of SQR

005700

Cannot call SQR recursively.

SQR cannot be called recursively. This error can only occur if a User Function from either UFUNC.C or UCALL.C calls the sqr() routine. Do not call sqr() from a UFUNC.C or UCALL.C routine.

005701

Too many SQR command line arguments; maximum is `01

To pass more than this number of arguments, use a @file argument file containing one argument per line. `01 = Maximum number supported by this version of SQR.

005702

Log file name specified is too long.

Reduce the length of the log file name.

005703

Error opening the SQR log file: '`01' (`02): `03

`01 = Name of the file `02 = System error code `03 = System error message

005704

Missing program name.

The name of the program file was not found on the command line. The program name must be the first parameter on the command line.

005705

Program file name specified is too long.

Reduce the length of the program file name.

005707

Error opening the -E error file: '`01' (`02): `03

`01 = Name of the file `02 = System error code `03 = System error message

005708

Cannot find `01 in SQRDIR, PATH or \SQR.

The specified file cannot be located in any of the directories pointed to by the mentioned environment variables or default directories. Make sure the "file" is present in one of the locations searched. `01 = File name

005709

`01 environment variable is not defined.

As of version 2.5, the environment variable SQRDIR must be defined. `01 = Name of the environment variable

005710

`01 path too long.

The length of the directory path plus the length of the file name to be opened is too long for SQR to handle. Reduce the length of the directory path. `01 = Environment variable name

005711

Bad number in -T test flag.

The number specified must be > zero. Correct the value.

005712

-G option requires arguments.

(VAX) The command line option is ill-formed. Correct the syntax.

005713

Too many arguments to -G option; maximum is `01.

(VAX) The command line option is ill-formed. Correct the syntax. `01 = Maximum number of arguments supported by this version of SQR

005714

-G attribute too long; maximum is `01.

(VAX) The command line option is ill-formed. Correct the syntax. `01 = Maximum number of each attribute supported by this version of SQR

005716

Unknown flag on command line: `01

Correct the syntax. `01 = Unknown command line flag

005717

Cannot open channel to TT; status = `01

(VAX) Should never occur during normal operations. Record the steps leading up to the error and contact your system administrator. `01 = System status

005718

Cannot read from TT; status = `01

(VAX) Should never occur during normal operations. Record the steps leading up to the error and contact your system administrator. `01 = System status

005719

Cannot close channel to TT; status = `01

(VAX) Should never occur during normal operations. Record the steps leading up to the error and contact your system administrator. `01 = System status

005720

Error opening tty. (`01): `02

(DG, UNIX) Should never occur during normal operations. Record the steps leading up to the error and contact your system administrator. `01 = System error code `02 = System error message

005721

Error with 'ioctl()'. (`01): `02

(DG, UNIX) Should never occur during normal operations. Record the steps leading up to the error and contact your system administrator. `01 = System error code `02 = System error message

005722

Error reading tty. (`01): `02

(DG, UNIX) Should never occur during normal operations. Record the steps leading up to the error and contact your system administrator. `01 = System error code `02 = System error message

005723

Error closing tty. (`01): `02

(DG, UNIX) Should never occur during normal operations. Record the steps leading up to the error and contact your system administrator. `01 = System error code `02 = System error message

005724

Bad number in -B flag.

(Oracle, Sybase) The number specified must be > zero. Correct the value.

005734

No program name given.

The report name must be the first command line argument.

005737

Unknown printer type specified with -PRINTER: switch.

The printer type can be EH, HT, LP, HP, PS, or WP. WP is valid only with PC/Windows.

005738

Database name needs to be included with -DB switch.

(ODBC) Could not connect to the specified datasource.

005738

Database name needs to be included with -DB switch.

(Sybase) Supply the database name.

005739

Too many -F switches; maximum is `01.

Reduce the number of -F switches. `01 = Maximum number allowed

005742

Attempt to invoke viewer (using WinExec) failed; error code = `01.

(Windows) `01 = System error code

005743

Unknown numeric type specified with -DNT: switch.

Correct the command line.

005744

-DNT:Decimal precision (`01) is out of range (`02 - `03).

Correct the command line. `01 = Specified precision `02 = Minimum allowed `03 = Maximum allowed

005745

The specified default numeric type '`01 = `02' is invalid.

Correct the SQR.INI file entry. `01 = Entry `02 = Value

005746

The decimal precision '`01 = `02' is out of range (`03 - `04).

Correct the SQR.INI file entry. `01 = Entry `02 = Value `03 = Minimum allowed `04 = Maximum allowed

005747

The following error(s) occurred while processing the [`01] section from SQR.INI.

See the error message(s) that follow. `01 = Name of the section

005750

The -Burst switch is not properly formatted.

The “Burst” command line flag is not properly formatted.

005751

The -Burst switch cannot be used with the -NOLIS switch.

The “Burst” command line flag cannot be specified when the -NOLIS command line flag is also specified.

005752

The -Burst switch requires either the -Printer:HT or -Printer:EH switch to be specified.

The “Burst” command line flag is applicable only when HTML code is produced. You must specify either the -PRINTER:HT or -PRINTER:EH switch.

005754

The -Burst switch caused no output to be generated.

The “Burst” command line flag was specified with a set of page ranges that prevented any output to be created. Change the page ranges.

005755

The -Printer:HT switch does not support UTF-8 encoded data. Use the ‑Printer:EH switch instead.

Spf_ht.c can't handle UTF-8

005756

The -EH_FullHTML switch support the following values: 30, 32, and 40.

The 'EH_FullHTML' command line flag is not properly formatted.

005757

The -EH_Browser switch can be specified with one of the following values: Basic, Netscape, IE, or ALL.

The 'EH_Browser' command line flag is not properly formatted.

005758

The -EH_Language switch can be specified with one of the following values: English, French, German, Portuguese, Spanish, SChinese, TChinese, or Japanese.

The 'EH_Language' command line flag is not properly formatted.

005781

An ASCII-based encoding (ASCII, CP1252, etc) must be specified in order to generate barcodes for HPLaserJet output.

An ASCII-based encoding must be specified for the ENCODING-REPORT-OUTPUT setting in the INI file when generating barcodes for HPLaserJet (-printer:hp)

005900

Bad number in -`01

(Windows) Specify a valid number. `01 = Command line option

005901

Bad filename in -`01

(Windows) Specify a valid file name. `01 = Command line option

005902

Bad directory in -`01

(Windows) Specify a valid directory path. `01 = Command line option

005903

Cannot access the @ parameter file (`01): `02

(Windows) Depends on the system error message. `01 = System error code `02 = System error message

005904

The argument list is too long; maximum is `01.

(Windows) To pass more than this number of arguments, use a @file argument file containing one argument per line. `01 = Maximum number supported by this version of SQR.

005905

Cannot open the report file (`01): `02

(Windows) Depends on the system error message. `01 = System error code `02 = System error message

Table 98. Numbered Messages  006000 to 006999

Error Number

Error Message

Suggestion/Interpretation

006000

Error writing the printer file. (`01): `02

Can occur during normal operations due to the system environment (for example, file locking, permissions). Record the steps leading up to the error and contact your system administrator. `01 = System error code `02 = System error message

006001

Error reading the printer file. (`01): `02

Can occur during normal operations due to the system environment (for example, file locking, permissions). Record the steps leading up to the error and contact your system administrator. `01 = System error code `02 = System error message

006002

Cannot open the printer file: `01 (`02): `03

Can occur during normal operations due to the system environment (for example, file locking, permissions). Record the steps leading up to the error and contact your system administrator. `01 = Name of the file `02 = System error code `03 = System error message

006003

Unexpected End-Of-File while processing the printer file.

Possibly the file got corrupted. Try to recreate the .spf file. If the error persists, contact technical support.

006004

Encountered unknown SPF code (`01) while reading the printer file.

Possibly the file got corrupted. Try to recreate the .spf file. If the error persists, contact technical support. `01 = Unknown SPF code

006100

Duplicate chart (`01).

Each chart must be given a unique name. `01 = Chart name

006101

Unknown chart (`01).

Chart could not be found. `01 = Chart name

006104

Too many pie segments (`01). Max is `02.

Correct the source code. `01 = Number of segments `02 = Maximum allowed segments

006105

Chart module is not initialized.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006106

XY charts may have only numeric columns.

Correct the syntax.

006107

The 3rd column in the data array must be a character column to specify USE-3RD-DATA-COLUMN.

Correct the syntax.

006120

INTERNAL: Bad chart index from stack (`01).

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support. `01 = Chart index

006122

INTERNAL: Unsupported Grafsman chart type (`01).

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support. `01 = Chart type

006123

INTERNAL: Unsupported pie-explode setting (`01).

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support. `01 = Setting value

006124

INTERNAL: Unsupported tick-mark placement (`01).

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support. `01 = Placement value

006125

Grafsman interface message (`01) not supported.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support. `01 = Message code

006126

Unrecognized return code (`01) from Grafsman command message (`02).

Should never occur during normal operations. Record the steps leading up to the error and contact technical support. `01 = Return code `02 = Message code

006127

Cannot fit Chart/Image into the current page. Position: (`01, `02) Size: (`03, `04)

Correct the source code. Production Reporting aborts the program run. `01 = Row `02 = Column `03 = Width `04 = Depth

006140

Duplicate image (`01).

Images must be given unique names. `01 = Image name

006141

Unknown image (`01).

Image name could not be found. `01 = Image name

006142

Cannot open image file (`01). (`02): `03

`01 = Name of the file `02 = System error code `03 = System error message

006143

Unknown or missing image type (`01).

Enter a valid image type.

`01 = Image type

006144

Unknown or missing printer type (`01).

Enter a valid Printer type.

`01 = Printer type

006145

Duplicate FOR-PRINTER entries for printer (`01).

Only a single FOR-PRINTER can be specified for a printer type .

`01 = Printer type

006146

The image type (`01) is not supported by printer type (`02).

The image, based on its type is invalid for the printer specified. For example, an EPS image is only valid for Postscript printer.

`01 = The image type

`02 = The printer type

006147

Invalid number of items in FOR-PRINTER list.

Too few or too many items in the FOR-PRINTER list. Correct the syntax.

006150

INTERNAL: Bad image index from stack (`01).

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support. `01 = Image name

006200

This report has already been defined.

Each report must be given a unique name.

006201

This layout has already been defined.

Each layout must be given a unique name.

006202

This printer has already been defined.

Each printer must be given a unique name.

006203

The values for '`01' must be > 0.

Correct the syntax. `01 = Qualifier name

006204

Qualifiers '`01' and '`02' are mutually exclusive.

Correct the syntax. `01 = Qualifier name `02 = Qualifier name

006205

Qualifier '`01' is not applicable with a 'default' printer.

Correct the syntax. `01 = Qualifier name

006206

The list must contain report names or ALL.

Correct the syntax.

006207

'ALL' must be specified by itself.

Correct the syntax.

006208

No report name was specified.

Correct the syntax.

006209

No layout name was specified.

Correct the syntax.

006210

No printer name was specified.

Correct the syntax.

006211

The name cannot be 'ALL'.

Correct the syntax.

006212

The name can only contain characters [0-9 A-Z _ -].

Correct the syntax.

006213

Report '`01' is referenced by multiple '`02' printers.

Correct the syntax. `01 = Report name `02 = Printer type

006214

Qualifier '`01' is not allowed with a '`02' printer.

Correct the syntax. `01 = Qualifier name `02 = Printer type

006215

The value for '`01' must be ‘`02 0.

Correct the syntax. `01 = Qualifier name `02 = Relation to zero (<,<=,=,>=,>)

006216

Report '`01' does not exist.

Correct the syntax. `01 = Report name

006217

The report name can be a string literal, variable, or column.

Correct the syntax. `01 = Report name

006218

Referenced layouts not defined:

A list of undefined layouts follows this message.

006219

Referenced reports not defined:

A list of undefined reports follows this message.

006220

Referenced printers not defined:

A list of undefined printers follows this message.

006221

The following SQR commands (listed below) cannot be used when any of the following NEW SQR commands are also used in the same report:

Correct the syntax.

006224

No printer type was specified.

Correct the syntax.

006225

Incorrect value for printer type. Valid values are:

Correct the syntax. A list of valid printer types follows this message.

006226

Attempt to execute the `01 command while processing the `02 procedure.

SQR aborts the program run. `01 = SQR command `02 = Procedure name

006227

Incorrect value for 'paper-size'. Specify the actual dimensions or one of the following names:

Correct the syntax. A list of valid predefined paper-size names follows this message.

006228

Referenced TOC (Table Of Contents) not defined:

A list of undefined Table of Contents follows this message.

006229

This TOC (Table Of Contents) has already been defined.

Each Table of Contents must be given a unique name.

006230

The list must contain TOC (Table of Contents) names or ALL.

Correct the syntax.

006231

The TOC (Table Of Contents) entry cannot be positioned given the LEVEL (`01) and INDENTATION (`02) values.

The Table of Contents entry will not fit given the specified level and current indentation values. `01 = Specified LEVEL= value `02 = Current INDENTATION= value

006232

`01 command not allowed while generating the Table of Contents.

The specified command cannot be used while the Table of Contents is being generated. `01 = SQR command

006233

The TOC (Table of Contents) entry "A" cannot be processed because the existing entry "B" is positioned below it. A: Line = `01, Level = `02, Text = '`03' B: Line = `04, Level = `05, Text = '`06'

Correct the program logic to eliminate the conflict between the two TOC (Table of Contents) entries. `01 = A: Line number `02 = A: Level value `03 = A: Text value `04 = B: Line number `05 = B: Level value `06 = B: Text value

006303

Parameter (`01) is required, but has not been specified.

Correct the syntax. `01 = Parameter name

006304

Parameter (`01) already specified.

Correct the syntax. `01 = Parameter name

006308

Missing part of specification for parameter (`01).

Correct the syntax. `01 = Parameter name

006309

Parameter (`01) requires literal.

Correct the syntax. `01 = Parameter name

006352

INTERNAL: Unsupported option/request (`01) in (`02).

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact technical support. `01 = Option/request code `02 = Function name

006400

Unsupported background color.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006401

Unsupported border color.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006402

Border width out of range.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006403

X position out of range.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006404

Y position out of range.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006405

X size out of range.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006406

Y size out of range.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006407

Unsupported font.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006408

Unsupported font style.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006409

Unsupported font color.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006410

Unsupported horizontal text justification value.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006411

Unsupported vertical text justification value.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006412

Unsupported font path.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006413

Unsupported font rotation.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006414

Font size out of range.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006415

Text line id# out of range.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006416

Unsupported chart type.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006417

Unsupported chart sub-type.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006418

Unsupported chart orientation (not H or V).

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006419

Unsupported perspective (not 2D or 3D).

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006420

Unsupported axis (not X or Y).

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006421

Unsupported axis label data type.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006422

Dataset id# out of range.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006423

Unsupported dataset type.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006424

Unsupported dataset color.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006425

Unsupported dataset line style.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006426

Unsupported dataset fill pattern.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006427

Unsupported dataset marker.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006428

Chart type does not support Y-axis datasets.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006429

Pie-chart segment id# is out of range.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006430

Unsupported pie-segment color.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006431

Unsupported pie-segment border color.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006432

Unsupported pie-segment pattern.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006433

Unsupported pie-segment explode setting.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006434

Command only valid for charts of type 'pie'.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006435

Pie-chart radius out of range.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006436

Pie-chart starting angle out of range.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006437

Unsupported pie-chart fill direction. Must be clockwise or counter-clockwise.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006438

Unsupported pie-segment label position.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006439

Unsupported pie-segment quantity display position.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006440

Unsupported pie-segment per-cent display position.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006441

Unsupported legend style.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006442

Unsupported legend horizontal position.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006443

Unsupported legend vertical position.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006444

Text charts do not support legend.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006445

Number of datasets specified does not match data.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006446

Unsupported axis label position.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006447

Unsupported axis type (not LINEAR or LOG).

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006448

Pie and text charts do not support axis control.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006449

Unsupported axis min scaling.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006450

Unsupported axis max scaling.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006451

Unsupported axis max scaling.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006452

Beginning of tickmarks is after end.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006453

Unsupported tickmark type.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006454

Unsupported grid type.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006455

Unsupported grid color.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006456

Grid line width out of range.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006457

Unable to open grafcap file.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006458

Unsupported grafcap device.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006459

Error in grafcap entry specification.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006460

Unable to open chart output destination.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006461

Internal error during ggDraw.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006462

Improper parameters passed to gscale.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006463

The shared library specified in the grafcap file could not be found.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006464

A function called from the shared library specified in the grafcap file could not be found.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006500

The bar code could not be positioned on the page. Row: `01, Column: `02, Height: `03

Correct the source code. `01 = Row `02 = Column `03 = Height

006501

Unknown BCL error (`01) encountered.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support. `01 = BCL error code

006502

Invalid bar code type (`01): Valid values are from 1 to 15.

Correct the source code. `01 = Bar code type.

006503

The length of the bar code text ‘01' must be between 1 and 30 characters.

Correct the source code. `01 = Bar code text

006504

The length of the caption text '01' must be between 1 and 30 characters.

Correct the source code. `01 = Caption text

006505

Invalid printer type (`01): Valid values are from 0 to 13.

Correct the source code. `01 = Printer type

006506

Invalid offset: Valid values are from 0 to 250.

Correct the source code.

006507

Invalid height (`01): Valid values are from 0.1 to 2.0 inches.

Correct the source code. `01 = Height

006508

Invalid checksum: Valid values are from 0 to 2.

Correct the source code.

006509

Invalid pass: Valid values are from 1 to 6.

Correct the source code.

006510

The bar code text '01' is not valid for the type of bar code (`02) selected.

Correct the source code. `01 = Bar code text `02 = Bar code type

006511

Internal error: Could not generate the bar code.

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006512

Internal error: Bar code buffer required too large (>32K).

Should never occur during normal operations. Record the steps leading up to the error and contact technical support.

006601

Cannot allocate the device context for the default printer.

(Windows) Can occur due to lack of system resources. Record the steps leading up to the error and contact your system administrator.

006602

Failed to start printing the document.

(Windows)Can occur due to lack of system resources or a problem with the printer. Record the steps leading up to the error and contact your system administrator.

006603

New-page (start) failed on page `01.

(Windows) Can occur due to lack of system resources or a problem with the printer. Record the steps leading up to the error and contact your system administrator. `01 = Page number

006604

New-page (end) failed on page `01.

(Windows) Can occur due to lack of system resources or a problem with the printer. Record the steps leading up to the error and contact your system administrator. `01 = Page number

006605

End document failed.

(Windows) Can occur due to lack of system resources or a problem with the printer. Record the steps leading up to the error and contact your system administrator.

006606

Error reading font information from the [Fonts] section in SQR.INI. Using the default font.

(Windows) Correct the [Fonts] section in SQR.INI.

006607

Failed to create a brush for shading.

(Windows) Can occur due to lack of system resources. Record the steps leading up to the error and contact your system administrator.

006608

Failed to select font `01.

(Windows) Can occur due to lack of system resources. Record the steps leading up to the error and contact your system administrator. `01 = Font name

006609

Failed to modify font `01.

(Windows) Can occur due to lack of system resources. Record the steps leading up to the error and contact your system administrator. `01 = Font name

006610

Failed to create a pen that was required to draw a box.

(Windows) Can occur due to lack of system resources. Record the steps leading up to the error and contact your system administrator.

006612

Failed to create a pen that was required to draw a vertical line.

(Windows) Can occur due to lack of system resources. Record the steps leading up to the error and contact your system administrator.

006613

Failed to open the image bitmap file (`01). (`02): `03

(Windows) Can occur during normal operations due to the system environment (file locking, permissions). Record the steps leading up to the error and contact your system administrator. `01 = Name of the file `02 = System error code `03 = System error message

006614

The file (`01) does not contain a valid bitmap.

(Windows) Specify a valid bitmap file. `01 = Name of the file

006615

Failed to create the palette for image (`01).

(Windows) Can occur due to lack of system resources or an invalid bitmap. Record the steps leading up to the error and contact your system administrator. `01 = Name of the file

006616

Failed to load RLE into memory for image (`01).

(Windows) Can occur due to lack of system resources. Record the steps leading up to the error and contact your system administrator. `01 = Name of the file

006617

Failed to convert DIB to DDB for image (`01).

(Windows) Can occur due to lack of system resources. Record the steps leading up to the error and contact your system administrator. `01 = Name of the file

006618

Failed to draw the bitmap image (`01).

(Windows) Can occur due to lack of system resources. Record the steps leading up to the error and contact your system administrator. `01 = Name of the file

006619

Cannot access the default printer's driver.

(Windows) Can occur due to lack of system resources or a problem with the printer. Record the steps leading up to the error and contact your system administrator.

006620

Cannot select the charting clip area onto the printers DC.

(Windows) Can occur due to lack of system resources or a problem with the printer. Record the steps leading up to the error and contact your system administrator.

006621

Cannot select create a metafile required for business graphics.

(Windows) Can occur due to lack of system resources. Record the steps leading up to the error and contact your system administrator.

006622

Cannot create a region required for business graphics.

(Windows) Can occur due to lack of system resources. Record the steps leading up to the error and contact your system administrator.

006623

Cannot create a DC required for business graphics.

(Windows) Can occur due to lack of system resources. Record the steps leading up to the error and contact your system administrator.

006624

Cannot create a bitmap required for business graphics.

(Windows) Can occur due to lack of system resources. Record the steps leading up to the error and contact your system administrator.

006625

Business graphics failed while setting up the device (ggWinDevice).

(Windows) Can occur due to lack of system resources. Record the steps leading up to the error and contact your system administrator.

006626

Cannot draw business graphics.

(Windows) Can occur due to lack of system resources or it can be due to a damaged LIBSTI.INI file. The LIBSTI.INI file resides in the Windows main directory. Make sure that the GPATH= and IPT= entries point to a valid SQR bin directory. Record the steps leading up to the error and contact your system administrator.

006700

SQRDIR is not defined.

(Windows) The variable SQRDIR must be defined in SQR.INI.

006701

Could not allocate memory while attempting to register the .spf filename extension.

(Windows) Can occur due to lack of system resources. Record the steps leading up to the error and contact your system administrator.

006704

Cannot open or read file (`01) (`02): `03

(Windows) Can occur during normal operations due to the system environment (e.g. file locking, permissions, etc.). Record the steps leading up to the error and contact your system administrator. `01 = Name of the file `02 = System error code `03 = System error message

006705

File (`01) is not in SPF packet format.

(Windows) The file was not produced by SQR or it has been corrupted. `01 = Name of the file

006706

Failed to identify the start of the report (`01).

(Windows) The file was not produced by SQR or it has been corrupted. `01 = Name of the file

006707

An invalid seek was made for page `01.

(Windows) Internal error which should not occur under normal operations. Contact technical support. `01 = Page number

006708

Too many errors were encountered while processing the file. Processing has been stopped.

(Windows) Can occur due to lack of system resources. Record the steps leading up to the error and contact your system administrator.

006709

Failed to open the image bitmap file (`01). (`02): `03 This message is displayed only once per SPF file.

(Windows) Can occur during normal operations due to the system environment (e.g. file locking, permissions, etc.). Record the steps leading up to the error and contact your system administrator. `01 = Name of the file `02 = System error code `03 = System error message

006800

`01: Detected internal program error.

Internal error that should never occur during normal operation. Record the steps leading up to the error and contact technical support. `01 = Name of the routine

006801

`01: Null Operand Passed as input.

Internal error that should never occur during normal operation. Record the steps leading up to the error and contact technical support. `01 = Name of the routine

006802

`01: Decimal Exponent Under/Overflow.

Exponent Under/Overflow: Exponent of decimal number has exceeded the valid boundaries established for the decimal type. Check the documentation for the current upper and lower bounds of a decimal object. `01 = Name of the routine

006803

`01: Decimal to Integer Conversion Under/Overflow.

Integer Under/Overflow: Cannot convert input decimal object into a valid integer number. Decimal object exceeds the established integer boundaries for this machine architecture. Check the magnitude and sign of the decimal object to ensure that it falls within the upper and lower bounds of an integer number. `01 = Name of the routine

006805

`01: Decimal Precision Under/Overflow.

Decimal Precision Under/Overflow: Attempt made to initialize decimal object with an invalid precision. Check the input precision value against the documented upper and lower boundaries for a decimal object. `01 = Name of the routine

006806

`01: String to Decimal Object Conversion Error.

String To Decimal Conversion Error: Length of input string is greater than precision of underlying decimal object. Either increase the precision of the decimal object or reduce the size of the input mantissa to match the decimal object precision. `01 = Name of the routine

006807

`01: Truncation/Rounding Error - Outside Valid Range for Decimal Object.

Truncation/Rounding Error: Input truncation or round value is outside the valid range for this decimal object. Please ensure that the truncation/round value is greater than or equal to zero and less than the precision of the underlying decimal object. `01 = Name of the routine

006808

`01: Decimal Error: Cannot Divide by Zero.

Decimal Math Divide by Zero Error: Attempt made to divide a decimal object by zero. Please check divisor to ensure that it does not equal zero before attempting to divide. `01 = Name of the routine

006900

There is no default printer set up on your system. Use the Control Panel "Printers" applet to define it.

(Windows) SQR Print requires that a default printer be defined. Use the "Printers" applet in the Control Panel to define one.

Table 99. Numbered Messages  007000 to 007999

Error Number

Error Message

Suggestion/Interpretation

007000

The locale '`01' is not defined in SQR.INI.

Check for a misspelled locale name and/or the SQR.INI file. `01 = Locale name

007001

At least one qualifier must be specified.

Correct the source code.

007002

The value for '01' must be a list of 02 string literals, variables or columns.

Correct the source code. `01 = Qualifier `02 = Number of entities in list

007003

The values for '01' and '02' cannot be the same.

Correct the source code. `01 = Qualifier `02 = Qualifier

007004

The value for '01' (`02) must be a single character which is not in the list: "03".

Correct the source code. `01 = Qualifier `02 = Value `03 = List of invalid characters

007005

The value for '`01' (`02) is invalid. Valid values are:

Correct the source code. `01 = Qualifier `02 = Value

007006

The last character of the '`01' value (`02) cannot be a digit or the minus sign or the same as either of the separators.

Correct the source code. `01 = Qualifier `02 = Invalid character

007007

The first character of the '`01' value (`02) cannot be a digit or the minus sign or the same as either of the separators.

Correct the source code. `01 = Qualifier `02 = Invalid character

007008

The following errors occurred while processing the (`01) locale from SQR.INI.

This message precedes error messages encountered while processing the SQR.INI file. `01 = Locale name

007009

The value for '`01' cannot be 'DEFAULT' or 'SYSTEM'.

Correct the syntax. `01 = Qualifier

007010

The value for '`01' (`02) is not properly formatted: Did not find the '>' for the '<nnn>' construct.

Correct the syntax. `01 = Qualifier `02 = Value

007011

The value for '`01' (`02) is not properly formatted: The value of an '<nnn>' construct must be from 1 to 255.

Correct the syntax. `01 = Qualifier `02 = Value

007012

The default locale (`01) specified in the [`02] section of SQR.INI has not been defined.

Correct the syntax. `01 = Locale name `02 = Section name

007013

The value for '`01' (`02) must be a list of `03 quoted string literals.

Correct the syntax. `01 = Qualifier `02 = Value `03 = Number of entities in list

007014

The entry (`01 = `02) is not valid.

Correct the SQR.INI entry. `01 = Qualifier from the SQR.INI file `02 = Qualifier's value

007100

The use of an edit mask or the keywords NUMBER, MONEY, or DATE is not legal when storing numeric variables.

Correct the source code.

007101

The last keyword is not '`01'.

Correct the source code. `01 = Keyword

007102

Incompatible source and destination variable types.

Correct the source code.

007103

The keyword (`01) is not compatible with the variable (`02).

Correct the source code. `01 = Keyword `02 = Variable name

007104

The use of an edit mask or the keyword DATE is not legal if both variables are date variables.

Correct the source code.

007200

The specified precision (`01) is out of range (`02 - `03).

Correct the source code. `01 = Specified precision `02 = Minimum precision `03 = Maximum precision

007201

The precision is specified by a value from `01 to `02 surrounded by parentheses.

Correct the source code. `01 = Minimum precision `02 = Maximum precision

007202

Variable (`01) is not a decimal variable and cannot have a precision associated with it.

Correct the source code. `01 = Variable name

007203

A string variable name is required here.

Correct the source code.

007204

A numeric variable name is required here.

Correct the source code.

007205

The variable (`01) has already been defined as '`02' and may not be redefined.

Correct the source code. `01 = Variable name `02 = Variable type

007206

The variable type has not been specified.

Correct the source code.

007207

This command is only allowed within local procedures.

Correct the source code.

007208

This command must be before all other commands in the procedure.

Correct the source code.

007209

Only string ($) and numeric (#) variables may be declared.

Correct the source code.

007210

Invalid variable name specified.

Correct the source code.

007211

You cannot declare a global variable from within a procedure.

Correct the source code.

007400

The specified character is invalid in the current character set.

Correct the program logic.

007401

'`01' is not a valid value for the ENCODING environment variable.

The specified encoding scheme is not known by SQR. `01 = ENCODING environment variable setting.

007403

The Double-Byte SQR command '`01' is not supported in this version of SQR.

The SQT file contains a reference to an SQR command, which is not supported by this version of SQR. `01 = SQR command name

007405

The barcode text '`01' cannot contain double-byte characters.

Correct the source code. `01 = Bar code text

007501

Using `01 edit mask from (`02) against (`03)

A date edit mask element was detected which could cause date data to be incorrectly interpreted. This warning message can be turned off by setting the “OutputTwoDigitYearWarningMsg” entry to the [Default-Settings] section of SQR.INI to FALSE. `01 = Edit mask element `02 = Edit mask being used `03 = Value being applied to the edit mask

007601

Cannot access the Java file (`01) (`02): `03

SQR cannot access the required file. `01 = Name of the file `02 = System error code `03 = System error message

007602

-EH_Scale: value (`01) is out of range (`02 - `03).

Correct the command line. `01 = Specified scale `02 = Minimum allowed `03 = Maximum allowed

007603

-Printer:EH functionality is not available on this platform.

Enhanced HTML functionality is not available on this platform.

007604

-Printer:PD functionality is not available on this platform.

PDF functionality is not available on this platform.

007605

Cannot support Unicode internally. Please reset the UseUnicodeInternal setting in SQR.INI to FALSE.

Cannot support Unicode internally. Reset the UseUnicodeInternal setting in SQR.INI to FALSE.

007702

Invalid entry for keyword, '`01=`02'

Correct the source code.

007703

May only specify either PROCEDURE=, or COMMAND=, or GETDATA=, exclusive.

Correct the source code.

007704

Must specify a SCHEMA.

Correct the source code.

007705

Must specify either a PROCEDURE, COMMAND, or GETDATA.

Correct the source code.

007706

CONNECTION '`01' not found. No such connection.

Correct the source code.

007707

The returned set of Procedure parameters (INOUT and OUT) (length = `01 items) did not include one or more of the specified items.

Stored procedure error.

007708

Encountered a parameter of type '`01'. Valid types are either IN, OUT, or INOUT. If no type is entered, the type defaults to IN.

Stored procedure error.

007709

The datasource failed to provide the expected return status value. Verify the query metadata.

Datasource error.

007711

Failed to login to the requested datasource (Connection='`01', username='`02'). DETAILS: `03

Logon failed.

007712

The requested rowset (`01) was not available. Verify the query metadata.

Not enough rowsets.

007713

Missing or invalid Registry.properties file. Verify that the CLASSPATH includes SQRDIR, that SQRDIR contains the folder with the Registry.properties file, and that the Registry.properties file is valid.

Incorrect environment setup.

007714

The datasource ('`01') does not support the requested capability ('`02'). Check the capabilities list for the datasource, located in the Properties folder.

Invalid query for datasource.

007715

Failed to start the Java Virtual Machine (JVM). Possible causes are: missing or invalid jdk files, incorrect CLASSPATH, or insufficient resources.

Incorrect environment setup.

007717

The query failed. DETAILS: `01

Query failed.

007718

Failure setting property '`01'. DETAILS: `02

Property-set failed.

007721

Parameter `01 (`02) was passed to the PROCEDURE as data type `03; expected (`04) type `05. Verify the query metadata.

A failure occurred during row fetch.

007722

Invalid query parameter: Reason: `01

Bad procedure parameter.

007723

Too many parameters (= `01) were supplied to the query. Verify the query metadata.

Bad procedure parameter.

007724

Parameter `01 (`02) was passed to the PROCEDURE as type `03; expected type `04. Verify the query metadata.

Bad procedure parameter.

007725

Parameter `01 ('`02', JDO-type `03), specified 'NULL', is a required-parameter. Specify a value or variable name.

Bad procedure parameter.

007727

Unable to retrieve metadata for Procedure=`01, Schema=`02. DETAILS: `03

Metadata check failed.

007728

Parameter list type mismatch (#`01, SQR type = `02). The datasource expected a parameter of type `03. Verify the query metadata.

Parameter list mismatch.

007729

List size mismatch detected while fetching data of type ROW, `01 items, into SQR list-variable, `02 items. Fetching will proceed to the smaller size.

List size mismatch.

007730

Incorrect syntax for BEGIN-SELECT ... FROM. Options are: FROM ROWSETS=... FROM PARAMETER= $strvar | strlit

Bad begin-select syntax.

007732

Attempt to use a scalar SQR variable ('01') to reference a ROWSET procedure parameter ('02'). Use either the keyword 'NULL', or an SQR LIST variable (%var). Verify the query metadata.

Bad proc parameter.

007733

The list of keywords entered to the PARAMETERS keyword must be terminated with a semicolon.

Bad proc parameter. Correct the source code.

007734

Datasource '01' not found. The Connection being used by this query specifies a datasource which is not listed in the DDO Registry ('02'). DETAILS: `03.

Bad proc parameter. Correct the source code.

007735

Missing one or more DDO {fname} .jar files. Verify the location of the original-installation files, and that they are accessible. Error code: `01. Classpath: `02.

Bad environment.

007736

Unable to open Connection ('01') to datasource ('02'). Possible causes: (a) the Declare- or Alter-connection specification is invalid, or (b) the datasource is no longer available. DETAILS: `03.

Bad environment.

007738

At least one JNI method pointer was lost. This should never occur: record the steps leading up to this failure, and contact Technical Support. DETAILS: Schema='`01', Proc='`02'.

Bad environment.

007739

Unable to locate query object '`01' in the specified schema (`02). DETAILS: `03.

Bad environment.

007740

Invalid &pseudonym or 'TYPE=' data-type specified for a begin-select column-variable. Valid types are: CHAR, TEXT, DATE, NUMBER, BINARY.

Correct the syntax.

007741

Illegal attempt to fetch a non-scalar field into a column variable. Correct the query.

Correct the syntax.

007742

The output parameter specified in 'Begin-Select ... From Parameter = `01' is not available. Available parameters: `02.

Bad command.

007743

The output parameter specified in 'Begin-Select ... From Parameter = `01' is not of type ROWSET. Verify the query metadata.

Bad command.

007744

Illegal attempt to assign an SQR variable ('01') of type '02' the value from a DDO object ('03') of type '04'. Verify the query metadata.

Bad var assignment.

007745

Illegal attempt to assign an SQR column variable ('01') of type '02' the value from a DDO object of type '03'. Verify the query metadata.

Bad var assignment.

007746

Failed to locate the requested Rowset (`01) while processing the query. The last available Rowset number is `02. Verify the query metadata.

Not enough RowSets.

007747

The query raised a DDO exception. DETAILS: `01.

Bad query.

007748

A BEGIN-SELECT paragraph was coded, but the query returned no Rows.

No data warning.

007749

Invalid syntax for PARAMETERS=(...) statement. Use: PARAMETERS=( %v | $v | #v | &v | NULL | SKIP | numlit | datelit | textlit [IN | INOUT], ...) All parameters must be specified. Optional parameters which are to be ignored may be specified by the keyword 'NULL' or 'SKIP'. Correct the syntax.

Incorrect syntax.

007750

FATAL: Failure creating Java object.

General failure.

007751

Attempt to create a List variable of size greater than the maximum size of `01 items.

General failure.

007753

Attempt to access List-row (`01) beyond the List size (`02 rows).

Bad list assignment/setup.

007754

Attempt to assign/modify a List row is not compatible with the List definition.

Bad list assignment/setup.

007755

Attempt to assign a row to a non-existant List variable. Define the List first, using the syntax: let %lname[ size ] = list( NUMBER | DATE | TEXT #var | $var [, ...] )

Bad list assignment/setup.

007756

Incorrect syntax for List-variable reference. Use: let [$ | #]var = %listname[nlit | #var].colname

Bad list assignment/setup.

007757

Alter-connection statement missing 'DSN=...'.

Improper alter-conn.

007758

List-definition size specifier must be literal.

Improper alter-conn.

007759

Attempt to access a non-existent List-column ('01').

No such list column name.

007760

Must specify one of the keywords, FROM-ROWSETS or FROM_PARAMETER.

Incorrect syntax for Load-lookup.

007761

Incorrect syntax to Load-lookup 'PARAMETERS=' keyword. Use: PARAMETERS=(slit | nlit | $var | #var | %var | &var, ...) No line wrapping is allowed for this usage.

Incorrect syntax for Load-lookup.

007762

Too many parameters ( `02) entered to Load-Lookup command. Max parameters is `01.

Incorrect syntax for Load-lookup.

007763

Problem executing the cursor for LOAD-LOOKUP table '`01'. DETAILS: `02.

The database server returned an error while trying to execute the SQL statement needed to process the LOAD-LOOKUP command. `01 = Load lookup table name

007764

Bad return fetching row from database in LOAD-LOOKUP table '`01'. DETAILS: `02

The database server returned an error while fetching the data. `01 = Load lookup table name

007765

DC, DI sort options not supported with this SQR version. To sort, use SORT=SC or SORT=SI.

Database sort not supported for Load-Lookup with DDO.

007766

Must specify a query keyword; PROCEDURE=, COMMAND= or GETDATA=.

Incorrect syntax for Load-lookup. Specify a keyword representing the query.

007767

Unknown column variable type.

Unknown data type returned by the server.

007768

The property `01` was not found in the property sheet for the specified datasource (`02). Available property names are: `03. The datasource property sheet does not include the named property.

Verify the metadata and correct the syntax.

007771

Did not find value after '`01 ='

The code specified a Connection = keyword, but no matching literal. Correct the syntax.

007774

Invalid attempt to establish a second connection to datasource '`02', using Connection '`01'. The Connection '`01' is declared to allow only one active login (no-duplicate=TRUE).

Duplicate logins specified as not allowed. Correct the source code, declare a new Connection, or omit the use of no-duplicate in the subject Connection

007775

Bad value ('`01') for Alter-connection keyword (`02). Valid values are: `03.

Bad keyword value. Refer to the language reference and correct the syntax.

007778

Datasource login not available.

Connection non-existant. Correct the source. Possible causes: No BEGIN-EXECUTE statement.

007779

Unable to verify ResultSet column types due to use of variable. Variables are not allowed either for CONNECTION, SCHEMA, PROCEDURE, From-Parameter, or the first element of the From-Rowsets. Use literals or define column types using 'type=<datatype>'.

Can't verify colvar types with variable entry; use literals or define column types. Correct the source.

007780

Unable to verify ResultSet column types. Must specify column types using 'type=CHAR | NUMBER | DATE' construct when selecting from datasources which do not supply metadata, or when using the COMMAND= and GETDATA= keywords.

Can't verify colvar types with for COMMAND, GETDATA or from [TABLES]. Use type=<datatype> on select variables. Correct the source.

007781

Unable to log onto datasource to obtain query metadata. Specify the Connection for this query using a complete Declare-Connection statement, or specify type=<datatype> for each column variable in the Begin-Select.

Must declare a complete connection if use early binding of select column variables.

007783

Could not execute SQL.

DETAILS: `01

An error occurred while trying to compile the SQL statement. Correct the SQL statement or use the ON-ERROR= option to trap the error during the program run.

007784

Bad CONNECTION specification ('`01').

Possible causes: Syntax error, Dimension name not found, Dimension attributes not found, Dimension name not found in Begin-Select list. DETAILS: `02

The OLAP-related members of the named CONNECTION could not be processed, either due to syntax or no such name.

007785

The column specified ('`01') is ambiguous. It appears more than once in the data.

A column specified in the query appears multiple times in the data. Change the query to avoid that column, or rename the column in the data.

`01 = The column name

007786

Column ('`01') not found.

A column specified in the query was not found in the data.

`01 = The column name

007787

Unsupported datatype ('`02') found in column ('`01'). Only Text, Numeric, and Date are currently supported.

A column specified in the query contained values which are not currently supported. Change the query to use a different column.

`01 = The column name

`02 = The unsupported datatype

007789

The query is improperly specified. The result would involve a Cartesian Join which is not currently supported. Rewrite the query to involve only columns in the same branch of the tree.

The columns specified in the query are found in different branches of a heirarchical tree in the data. Computing result rows would require a Cartesian Join, which is not currently supported. Rewrite the query to involve only columns on the same branch of the tree.

007790

Must specify PROCEDURE= to use PARAMETERS= in BEGIN-EXECUTE.

Parameters may only be specified for PROCEDURE queries, not for COMMAND or GETDATA queries. Remove the PARAMETERS= line, or specify PROCEDURE= instead.

007791

Unable to locate one or more JAVA classes in the DDO JAR file.

Verify that the original installation files are not corrupted.

007792

Unable to locate one or more JAVA methods in the DDO JAR file.

Verify that the original installation files are not corrupted.

007793

An incompatible version of the DDO JAR file was found.

Verify that the original installation files are not corrupted.

Table 100. Numbered Messages  008000 to 009999

Error Number

Error Message

Suggestion/Interpretation

008000

Delay not appropriate for database columns or literals.

The DELAY argument to the PRINT command can only be used with SQR #variables or $variables.

008001

The width must also be specified when DELAY is used.

The DELAY argument to the PRINT command requires that the width argument be specified.

008003

The SET-PRINT-DELAY command cannot find a pending PRINT DELAYstatement.

An attempt was made to process an SET-DELAY-PRINT command against an SQR variable for which there was no pending PRINT DELAY statement.

008004

The PRINT DELAY statement did not have an SET-PRINT-DELAY command executed against it.

This PRINT DELAY statement did not have an SET-DELAY-PRINT command executed against it when SQR ended its run.

008005

The variable (`01`02) was referenced by a PRINT DELAY statement but the SQR program does not contain a matching SET-PRINT-DELAY command.

The referenced variable was used with a PRINT DELAY statement but the SQR program did not contain a SET-PRINT-DELAY command for that variable.

008006

The variable (`01`02) was referenced by a SET-PRINT-DELAY command but the SQR program does not contain a matching PRINT DELAY statement.

The referenced variable was used with a SET-PRINT-DELAY command but the SQR program did not contain a PRINT DELAY statement for that variable.

008101

The specified MODE value '`01' is not legal. Legal values are 'ON' or 'OFF'.

The MODE= qualifier values are ON or OFF.

`01 = Invalid value

008102

At least one qualifier must be specified.

Correct the source line.

008200

The specified color ('`01') is not defined.

The specified color is not defined in the color map.

`01 = Undefined color

008201

Qualifier '`01' has a malformed color reference.

The specified color reference is not properly formed. It can reference a single string literal, column, or variable (i.e. ($name)) or it can reference three numeric literals, columns, or variables (i.e. (10,20,30)) which represent the Red, Green, and Blue components of the color.

008202

Qualifier '`01' must reference SQR variables only.

The specified color reference is not properly formed. It can reference a single string variable (i.e. ($name)) or it can reference three numeric variables (i.e. (#R,#G,#B)) which represent the Red, Green, and Blue components of the color.

008203

Invalid RGB value (`01,`02,`03)

The RGB values are out of range. Each value can be from 0 to 255.

`01 = Red value

`02 = Green value

`03 = Blue value

008204

At least one qualifier must be specified.

Correct the source line.

008205

The Declare-Color-Map entry is not properly defined.

The Declare-Color-Map is not properly defined:

1) The color name can only contain characters [0-9 A-Z _ -].

2) The color name cannot be 'none'

3) The RGB values are not valid (each can be 0 to 255)

008206

Duplicate palette name: `01

Change the name of the palette.

`01 = Palette name in question

008207

The name can only contain characters [0-9 A-Z _ -].

Correct the syntax.

008208

The palette cannot have gaps. All colors up to the highest one defined (`01) must be specified.

An SQR palette cannot have gaps. Correct the source code.

`01 = Highest color defined for this palette

008209

The specified palette (`01) does not exist.

Change the name of the palette.

`01 = Palette name in question

008300

For font (`01) the specified typeface (`02) is not legal.

Correct the name of the CJK typeface

`01 = Font id

`02 = Typeface name

008301

For font (`01) the specified character map (`02) is not legal.

Correct the name of the CJK character map

`01 = Font id

`02 = Character map name

008302

For font (`01) both a typeface and character map must be specified.

If a CJK typeface is specified with a font then a character map must also be specified.

`01 = Font id

008304

The current report encoding (`01) requires that a typeface and a character map be specified with each font.

PDF support requires that a proper typeface and character map be associated with a font in order to generate a PDF file with the following output encodings:

  • Simplified Chinese: EUC-CN, GBK (CP936), UCS-2

  • Traditional Chinese: EUC-TW, BIG5, USC-2

  • Korean: EUC-KR, UHC (Johab), UCS-2

  • Japanese: EUC-JP, Shift-JIS, ISO-2022-JP, UCS-2

008305

For font (`01) the encoding (`02) is incompatible with the report output encoding (`03).

The encoding for the current font is incompatible with the encoding used for the PDF file.

`01 = Font id

`02 = Font encoding

`03 = Report output encoding

008400

The table name (`01) can only contain the following characters [0-9 A-Z _ -].

The specified table name contains invalid characters.

`01 = Table name

008401

The table name (`01) is already being used.

The specified table name is already being used.

`01 = Table name

008402

The table definition (`01) is already being used.

The specified table definition is already being used.

`01 = Table definition name

0008403

The table definition (`01) does not exist.

The specified table definition does not exist.

`01 = Table definition name

008404

The table (`01) does not exist.

The specified table does not exist.

`01 = Table name

008405

No table definition name was specified.

Correct the source line.

008406

When ACTION=ERASE no other parameters are allowed.

Correct the source line.

008407

When ACTION=INFO only the ROW and COUNT parameters are allowed. At least one must be specified.

Correct the source line.

008408

When ACTION=GET only the following combination of parameters are allowed:

  • ARRAY with optional ROW and COUNT

  • VALUES with optional ROW

Correct the source line.

008409

When ACTION=REPLACE only the following combination of parameters are allowed:

  • ARRAY with optional FIRST, ROW and COUNT

  • BLANK with optional ROW and COUNT

  • VALUES with optional ROW

Correct the source line.

008410

When ACTION=INSERT only the following combination of parameters are allowed:

  • ARRAY with optional MODE, FIRST, ROW and COUNT

  • BLANK with optional MODE, ROW and COUNT

  • VALUES with optional MODE and ROW

Correct the source line.

008411

When ACTION=DELETE only the ROW and COUNT parameters are allowed.

Correct the source line.

008412

When ACTION=APPEND only the following combination of parameters are allowed:

  • ARRAY with optional FIRST, and COUNT

  • BLANK with optional COUNT VALUES

Correct the source line.

008413

Qualifier '`01' requires a numeric variable.

Correct the source line.

008414

The value for '`01' (`02) must be `03 `04 and `05 `06.

Correct the source line.

`01 = Qualifer name

`02 = Value

`03 = Minimum value relation

`04 = Minimum value

`05 = Maximum value relation

`06 = Maximum value

008415

The first argument in '`01' must be the column number (>= 0 and <= `02).

Correct the source line.

`01 = Qualifier name

`02 = Maximum value

008416

The specified column number (`01) exceeds the number of columns for this table as specified by the COLUMN-COUNT qualifier.

Correct the source line.

`01 = Column number

008417

The specified column number (`01) has already been defined by another `02 qualifier.

Correct the source line.

`01 = Column number

`02 = Qualifier name

008418

Incorrect value (`01) for qualifier '`02'. Valid values are:

Correct the source line.

`01 = Value

`02 = Qualifier name

008419

Unknown keyword (`01) for qualifier '`02'. Valid keywords are:

Correct the source line.

`01 = Value

`02 = Qualifier name

008420

Incorrect value (`01) for qualifier '`02'. It must be an integer value > 0.

Correct the source line.

`01 = Value

`02 = Qualifier name

008421

Incorrect value (`01) for qualifier '`02'. It must be a numeric value > 0.

Correct the source line.

`01 = Value

`02 = Qualifier name

008422

Incorrect value (`01) for qualifier '`02'. It must be a string literal.

Correct the source line.

`01 = Value

`02 = Qualifier name

008423

Incorrect value (`01) for qualifier '`02'. It must be either YES or NO.

Correct the source line.

`01 = Value

`02 = Qualifier name

008424

Incorrect value (`01) for qualifier '`02'. It must be either YES, NO, or the number of lines.

Correct the source line.

`01 = Value

`02 = Qualifier name

008425

Qualifier '`01' has already been defined.

Correct the source line.

`01 = Qualifier name

`02 = List Keyword

008426

There are TABLE-FORMAT entries for column numbers which exceed the number of columns as defined by the COLUMN-COUNT qualifier.

Correct the source line.

008427

The value for SIZE= (`01) must be > 0.

Correct the source line.

008428

The value for EXTENT= (`01) must be > 0.

Correct the source line.

008429

Encountered an invalid VALUES= argument. Legal aruments types are $Variable and #Variable.

Correct the source line.

008430

Encountered an invalid (`01) VALUES= argument. Legal argument types are $Variable, #Variable, &Variable, 'Literal', Numerics, and the word NULL.

Correct the source line.

`01 = List contents

008431

The type of VALUES= parameter (`01) is not compatible with the corresponding table column (`02) defined as '`03'.

The VALUES= parameter type is not compatible with the corresponding TABLE column type.

`01 = VALUES parameter

`02 = Table column number

`03 = Table column type

008432

The number of parameters in the VALUES= list exceeds the number of columns (`01) for table (`02).

The number of parameters in the VALUES= list exceeds the number of columns defined in the table.

`01 = Table column count

`02 = Table name

008433

The value for MODE= (`01) must be either BEFORE or AFTER.

Correct the source line.

008434

Cannot perform GET because the specified table (`01) is empty.

The ACTION=GET option cannot be used against an empty table.

`01 = Table name

008435

The number of columns (`01) defined for array (`02) does not match the number of columns (`03) defined for table (`04).

The number of columns defined for the specified array must be the same as the number of columns defined for the specified table.

`01 = Array column count

`02 = Array name

`03 = Table column count

`04 = Table name

008436

Column type mismatch in column (`01): Array (`02) is defined as (`03) and Table (`04) is defined as (`05)

The column types for the specified array must be compatible with the columns types for the specified table.

`01 = Column number

`02 = Array name

`03 = Array column type

`04 = Table name

`05 = Table column type

008437

Cannot perform GET from table (`01) for `02 rows because the array (`03) can only support (`04) rows.

The ACTION=GET option cannot be used to increase the size of array.

`01 = Table name

`02 = Table rows

`03 = Array name

`04 = Array size

8600

Binary variables (`01) cannot be used with this command.

Correct the source syntax.

`01 = Variable name

8601

The use of an edit mask or the keywords NUMBER, MONEY or DATE is not legal when storing numeric or binary variables.

Correct the source code.

8602

Binary variables (`01) cannot be used in BEGIN-SQL or BEGIN-SELECT paragraphs.

Correct the source code.

`01 = Variable name

8603

The use of an edit mask is not legal with binary variables.

Correct the source code.

8604

All variables must be binary if one variable is binary.

Correct the source code.

8605

COMPAR: Unknown relational (binary) operator.

Internal error that should never occur during normal operations. Record the steps leading up to the error and contact customer support.

8606

Incorrect relational operator for binary variables. Only = and != allowed.

Correct the source code.

8607

The ENCODING qualifier is not allowed when the record type is binary.

Correct the source code.

8608

The record type of the file is not binary.

Files must be opened for BINARY access when binary variables are used. Correct the program logic.

8609

The CODE-PRINTER qualifier is required when binary variables are used.

The CODE-PRINTER qualifier is required to PRINT binary variables. Correct the source code.

8610

Function or operator '`01' requires binary argument.

Correct the source line.

`01 = Function or operator

8611

Function or operator '`01' does not support binary arguments.

Correct the source line.

`01 = Operator

8612

Function or operator '`01' must be a binary or string argument.

Correct the source line.

`01 = Function or operator

8613

Qualifier '`01' requires a binary literal.

Correct the source line.

`01 = Qualifier name

8614

Qualifier '`01' requires a binary literal, variable, or column.

Correct the source line.

`01 = Qualifier name

8615

Qualifier '`01' requires a binary or string literal, variable, or column.

Correct the source line.

`01 = Qualifier name

8616

Error creating the image: '`01'.

(`02): `03

SQR aborts the program run.

`01 = Image file name

`02 = System error code

`03 = System error message

8617

Error closing the image: '`01'.

(`02): `03

SQR aborts the program run.

`01 = Image file name

`02 = System error code

`03 = System error message

8618

Error writing the image: '`01'.

(`02): `03

SQR aborts the program run.

`01 = Image file name

`02 = System error code

`03 = System error message

8619

Error opening the image: '`01'.

(`02): `03

SQR aborts the program run.

`01 = Image file name

`02 = System error code

`03 = System error message

8620

Error reading the image: '`01'.

(`02): `03

SQR aborts the program run.

`01 = Image file name

`02 = System error code

`03 = System error message

8621

The SQR compression logic failed, reason `01.

The SQR compression logic failed while compressing an image.

`01 = Reason code

8622

The SQR decompression logic failed, reason `01.

The SQR decompression logic failed while decompressing an image.

`01 = Reason code

8623

The embedded BMP image is not valid, reason `01.

(Windows) The embedded bitmap image is not valid.

`01 = Reason code

009999

The printer (`01) specified with the -Printer:WP command line flag is invalid.

(Windows) The specified printer is not valid.