1.15.1 If message KFAA30104-E is displayed

Check if there is an error such as the following:

Character string not enclosed in single quotation marks (')

If a value specified in a conditional expression is a CHAR type or VARCHAR type character string, you must enclose the character string in single quotation marks (').

Example:
```
SELECT "USERID" FROM "USERSLIST" WHERE "NAME"=Taro Tanaka
 
KFAA30104-E There is an unnecessary part "Tanaka" in the SQL statement.
```
In this example, the underlined portion of the statement is incorrect. The correct specification is 'Taro Tanaka'.
Column name or table name not properly enclosed in double quotation marks (")

Example:
```
SELECT "USERID,"PUR-CODE","PUR-DATE" FROM "SALESLIST"
    WHERE "PUR-DATE">=DATE'2011-09-06'
 
KFAA30104-E There is an unnecessary part ",(0x2c)" in the SQL statement.
```
In this example, the underlined portion of the statement is incorrect. There is no double quotation mark (") specified after USERID.

WHERE not correctly spelled

Example:

SELECT "USERID","PUR-CODE","PUR-DATE" FROM "SALESLIST"
    WHRER "PUR-DATE">=DATE'2011-09-06'
 
KFAA30104-E There is an unnecessary part ""PUR-DATE">=DATE'2011-09-06'"
in the SQL statement.

In this example, the underlined portion of the statement is incorrect. The correct specification is WHERE.

To Page Top