Recently switched from native Sybase driver to ODBC. When a stored procedure is executed, sqlPreview in SQLCA shows "?" (question marks) in place of variable values. (I am connecting to database with DisableBind=1,StaticBind=0 in dbParm.)
Declaration/execution is as follows (all variables have non-null values):
declare updateThis procedure for update_this
@suser_id = :ll_sUserID,
@spid = :ll_spid,
@history_date = :adt_historyDate ;
execute updateThis ;
SQL generated is:
execute update_this @suser_id =? , @spid =? , @history_date =?
This worked perfectly under native driver.