Micro Focus Enterprise Developer 3.0 for Visual Studio 2017 > Programming > Mainframe Programming > SQL Option for DB2 > Reference > Error Messages > WI - SQL Wizard Import Error Messages > WI000 - WI049

WI000 - WI049

Lists the SQL Wizard Import error messages from WI000 through WI049.

WI001: Premature end of line found, record record.
Encountered an unexpected end of line on the record specified.
WI002: Number field(s) were found in record number; record should contain number field(s).
A record containing the wrong number of fields exists in the file you are importing. Check the record in your source file (record n) and make sure that it has the same number of fields as the target table.
WI003: The character character in position position in heading line of Fixed ASCII file filename is not allowed in a column name.
A field name in your fixed-ASCII data file contains a character that is not permitted in a database object name. See your SQL Reference for a list of characters that can be used in a column name.
WI004: The maximum number of open Import windows has been reached.
You have opened the maximum number of Import windows. Close some of the Import windows before you continue.
WI005: Table name is not specified.
You must provide a table name for the target table.
WI007: Invalid value number for varchar length; length must be no greater than number.
The length of a varchar field is greater than the page size set for each record.
WI008: No translation table exists with specified INCCSID and OUTCCSID.
There is no record in the SYSIBM.SYSSTRINGS table whose values in the INCCSID and OUTCCSID fields match the numbers found in XDB.INI. If you are importing in the DSNTIAUL format, check InCCSID and OutCCSID in the [Import] section of XDB.INI. If you are importing in a different format, check AscSrcCodePage and AscDstCodePage.
WI009: Keyboard navigation error.
Internal error. Contact Micro Focus Technical Support.
WI010: Invalid value value for DSN_CRLF command in group number, groupname.
The batch file command DSN_CRLF can only take the values "y" or "n".
WI011: No source file name specified.
You must enter the full pathname of the data file you want to import in the File Name edit box of the Source File Information area.
WI012: Unable to open Grid window.
An internal error is preventing SQLWizard from creating the table area in the Import window. This may be caused by insufficient memory. Close any unnecessary applications, then retry the Import command. If this does not resolve the problem, clear memory by restarting SQLWizard or by rebooting.
WI013: Data in field fieldname of record record-name is number characters long but field definition inumber characters.
The data found in a character field in the source file is longer than the length of that field in the target table.
WI014: End-of-line delimiter delimiter not found while counting fields in record.
The current record in your free format ASCII file does not contain the Field Delimiter specified on the screen.
WI015: Invalid value value for APPEND_ERR_FILE command in group number, groupname.
The batch file command APPEND_ERR_FILE can only take the values "y" or "n".
WI016: Invalid value value for APPEND_REC_FILE command in group number, groupname.
The batch file command APPEND_REC_FILE can only take the values "y" or "n".
WI017: DSNTIAUL file file-name does not contain a complete record.
A record in the DSN file contains a record with size that is smaller than the record size in the destination table.
WI018: Invalid value value for TIMESTAMP command in group number, groupname.
The batch file command TIMESTAMP can only take the values "y" or "n".
WI019: Batch import file file-name not found.
Select a batch import file that exists.
WI020: Batch Import file filename does not contain a group heading.
The first line of a batch import file has to be a group heading.
WI021: Record number contains more than the maximum of number fields, or end of record not found.
Import has detected more fields in the current record than are specified in the table definition. Either your data file contains extra fields in this record, or the record delimiter is missing from this record, causing Import to interpret the data in the next record as part of the data for this record.
WI022: Table name is not specified in group number, groupname.
No value was assigned to the batch file command TABLE.
WI023: Error writing to logfile filename, errno = error-number.
The attempt to write to the specified log file failed. Check your operating system documentation for the meaning of the error specified by the errno value.
WI024: Error opening logfile filename.
An attempt to open the specified log file failed. Either it does not exist or is in use.
WI025: End quote missing in field fieldname, record record of data file filename.
A quote is missing from a character field in a free format ASCII file.
WI026: Data exceeds 4K page size.
The size of a record in a DSNTIAUL file must be no greater than 4096 bytes.
WI027: Length specification missing from Char, Varchar, Graphic, or, VarGraphic data type, line line-number.
Specify these types in the following format:
WI029: Number fields were specified, but number fields were found in file.
There are more fields in the fixed-ASCII source file than there are in the target table. Check the source file to make sure that the length of its records matches that of your destination table.
WI030: Unable to open file filename.
Either the file was not found in the indicated directory, is in use, or is invalid. Check to be sure that you have specified the correct file name and directory.
WI031: More field names were found than the number of fields specified.
The number of fields specified for your table is less than the number of fields found in your data file.
WI034: Field name for field number, fieldname, is longer than number characters.
Field names may not be longer than number characters.
WI035: Incorrect field type type in ConvertDataStrToInternal().
Internal error. Call Micro Focus Technical Support.
WI036: Invalid field delimiter delimiter.
When specifying a delimiter using decimal notation, use the format <nnn>, where nnn is an integer between 0 and 255. See your SQLWizard User's Guide for further information on entering delimiters.
WI037: Invalid record delimiter delimiter.
When specifying a delimiter using decimal notation, use the format <nnn>, where nnn is an integer between 0 and 255.
WI038: Invalid source file name filename.
See your operating system documentation for an explanation of valid file names.
WI039: Invalid table name.
See your documentation for an explanation of valid table names. Also see WSQL045.
WI040: Invalid value for number of spaces between fields.
The number of spaces between fields should be an integer from 0 to 99.
WI041: Data file filename is empty.
It is not possible to import the specified data file, as it contains no data.
WI044: Invalid character (character) found in field name in field number in header line of data file.
An illegal column name was found in the source file. See the SQL Reference for rules for identifiers for XDB Server and DB2. Also see WSQL045.
WI047: Invalid length in type specification type, field number.
The length in the specified field is invalid for the field type.
WI048: Invalid length in Character or Varchar type specification type, field number.
Character and Varchar lengths must be no longer than 4048.
WI049: Invalid length in Graphic type specification type, field number.
Graphic length must be no longer than 127.

Parent topic: WI - SQL Wizard Import Error Messages