cancel
Showing results for 
Search instead for 
Did you mean: 

Multiple JDBC Look-up's

Former Member
0 Kudos

HI all,

I have a JDBC look-up that is returning my required value. Is it possible to use that output as an input to another JDBC look up? So basically have multiple look ups. I hear this is a very poor design, but is the an alternative to this?

Thank you very much.

Accepted Solutions (1)

Accepted Solutions (1)

VijayKonam
Active Contributor
0 Kudos

Is it for another database? If not, you might want to consider using an SP on the DB side to execute your logic and return the final design..!! May be a better option.

VJ

Former Member
0 Kudos

Thank you very much

Answers (1)

Answers (1)

Shabarish_Nair
Active Contributor
0 Kudos

Depends on your requirement.

If the lookup is towards two different data base then it is still and option worth considering.

Else as mentioned earlier, it would be best to have a stored procedure that does the complete logic and responds back with the final output.