Hi All,
I have a question below regarding IS JDBC Adapter.
SELECT t1.SURNAME,t1.GIVNAME,t1.CLTSEX,t1.RACE,t1.CLTADDR01,t1.CLTADDR02,t1.CLTADDR03,
t1.CLTADDR04,t1.SALUTL,t1.CTRYCODE,t1.CLTPHONE01,t1.CLTPHONE02,t1.OCCPCODE,
t1.SERVBRH,t1.CLTDOB,t1.MARRYD,t1.NATLTY,t1.CLNTNUM,t1.SECUITYNO,
t1.SOE,t1.CLTTYPE FROM CLTS t1 WHERE (t1.CLNTPFX = ? AND t1.CLNTCOY = ? AND ( t1.SECUITYNO = ? OR t1.CLNTNUM = ? ))
Refer to the above script, It is configured in Adapter SelectSQL template . When this adapter is called from flow service, If I only pass in t1.CLNTPFX, t1.CLNTCOY and t1.SECUITYNO value.I did not map or hard code any value for t1.CLNTNUM. What will be the actual script look like when this script executed.
SELECT t1.SURNAME,t1.GIVNAME,t1.CLTSEX,t1.RACE,t1.CLTADDR01,t1.CLTADDR02,t1.CLTADDR03,
t1.CLTADDR04,t1.SALUTL,t1.CTRYCODE,t1.CLTPHONE01,t1.CLTPHONE02,t1.OCCPCODE,
t1.SERVBRH,t1.CLTDOB,t1.MARRYD,t1.NATLTY,t1.CLNTNUM,t1.SECUITYNO,
t1.SOE,t1.CLTTYPE FROM CLTS t1 WHERE (t1.CLNTPFX = ‘1234’ AND t1.CLNTCOY = ‘P’ AND ( t1.SECUITYNO = ‘999’ OR t1.CLNTNUM = null))
OR
SELECT t1.SURNAME,t1.GIVNAME,t1.CLTSEX,t1.RACE,t1.CLTADDR01,t1.CLTADDR02,t1.CLTADDR03,
t1.CLTADDR04,t1.SALUTL,t1.CTRYCODE,t1.CLTPHONE01,t1.CLTPHONE02,t1.OCCPCODE,
t1.SERVBRH,t1.CLTDOB,t1.MARRYD,t1.NATLTY,t1.CLNTNUM,t1.SECUITYNO,
t1.SOE,t1.CLTTYPE FROM CLTS t1 WHERE (t1.CLNTPFX = ‘1234’ AND t1.CLNTCOY = ‘P’ AND ( t1.SECUITYNO = ‘999’ ))