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.  Create/insert/drop

    Employee
    Posted 02-14-2017 12:14

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

    Originally posted by: JAWILBUR

    Hello

    Which nodes should I be using to CREATE/INSERT/DROP Teradata database tables?

    Thanks


  • 2.  RE: Create/insert/drop

    Employee
    Posted 02-14-2017 12:34

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

    Originally posted by: stonysmith

    Any such statements need to be in the DbExecute node using the sqlNonSelect operator.

    query="create table myTable ...."
    sqlNonSelect(query)