LAE

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

Originally posted by: awilliams

With DB Execute we can do the following to pass a constructed SQL statement into the node:

Do we have a way to do this within JDBC nodes? It seems the only option we have is to use parametrized SQL, which can't accepted parametrized table names.

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

Originally posted by: rboccuzzi

That is correct, the current DB nodes do have that extra functionality. It is a trade off in design between those two sets of nodes, in that those nodes require BRAINscript and are slightly more complicated to use, but offer additional functionality, compared with the simpler JDBC nodes.

A way to work around this would be to place the JDBC node in a sub-graph and execute using Execute BRX, which can provide the content to the JDBC node dynamically. The results of the JDBC node can be output to files or appended to a file, and then the top graph can use the resulting data.

Cheers
Rich

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

Originally posted by: awilliams

Aha! That was the missing piece I was looking for. Thanks a lot.