-
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
-
Lavastorm Employee
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)
-
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
-
Forum Rules