Oracle DBexecute from DBQuery

[ThomasT]

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

[gmullin]

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)

[ThomasT]

Thanks Gerry.

I got it to work :-)

Thomas