LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Multiple SQL statements in a JDBC/DB Execute node

    Employee
    Posted 08-22-2013 21:25

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: gihans

    Hi ,

    I'm just wondering if it's possible to run multiple SQL statements in a single JDBC/DB Execute node ? For example, 2 drop table queries or drop table query followed by a create table query.

    Thanks,
    Gihan


  • 2.  RE: Multiple SQL statements in a JDBC/DB Execute node

    Employee
    Posted 08-23-2013 07:49

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: stonysmith

    Yes. You can even mix the types..

    sqlNonSelect(".....")
    sqlSelect(".....")
    sqlNonSelect(".....")


  • 3.  RE: Multiple SQL statements in a JDBC/DB Execute node

    Employee
    Posted 08-23-2013 07:56

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: ejones

    Yes for DB Execute. But not for the JDBC nodes. Since the DB Execute node supports ODBC there is likely a way to use the DB Execute node for most (all?) databases. And expressing the desire for the JDBC nodes to do this will increase the likelihood that this gets feature gets added someday.


  • 4.  RE: Multiple SQL statements in a JDBC/DB Execute node

    Employee
    Posted 08-26-2013 17:45

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: gihans

    Thanks guys.
    It'll be really useful if this functionality can be available for JDBC Execute node as well, as I mostly use the JDBC node.