Built-in functions

The section in this chapter on built-in functions describes the SQL functions for administering Real-Time Data Services, and the general format of option strings. See Table 4-2 to see Adaptive Server-specific message properties.

The SQL functions in this chapter:

• Send and receive messages to queues

• Publish, subscribe, and consume messages relating to message topics

• Handle message properties

The functions listed in this chapter, and their page numbers, are:

• msgconsume

• msgpropcount

• msgproplist

• msgpropname

• msgproptype

• msgpropvalue

• msgpublish

• msgrecv

• msgsend

• msgsubscribe

See Reference Manual: Commands for more information on how to use built-in functions in the where clause of a select statement.

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF