This section describes the SQL interfaces for retrieving a query band and parsing the query band string for name and value pairs. The SQL interfaces consist of UDFs and external stored procedures that you can invoke from any application.
Query band external stored procedures run on the PE and can retrieve query bands directly from memory. Query band functions run on the AMPs and require message passing to retrieve the query band. The external stored procedures provide better performance than query band functions.
You need not qualify query band UDFs with the database name. The DBS searches the SYSLIB database.
You must qualify query band external stored procedures with the database name SYSLIB.
For examples of query band functions and external stored procedures, see the following topics.