Send information about a character set or sort order to a client.
sp_serverinfo function [name]
Table 4-5 summarizes the legal values for function:
Value |
Meaning |
|---|---|
server_csname |
The name of the character set for the Open Server application will be sent as a one, single column, character row to the client. |
server_soname |
The name of the Open Server application sort order will be sent as one, single column, character row to the client. |
csdefinition |
A row containing the character set definition will be sent to the client. The row consists of three columns: type as a CS_SMALLINT_TYPE, ID as a CS_TINYINT_TYPE, and the character set definition as a CS_IMAGE_TYPE. |
sodefinition |
A row containing the sort order definition will be sent to the client. The row consists of three columns: type as a CS_SMALLINT_TYPE, ID as a CS_TINYINT_TYPE, and the sort order definition as a CS_IMAGE_TYPE. |
The character set or sort order name. name need only be provided if function is set to csdefinition or sodefinition.
The remote procedure sp_serverinfo is automatically registered and handled as a standard system procedure, for example, sp_who. When sp_serverinfo is received as an RPC Open Server handles it automatically. The application code need not be involved.
If a client sends an sp_serverinfo request through a language request, this stored procedure must be executed using the registered procedure routines to send the correct response.
The information is sent to a client as a row.
