Hello everyone,
I wrote this query, but I keep getting this error. Does anyone know what Im doing wrong?

Failed to retrieve data from database.
Details 42S22:[IBM][CLI Driver][DB2/6000} SQL0206N " DATAAUDIT.KEY_REPRESENTATION" is not valid in the context where it is used. SQLSTATE = 42703
DATAbase Vendor Code:-206]


My Query
SELECT
DATAAUDIT.KEY_REPRESENTATION
, CAST(SUBSTRING(DATAAUDIT.KEY_REPRESENTATION,charindex('=',DATAAUDIT.KEY_REPRESENTATION)+1,(charindex('|',DATAAUDIT.KEY_REPRESENTATION) - charindex('=',DATAAUDIT.KEY_REPRESENTATION)-1)) as BIGINT) as MEMBER_NBR
, CAST(SUBSTRING(DATAAUDIT.KEY_REPRESENTATION,charindex('=',DATAAUDIT.KEY_REPRESENTATION,charindex('=',DATAAUDIT.KEY_REPRESENTATION)+1)+1,LEN(DATAAUDIT.KEY_REPRESENTATION)) AS BIGINT) as LOAN_NBR
, DATAAUDIT.FOCUS_TELLER_ID
, LOAN. RATE
, LOAN. Loan_Type
, PRODUCT.PRODUCT_NAME
, LOAN.Rate_Delta as Manual_RATE
, DATAAUDIT.ACTIVITY_ID
, DATAAUDIT. TABLE_NAME
, DATAAUDIT. ADDTIMESTAMP
, DATAAUDIT.COLUMN_NAME
, DATAAUDIT.BEFORE_REPRESENTATION
, DATAAUDIT.AFTER_REPRESENTATION
, DATAAUDIT.IS_FINANCIAL
, DATAAUDIT.WORKSTATION
, DATAAUDIT.ACTION_TYPE

FROM DB2INST1.DATAAUDIT,
DB2INST1.LOAN,
DB2INST1.ACCOUNT,
DB2INST1.PRODUCT
Where CAST(SUBSTRING(DATAAUDIT.KEY_REPRESENTATION,charindex('=',DATAAUDIT.KEY_REPRESENTATION)+1,(charindex('|',DATAAUDIT.KEY_REPRESENTATION) - charindex('=',DATAAUDIT.KEY_REPRESENTATION)-1)) as BIGINT) = Loan.MEMBER_NBR and
CAST(SUBSTRING(DATAAUDIT.KEY_REPRESENTATION,charindex('=',DATAAUDIT.KEY_REPRESENTATION,charindex('=',DATAAUDIT.KEY_REPRESENTATION)+1)+1,LEN(DATAAUDIT.KEY_REPRESENTATION)) AS BIGINT) = Loan.LOAN_NBR and
Loan.MEMBER_NBR = ACCOUNT.MEMBER_NBR and
Loan.LOAN_NBR = ACCOUNT.ACCOUNT_NBR and
ACCOUNT.PRODUCT_CODE = PRODUCT.PRODUCT_CODE and
ACCOUNT.PRODUCT_CATEGORY_CODE = PRODUCT.PRODUCT_CATEGORY_CODE
and ACCOUNT.PRODUCT_CLASS_CODE = PRODUCT.PRODUCT_CLASS_CODE and
Table_Name = 'Loan'