ODBC_29: Prepared: on connection 1
select t1."ACCTCN" as AccountNumber, t1."PFNMCN" as FirstName, t1."PLNMCN" as LastName, t1."DTBTCN", t1."RAD1CN" as Address, 
t1."RAD3CN" as Brgy, t1."RCNTCN", t1."RCTYCN" as City, t1."RPHNCN" as MobileNumber, t1."ASEXCN" as Gender, case  when 
(t2."CRLVCLAS" = 19) and (t2."PCTCCLAS" = 1) then 'SILVER' when (t2."CRLVCLAS" = 19) and (t2."PCTCCLAS" = 2) then 'GOLD' when 
(t2."CRLVCLAS" = 19) and (t2."PCTCCLAS" = 3) then 'PLATINUM' when (t2."CRLVCLAS" = 19) and (t2."PCTCCLAS" = 4) then 'EMERALD' when 
(t2."CRLVCLAS" = 19) and (t2."PCTCCLAS" = 5) then 'RUBY' when t2."CRLVCLAS" = 18 then 'DIAMOND' when (t2."CRLVCLAS" = 17) and 
(t2."PCTCCLAS" = 1) then 'VIP' else 'UNKNOWN' end as CardTier, t3."RPCDLR" as RepCode, t1."ATYPCN" as AccountType, t1."RSTECN" as 
ProvinceCode, t1."STS2CN", case  when (t1."STS2CN" = 'C') and (t1."STS1CN" = 'M') then 'Yes' else 'No' end as SuspendedCreditFlag 
from {oj CASDTATP.CFPCN t1 left outer join CASDTATP.CFPCLAS t2 on t1."ACCTCN" = t2."ACCTCLAS" left outer join CASDTATP.CFPLR t3 on 
t1."ACCTCN" = t3."ACCTLR"} where t1."ATYPCN" <> 'R'

ODBC: Called SQLStatistics with schema of CASDTATP for table CFPRQ
ODBC: Called SQLStatistics with schema of CASDTATP for table CFPPM

ODBC_30: Executed: on connection 1
Prepared statement ODBC_29

ACCESS ENGINE:  SQL statement was passed to the DBMS for fetching data. 
ERROR: CLI cursor fetch error: [DataDirect][ODBC 20101 driver][UDB DB2 for iSeries and AS/400]8227