|
WSupported on Windows
|
USupported on Unix
|
VSupported on OpenVMS
|
NSupported in Synergy .NET
|
value = %SSC_GETEMSG(dbchannel, msg, len, [row_count][, errno])
Return value
value
This function returns SSQL_NORMAL (success) or SSQL_FAILURE (failure). (i)
Arguments
dbchannel
An internal database channel previously initialized using %SSC_INIT. (a)
msg
Returned with the extended error message. This argument has a maximum size of 1024. (a)
len
Returned with the length of the error message. (n)
row_count
(optional) Returned count of rows affected in the last call to %SSC_EXECUTE, %SSC_MOVE, or %SSC_EXECIO. This count is valid only when value is returned as SSQL_NORMAL. (n)
errno
(optional) Returned with the last database-specific error number. If this number is negative, it’s probably a Vortex API error message (see Vortex API error messages). (n)
Discussion
%SSC_GETEMSG returns Vortex API, SQL OpenNet, socket, database errors, and if you’re using an ODBC database driver (VTX11 or VTX12_SQLNATIVE), ODBC Driver Manager warnings and errors. (It doesn’t, however, return Synergy runtime errors. You’ll need to trap Synergy runtime errors in your program—see Trapping runtime errors—and you’ll need to use Vortex API logging to view socket errors.)
Some databases return multiple message lines for %SSC_GETEMSG. These lines are separated by the null character (%char(0)). For an example of message decoding, see printmsg.dbl. (You’ll find this file in the connect\synsqlx subdirectory of the main Synergy/DE installation directory.)
Examples
The following code segment displays a connection failure error message.
if (%ssc_connect(dbchn, user)) goto err_exit . . . err_exit, sts = %ssc_getemsg(dbchn, msg, len) if (len) writes(1, msg(1,len)) else writes(1, "No error message available.")
