syb_sendmsg

(UNIX only) Sends a message to a User Datagram Protocol (UDP) port.

Syntax

syb_sendmsg ip_address, port_number, message

Parameters

ip_address – is the IP address of the machine where the UDP application is running.
port_number – is the port number of the UDP port.
message – is the message to send. It can be up to 255 characters in length.

Examples

Example 1 – Sends the message “Hello” to port 3456 at IP address 120.10.20.5:
```
select syb_sendmsg("120.10.20.5", 3456, "Hello")
```

Example 2 – Reads the IP address and port number from a user table, and uses a variable for the message to be sent:

declare @msg varchar(255)
    select @msg = "Message to send"
    select syb_sendmsg (ip_address, portnum, @msg)
    from sendports
    where username = user_name()

Usage

To enable the use of UDP messaging, a System Security Officer must set the configuration parameter allow sendmsg to 1.
No security checks are performed with syb_sendmsg. We strongly recommend that you not use syb_sendmsg to send sensitive information across the network. By enabling this functionality, the user accepts any security problems that result from its use.
For a sample C program that creates a UDP port, see sp_sendmsg.
See also sp_sendmsg in Reference Manual: Procedures

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute syb_sendmsg.