cancel
Showing results for 
Search instead for 
Did you mean: 

Complex Query

Former Member
0 Kudos

Can we code a complex query in JDBC sender CC.

Like, SELECT (..)

FROM ..

WHERE X = (SELECT ..

FROM ...)

UNION

SELECT (...)

Thanks

Venu

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Venu,

This is possible. We have an operational interface running a query like:

SELECT (...)

FROM table1, table2

WHERE x= SELECT (...

FROM table3, table4

WHERE ..

DENSE RANK)

AND RANK < xxx

If that is supported, I think most stuff will be supported...

Regards,

Yordy

Former Member
0 Kudos

Hi Yordy,

can you please post the SQL XML structure . It is really point winning stuff.

Thanks

Sindhu

Former Member
0 Kudos

Hi Venu,

I am not sure whether XI JDBC adapter supports complex select statements or not. You can always try using JDBC Native SQL Format for this requirement.


 <StatementName6>

<anyName action=” SQL_QUERY” | “SQL_DML”>

<access>SQL-String with optional placeholder(s)</access>

<key>

  <placeholder1>value1</placeholder1>

  <placeholder2>value2<placeholder2>    

</key>

 </anyName > 

  </StatementName6>

regards,

Ananth