Will this Query will trigger the JDCB Sender to IS -- ?

[former_member189387]

Hi friends ,

I am using the Following query i am using the alias column name which is quivalent to database column names . Because i need to get atleast one row .Otherwise my where claues (Updated_On IS NULL) will not return anything .So i have written the qury like this .

<b>I have given exact culumn names in DATA TYPE definiton of XI .</b>

<b> IT IS WORKING FOR ONLY SELECT * FROM WHICH RETURNS ATLEAST ONE ROW</b>

'/***************************************************

<b>SELECT '0' AS TrnHisID , case when COUNT(*) = 0 then 'Y' ELSE 'X' end AS TransactionStr, '0000-00-00 00:00:00' AS TransTimeStamp , 'TEST' AS Tag , '0000-00-00 00:00:00' AS Updated_On FROM UtilityTranshist WHERE Updated_On IS NULL</b>

'/****************************************************

That query has returns the result set as

<b>TrnHisID TransactionStr TransTimeStamp Tag Updated_On

-

---

-

---

-

---

-

---

-

---

0 Y 0000-00-00 00:00:00 TEST 0000-00-00 00:00:00</b>

'/*************************************************************************

But this result set is get passed to IS . If i see using SXMB_MONI . no transaction is happenning .

1 .Will JDBC Sender will work for only <b>select * from</b> (Or) we can give as ( <b>select TrnHisID , TransactionStr from UtilityTranshist </b> ) ?

Can you please give me a solution

Best Regards .,

V.Rangarajan

[Former Member · Accepted solution]

Hi ,

<i>1 .Will JDBC Sender will work for only select * from (Or) we can give as ( select TrnHisID , TransactionStr from UtilityTranshist ) ?</i>

JDBC Sender Adapter works for both.

Regards,

Sumit