Oracle DBexecute from DBQuery

Follow

Infogix Support

• August 14, 2017 08:48

Originally posted by: 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

0

• 

  Infogix Support

  • August 14, 2017 12:18

  Originally posted by: 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)

  0

  Comment actions Permalink
• 

  Infogix Support

  • August 16, 2017 08:41

  Originally posted by: ThomasT
  
  Thanks Gerry.
  
  I got it to work :-)
  
  Thomas

  0

  Comment actions Permalink

Please sign in to leave a comment.