on 08-10-2006 1:57 AM
Can we code a complex query in JDBC sender CC.
Like, SELECT (..)
FROM ..
WHERE X = (SELECT ..
FROM ...)
UNION
SELECT (...)
Thanks
Venu
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.