Use the CREATE TABLE clause to specify whether to create the destination table if it does not exist. If COLUMN WIDTHS is not specified, the widths are determined by the database column types. The COLUMN WIDTHS clause specifies the widths of the columns in the input file and can only be specified for FIXED format. The input data, encoding on the client computer is used. If you do not specify an ENCODING clause and the BYTE ORDER MARK option is OFF, or a BOM is not found at the beginning of.UTF-16LE, or UTF-8) and the BOM is not considered to be part of the data to be loaded. If a BOM is located, the source encoding is automatically selected based on the encoding of the BOM (UTF-16BE, If you do not specify an ENCODING clause and the BYTE ORDER MARK option is ON, Interactive SQL looks for a BOM at the beginning.If the BYTE ORDER MARK option is ON and you specify a UTF-8 encoding, Interactive SQL searches for a BOM at the beginning.The operating system endianness is assumed. If a BOM is present, it is used to determine the endianness of the data. If the BYTE ORDER MARK option is ON and you specify a UTF-16 encoding without an explicit endian, Interactive SQL searchesįor a BOM at the beginning of the data.If you specify the wrong endian, an error is returned. If a BOM is present, it is used to verify the endianness of the data. SQL searches for a BOM at the beginning of the data. If the BYTE ORDER MARK option is ON and you specify a UTF-16 encoding with an endian such as UTF-16BE or UTF-16LE, Interactive.To use the BYTE ORDER MARK clause with any other encoding causes an error. The BYTE ORDER MARK clause is used only when reading or writing files encoded with UTF-8 or UTF-16 (and their variants). With FORMAT clauses other than TEXT causes an error. Attempts to use the BYTE ORDER MARK clause

The BYTE ORDER MARK clause is relevant only when reading from TEXT formatted files. Use this clause to specify whether to process a byte order mark (BOM) in the data. NAME is allowed only for those formats that have name information in the file. On their ordinal position in the list (ORDER being the default) or by their names (NAME). Use this clause to specify whether the columns from the input file should be matched up with the table columns based

Sql prompt input