MQSeries.net :: View topic

anilmekala · Posted: Mon Sep 21, 2015 4:37 am Post subject:

Hi All,

As part of my requirment i have to call DB2 view in my ESQL code.

I have created view in DB2 studio and have ran select function its working fine.

created View :

CREATE OR REPLACE VIEW "ESBVIEWER"."VW_CONTACTDETAILS_CI_CUSTMAST" ("CustomerFullName", "CustomerFirstName", "CustomerLastName", "DateofBirth", "AddressLine1", "AddressLine2", "AddressLine3", "City", "PINCode", "State", "Country", "EmailID", "MobileNumber", "Gender", "CustomerID") AS
SELECT
C.NAM_CUST_FULL,
c.nam_cust_first,
c.nam_cust_last,
C.DAT_BIRTH_CUST,
C.TXT_CUSTADR_ADD1,
C.TXT_CUSTADR_ADD2,
C.TXT_CUSTADR_ADD3,
C.nam_custadr_city,
C.nam_custadr_state,
C.nam_custadr_cntry,
C.txt_custadr_zip,
C.ref_cust_email,
C.ref_cust_telex,
C.txt_cust_sex,
C.COD_CUST_ID
FROM YBL.CI_CUSTMAST C
WHERE flg_mnt_status = 'A';

SELECT * FROM "ESBVIEWER"."VW_CONTACTDETAILS_CI_CUSTMAST";

select "MobileNumber" from "ESBVIEWER"."VW_CONTACTDETAILS_CI_CUSTMAST" WHERE "CustomerID" = 1234;

ESQL code :

SET sqlString = 'select VW.MobileNumber AS MobileNumber from ESBVIEWER.VW_CONTACTDETAILS_CI_CUSTMAST AS VW WHERE VW.CustomerID=?';

SET Environment.Variables.MobileNumber = PASSTHRU(sqlString,cCustomerId);

When i use same select function in my esql code I am getting

below exception:

Text:CHARACTER:[IBM][CLI Driver][DB2/NT64] SQL0206N "CUSTOMERID" is not valid in the context where it is used. SQLSTATE=42703

Please help me what could be the reason.

Regards,

Anil.