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.