Results 1 to 3 of 3

Thread: Oracle DBexecute from DBQuery

  1. #1
    Contributor
    Join Date
    Apr 2011
    Location
    Copenhagen
    Posts
    140

    Default Oracle DBexecute from DBQuery

    Hi Guys.

    I have this DBQuery that collects some data based on customer phone numbers.
    Now I want to do this using the actual source files as input and use a DBExecute and do a sqlSelect instead.
    I have followed instructions but I get the "SQL command not ended properly" no matter what I do.

    Can anyone tell me what I am doing wrong?
    I am attaching the graph(a bit simplified).

    DBQuery vs DBExecute.brg

  2. #2
    Lavastorm Employee gmullin's Avatar
    Join Date
    May 2014
    Location
    Chicago
    Posts
    159

    Default

    Looks like you're using a library "DB Nodes" that you didn't attach.

    Presuming you're using the Filter node to build up your where clause, you could make the entire query there like this:

    emit "select * from my_table where Numb in (" + ZZ.str() + ")" as query

    And then in DB Execute use: sqlSelect(1,query)

  3. #3
    Contributor
    Join Date
    Apr 2011
    Location
    Copenhagen
    Posts
    140

    Default

    Thanks Gerry.

    I got it to work :-)

    Thomas

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •