AnsweredAssumed Answered

How are parameters named and passed into Command Shapes?

Question asked by justasking on Mar 21, 2018
Latest reply on Mar 22, 2018 by justasking

I'm working on a JDBC connection to Redshift, which is a flavor of PSQL, and passing in 2 parameters. I know the way to reference the parameters in Redshift is to use the ":var_name" syntax (note the colon at the beginning).

Basically, if I have 2 dynamic parameters set in Boomi and pass it into the SQL, what are they called? I've tried referencing with ":1" and ":2" but that hasn't worked.

 

How do I even see the full text being submitted to the database? I'm getting pretty frustrated with the limitations in the logs, as I can't see the query that's being sent.

Outcomes