| Author |
Message
|
| abirax |
 Posted: Thu Apr 05, 2007 12:32 am Post subject: Join Statement JDBC Adapter |
 |
|
Newbie
Joined: 17 Aug 2006
Posts: 8
|
Hi ,
Can we fire join statement through JDBC adapter could some one give me some pointers as to how to achieve the same.
Regards |
|
| Back to top |
|
 |
| vk |
| Posted: Thu Apr 05, 2007 4:14 pm Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
Why do you want to do a join? Please elaborate your requirement.
If you just want to SELECT, INSERT, UPDATE or DELETE from more than 1 table, you can achieve the same by using nested BO's.
Regards,
VK. |
|
| Back to top |
|
|
| abirax |
| Posted: Fri Apr 06, 2007 3:43 am Post subject: |
|
|
Newbie
Joined: 17 Aug 2006
Posts: 8
|
Yes Vk its done thanks. Tell me something does anyone have an idea of how to use a function in the where clause thru JDBC adapter.
e.g Upper(Last_name) ='XX' |
|
| Back to top |
|
|
| k_usa |
| Posted: Fri Apr 06, 2007 4:10 pm Post subject: |
|
|
Apprentice
Joined: 14 Aug 2006
Posts: 42
Location: NewJersey
|
I am not sure whether it is possible to do using JDBC adapter.
What i can suggest is to retrieve the result from JDBC adapter into Collab Template and put the filtering logic in the collab template. |
|
| Back to top |
|
|
| venky |
| Posted: Sun Apr 08, 2007 7:25 pm Post subject: |
|
|
Master
Joined: 08 Jul 2003
Posts: 205
|
I think you can acheive this by invoking stored procedures through JDBC adapters.
Venky. |
|
| Back to top |
|
|
| abirax |
| Posted: Sun Apr 08, 2007 11:57 pm Post subject: |
|
|
Newbie
Joined: 17 Aug 2006
Posts: 8
|
For now I did it using CN=Upper(ColName). It worked.
Also guys can u tell me if inner joins is possible using JDBC adapter. nested BO's gives output like outer joins.. I am writing to fire a select clause. |
|
| Back to top |
|
|
|
|
