Skip to Content

GETDATE statement in Sender JDBC Channel to read view

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 11, 2015 at 04:55 PM

    >>>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?

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 12, 2015 at 09:01 AM

    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

    Add comment
    10|10000 characters needed characters exceeded