I am trying to execute a stored procedure in a Sybase database, but am not having much luck. This is my first experience using remote data sources and am strugling my way through it. The following is the basics of what I am doing:
* open database
open data ..\data\unemploy
* create a connection
create connection mconnect datasource 'Sybase System 10' userid 'xxxx' password '*****'
* save the connection handle
xhandle=sqlconnect('mconnect')
* set some variables for the query
bdate = '01/01/1997'
edate = '01/31/1997'
* run the stored procedure
xexec=sqlexec(xhandle,"{CALL p_sui_extract ('"+bdate+"', '"+edate+"')}",'cdrdata')
The 'cdrdata' is the result cursor I am trying to create. xexec always returns -1 indicating some type of error.
Any help would be greatly appreciated!
Mark Johns