Any way to see parameters

------=_Part_18485_24329161.1189544528749
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

We are having some issues in our development shop, and I wanted to know if
there is any way to see the parameters passed in a query in the odbc log. I
have turned debug on, and I am getting a log of all of the queries. I see
the parameters after they are added into the query, but I would like a
listing of each parameter value before the query substitution occurs. Is
there anyway to see this?

Example:
PGAPI_Execute: clear errors...
PGAPI_Execute: copying statement params: trans_status=2, len=75,
stmt='UPDATE CLMCOM1 SET SUBMIT_L_NAME_ORG = ? WHERE INV_NBR = ? AND INV_QFR
= ? '
copy_statement_with_params: from(fcType)=1, to(fSqlType)=1 -- IS THERE
ANYWAY TO SEE THIS PARAM VALUE HERE?
copy_statement_with_params: from(fcType)=4, to(fSqlType)=4 -- IS THERE
ANYWAY TO SEE THIS PARAM VALUE HERE?
copy_statement_with_params: from(fcType)=1, to(fSqlType)=1 -- IS THERE
ANYWAY TO SEE THIS PARAM VALUE HERE?

Thanks,

Chris

------=_Part_18485_24329161.1189544528749
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

We are having some issues in our development shop, and I wanted to know if there is any way to see the parameters passed in a query in the odbc log.  I have turned debug on, and I am getting a log of all of the queries.  I see the parameters after they are added into the query, but I would like a listing of each parameter value before the query substitution occurs.  Is there anyway to see this?


Example:
PGAPI_Execute: clear errors...
PGAPI_Execute: copying statement params: trans_status=2, len=75, stmt='UPDATE CLMCOM1 SET SUBMIT_L_NAME_ORG = ? WHERE INV_NBR = ? AND INV_QFR = ? '
copy_statement_with_params: from(fcType)=1, to(fSqlType)=1  -- IS THERE ANYWAY TO SEE THIS PARAM VALUE HERE?

copy_statement_with_params: from(fcType)=4, to(fSqlType)=4  -- IS THERE ANYWAY TO SEE THIS PARAM VALUE HERE?
copy_statement_with_params: from(fcType)=1, to(fSqlType)=1  -- IS THERE ANYWAY TO SEE THIS PARAM VALUE HERE?


Thanks,

Chris



------=_Part_18485_24329161.1189544528749--

Re: Any way to see parameters

> We are having some issues in our development shop, and I wanted to know if
> there is any way to see the parameters passed in a query in the odbc log. I
> have turned debug on, and I am getting a log of all of the queries. I see
> the parameters after they are added into the query, but I would like a
> listing of each parameter value before the query substitution occurs. Is
> there anyway to see this?

Yes. You can see them in mylog output (it's larger and slow down the
computer).

Regards,

Luf

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate