WE050 - WE099

Lists the SQL Wizard Export error messages from WE050 through WE099.

Restriction: This topic applies to Windows environments only.

WE050: PRIQTY value must be an integer in the range 12 to 4,194,304.
See the CREATE INDEX command description in the SQL Reference for information on the correct parameters.
WE051: SECQTY value must be an integer in the range 0 to 131,068.
See the CREATE INDEX command description in the SQL Reference for information on the correct parameters.
WE052: FREEPAGE value must be an integer in the range 0 to 255.
See the CREATE INDEX command description in the SQL Reference for information on the correct parameters.
WE053: PCTFREE value must be an integer in the range 0 to 99.
See the CREATE INDEX command description in the SQL Reference for information on the correct parameters.
WE054: No tables found with authid auth-id in location location-name.
See the CREATE INDEX command description in the SQL Reference for information on the correct parameters.
WE055: Invalid DATABASE name.
Database names must follow the rules for short identifiers. The database name used is invalid.
WE056: Invalid TABLESPACE name.
Tablespace names must follow the rules for long identifiers. The Tablespace used is invalid.
WE057: Invalid EDITPROC name.
EDITPROC names must follow the rules for short identifiers. The name used is invalid.
WE058: Invalid VALIDPROC name.
VALIDPROC names must follow the rules for short identifiers. The name used is invalid.
WE059: Internal error reading batch file.
The system was unable to read the batch file. Check to make sure the file is a valid Export batch script.
WE060: Unable to access code page information.
The system encountered an error when attempting to access the specified code page. Make sure that the code page has been defined in SYSTEM.SYSIBM.SYSSTRINGS, and that it has been correctly specified in the batch script.
WE061: Invalid error log file name file-name specified in batch file.
The specified name is an invalid filename for the underlying operating system. Check your operating system documentation for a description of valid filenames.
WE062: Float value in field fieldname is smaller than the IBM370 limit.
The float value is not supported by IBM370.
WE063: Unable to open View Batch window, probably out of memory.
The system tried to open the view window, but was unable to do so. Try closing down other SQLWizard windows, or other applications that are using system resources.
WE064: Unable to open View Data window, probably out of memory.
The system tried to open the view window, but was unable to do so. Try closing down other SQLWizard windows, or other applications that are using system resources.
WE065: Unrecognized value value for SQL_OPTS command in group number, groupname.
Export found an illegal setting in the batch file. The syntax of this command is:
WE066: Invalid value value for ASCII_CODEPAGE in group number, groupname.
Export found an error in the current batch export file. The syntax of this command is:
WE067: Invalid value value for EBCDIC_CODEPAGE in group number, groupname.
Export found an error in the current batch export file. The syntax of this command is:
WE068: Invalid value value for FORMAT command in group number, groupname.
Export found an error in the current batch export file. The syntax of this command is:
WE069: Batch file filename is empty.
The specified file does not contain any batch specifications.
WE070: Unknown batch command command in group number, groupname.
The batch export file contains invalid or unknown commands.
WE071: Invalid value value for FLD_DELIMITER command in group number, groupname.
The syntax of this command is:
WE072: Invalid value value for REC_DELIMITER command in group number, groupname.
The syntax of this command is:
WE073: Invalid value value for HEADING command in group number, groupname.
The syntax of this command is:
WE074: Invalid value value for FILENAME command in group number, groupname.
The syntax of this command is:
WE075: Invalid value value for TABLE command in group number, groupname.
The syntax of this command is:
WE076: Invalid value value for PAGE_SIZE command in group number, groupname.
The syntax of this command is:
WE077: Invalid value value for FIELDS command in group number, groupname.
The syntax of this command is:
WE078: Invalid value value for QUOTES command in group number, groupname.
The syntax of this command is:
WE079: Invalid value value for SPACES command in group number, groupname.
The syntax of this command is:
WE080: Unable to get information about fields in table tablename.
The system failed in an attempt to get information about the columns in the specified table. Make sure you have privileges on the catalog tables or views, and that the SYSIBM and SYSXDB items in the SQL page of the Options are set to the correct AuthID values.
WE081: Invalid value value for REPLACE command in group number, groupname.
The syntax of this command is:
WE082: Invalid value value for DATABASE command in group number, groupname.
The value must be a valid database object name. In general, names must begin with a letter, can contain letters and digits, and the characters # $ % & _ { } in XDB mode or @ # $ _ in DB2 mode.
WE083: Invalid value value for TABLESPACE command in group number, groupname.
The value must be a valid database object name. In general, names must begin with a letter, can contain letters and digits, and the characters # $ % & _ { } in XDB mode or @ # $ _ in DB2 mode.
WE084: Invalid value value for EDITPROC command in group number, groupname.
The value must be a valid database object name. In general, names must begin with a letter, can contain letters and digits, and the characters # $ % & _ { } in XDB mode or @ # $ _ in DB2 mode.
WE085: Invalid value value for VALIDPROC command in group number, groupname.
The value must be a valid database object name. In general, names must begin with a letter, can contain letters and digits, and the characters # $ % & _ { } in XDB mode or @ # $ _ in DB2 mode.
WE086: Invalid value value for AUDIT command in group number, groupname.
AUDIT value must be one of NONE, CHANGES or ALL.
WE087: Invalid value value for VCAT command in group number, groupname.
VCAT value must be one of WITH, ROOT, PATH or NAME.
WE088: Invalid value value for STOGROUP command in group number, groupname.
The value must be a valid database object name. In general, names must begin with a letter, can contain letters and digits, and the characters # $ % & _ { } in XDB mode or @ # $ _ in DB2 mode.
WE089: Invalid value value for PRIQTY command in group number, groupname.
PRIQTY value must be a number from 0 to 4,194,309.
WE090: Invalid value value for SECQTY command in group number, groupname.
SECQTY value must be a number from 0 to 131,068.
WE091: Invalid value value for ERASE command in group number, groupname.
ERASE value must be either Y or N.
WE092: Invalid value value for FREEPAGE command in group number, groupname.
FREEPAGE value must be a number from 0 to 255.
WE093: Invalid value value for PCTFREE command in group number, groupname.
PCTFREE value must be a number from 0 to 99.
WE094: Invalid value value for DUPQTY command in group number, groupname.
DUPQTY value must be either 8, 16, 32, 64 or 128.
WE095: Invalid value value for CLUSTER command in group number, groupname.
CLUSTER value must either Y or N.
WE096: Invalid value value for SUBPAGES command in group number, groupname.
SUBPAGES value must be either 1, 2, 4, 8 or 16.
WE097: Invalid value value for BUFFERPOOL command in group number, groupname.
BUFFERPOOL value must be in one of the following formats:
WE098: Invalid value value for DSETPASS command in group number, groupname.
The value must be a valid database object name. In general, names must begin with a letter, can contain letters and digits, and the characters # $ % & _ { } in XDB mode or @ # $ _ in DB2 mode.
WE099: Invalid value value for CLOSE command in group number, groupname.
CLOSE value must be either Y or N.

Parent topic: WE - SQL Wizard Export Error Messages