Hitachi

Hitachi Advanced Database SQL Reference


1.15.4 If message KFAA30202-E is displayed

Check if there is an error in a specified column name.

Example:

SELECT "USRID","PUR-CODE","PUR-DATE" FROM "SALESLIST"
    WHERE "PUR-DATE">=DATE'2011-09-06'
 
KFAA30202-E Column "USRID" is not found in any table. (query number = 1)

In this example, the underlined portion of the statement is incorrect. The correct column name is "USERID".