GETDATE statement in Sender JDBC Channel to read view

[harish_babu5]

Hi

I have a database to poll. They will not give database access. I have to read from the "view", and that has to be read every fifteen minutes. Can I use GETDATE function to read Data from View. I want to avoid duplication of records too

Regards

Harish

[harish_babu5]

Hi everyone,

Is it possible to take all fields updated in the last twenty four hours from a Database View? It should not take fields updated bfore that.

We don't have an UPATE field here

Regards

Harish

[former_member184720]

>>>Can I use GETDATE function to read Data from View

i think you should be able to.

Like any select statement you just need to add this condition under where logic.

select * from view where your fieldname > getdate()

>>> I want to avoid duplication of records too

i don't know if you can update the tables using the same view that you used to fetch the record.

Do you know how is your view defined in database?

[harish_babu5]

Hi Hareesh

The "View" doesn't have update access

Regards

Harish