I've been using dbxquery connection=my_connection procedure=my_procedure to build reports and a few that my DBAs have built require time inputs, one I'm working on expects parameter '@StartDate', Is there a way to pass that through to the stored proc?
Hi @Kyles,
What version of DBConnect are you using?
The 3.* versions allow you to pass the field named params with values to be passed to the variables in the query/procedure:
dbxquery connection=<string> [fetchsize=<int>] [maxrows=<int>] [timeout=<int>] [shortnames=<bool>] query=<string> OR procedure=<string> [params=<string1,string2>]
Sample query:
dbxquery procedure="{call sakila.test_procedure(?, ?)}" connection="mysql" params="150,BOB"
Please try that out if you are running DBConnect 3.x and let me know how it goes