DB Connect SQL Procedures

Kyles — Mon, 04 Nov 2024 17:25:49 GMT

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?

Re: DB Connect SQL Procedures

victor_menezes — Tue, 01 Apr 2025 02:45:12 GMT

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

topic DB Connect SQL Procedures in Getting Data In

DB Connect SQL Procedures

Re: DB Connect SQL Procedures