Skip to Content
0
Former Member
Mar 02, 2009 at 07:33 PM

JDBC sender adapter ==> advanced questions

29 Views

Hi Expert,

basically I want to query a database VIEW to pull data, can you please answer my questions:

1) Can I specify variable in the select statement like select * from myView where createTime<today and flag="true"? today is a variable for today's date. Or some other variable we can define in PI?

2) Since generally view is not updatable, so what I should enter in the update statement? Let's say the view is based on three tables, one table named TableA has the field flag. So I guess I can update the flag directly in the TableA. However how can I make sure the the records created between the select and the update are not marked as false? I know if select and update is made to the same table, PI would make sure the update will be done on the sames records resulted from the select. However in my case, select is done on view while update is done on table. How can I be sure the flag is changes only for he processed records?

3) In my scenario, I need to initially load 100mb data from JDBC adapter, would it be problem with this hug amount of data in the JDCB CC?

Thanks