|
syb_sendmsg()
The
system function
syb_sendmsg()
is a function only runable on the
operating system
Unix.
The function syb_sendmsg() sends a message to a specified
port
of the
User Datagram Protocol (UDP).
To make sending messages via UDP possible, a
user
with
sso_role
(System Security Officer privileges) must set the
configuration
parameter
"allow sendmsg"
to "1", meaning "on".
Because the system function syb_sendmsg() does not conduct any security checks,
Sybase urgently recommends not to send security relevant data over a network, using
syb_sendmsg(). The responsibility for any problems arising in connection with using
syb_sendmsg(), is solely with the user.
The system function "syb_sendmsg()" is a
T-SQL
extension. It can be executed by any
user,
but only on objects stored in the database currently in use.
Syntax of the System Function syb_sendmsg()
syb_sendmsg(ipaddress, port_number, message)
The parameters of the System Function syb_sendmsg()
"ipaddress"
The parameter "ipaddres" is the address of the machine on which the UDP application runs.
"port_number"
The parameter "port_number" is the number of the UDP
port.
"message"
The parameter "message" contains the message text to be sent.
The length of the message is limited to 255 characters.
Example for the System Function syb_sendmsg()
select syb_sendmsg("192.17.20.10", 3764, "Hallo")
Sends the message "Hello" to port number 3764 at IP-address "192.17.20.10".
See also:
ASE T-SQL - Aggregate Functions,
audit_event_name(),
col_length(),
col_name(),
curunreservedpgs(),
datachange(),
datalength(),
data_pages(),
data_pgs(),
db_id(),
db_name(),
host_id(),
host_name(),
identity(),
index_col(),
index_colorder(),
isnull(),
lct_admin(),
license_enabled(),
lockscheme(),
next_identity(),
object_id(),
object_name(),
pagesize(),
pointer_size(),
ptn_data_pgs(),
reserved_pages(),
reserved_pgs(),
rowcnt(),
row_count(),
showplan_in_xml(),
syb_sendmsg(),
System Functions,
tempdb_id(),
tran_dumpable_status(),
tsequal(),
used_pages(),
used_pgs().
|
