KFAA31265-E

The specification method for aa....aa of the CREATE FOREIGN TABLE statement is invalid. <SQLSTATE:427M7>

aa....aa: Location of invalid specification

• foreign table option: Foreign table option

• foreign data directory path string: Foreign data directory path string

• template directory path string: Template directory path string

• delimiter character: Delimiter character

• enclosing character: Enclosing character

• enumeration string: Enumeration string

• minimum value string or integer: Minimum value string or minimum value integer

• maximum value string or integer: Maximum value string or maximum value integer

• datetime format string: Date and time format string

• interval value: Interval value

• digit value: Number of digits

• catalog namespace: Catalog namespace

• catalog endpoint string: Catalog endpoint string

• catalog region: Catalog region name

• catalog ID: Catalog ID

• warehouse name: Warehouse name

• token URI: Token URI

• client ID: Client ID

• client secret: Client secret

• allowed scope string: Allowed scope string

bb....bb: Cause of the error

• the data length exceeds the range that can be specified

  The data length exceeds the range that can be specified.

• the value exceeds the range that can be specified

  The value exceeds the range of values that can be specified.

• the specified option is duplicated

  The specified option is specified more than once.

S:

Ignores this SQL statement. Alternatively, the system invalidates this transaction.

Action:

Correct the SQL statement.