Skip to Content
author's profile photo Former Member
Former Member

JDBC Sender adapter - can VIEW be used in Query statement

Hi,

In JDBC Sender adapter, can we use a VIEW sql query in the "Query SQL Statement" placeholder?

For eg:

CREATE VIEW <view name> as SELECT * from <table name> WHERE <condition>

instead of the usual:

SELECT * from <table name> WHERE <condition>

Thanks,

Vishak

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 04, 2008 at 07:48 PM

    Hi,

    If the view already exists in the Database then we can call that view from here, according to my knowledge we can't create the view from here.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 04, 2008 at 05:51 PM

    Hi

    What exactly is your use of creating a view, if you are going to fetch data from different tables, then you can use the view through stored procedures.

    Hope this clears your doubts

    Thanks

    Saiyog

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      I am not fetching data from different tables nor do I want to use a stored procedure.

      I just wanted to know whether JDBC Sender adapter would allow us to use a CREATE VIEW statement instead of the usual SELECT statement.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.