|
syb_sendmsg()
The
system function
syb_sendmsg()
is a function runable only on the
operating system
Unix.
The function syb_sendmsg() sends a message to the specified
port
of the
User Datagram Protocol (UDP).
To make sending messages via UDB possible, a ein
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 using
syb_sendmsg() over a network. The sole responsibility for all security problems resulting
from using syb_sendmsg() is with the user.
The system function "syb_sendmsg()" is a
T-SQL
extension. It can be executed by any
user,
but only for objects stored in the database currently in use.
Syntax of the System Function syb_sendmsg()
syb_sendmsg(ipaddress, port_number, message)
The parameter 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().
|
