The following example illustrates how to access the host parameters used in a web service named ShowTable:

CREATE SERVICE ShowTable 
    TYPE 'RAW'
    AUTHORIZATION ON
    AS CALL ShowTable( :user_name, :table_name );

CREATE PROCEDURE ShowTable(IN username VARCHAR(128), IN tblname VARCHAR(128))
BEGIN
    -- write SQL code utilizing the username and tblname variables here.
END;

Service host parameters are mapped in the declaration order of procedure parameters. In the above example, the user_name and table_name host parameters map to the username and tblname parameters, respectively.

For more information about passing the URL as a host parameter, see How to browse a SQL Anywhere HTTP web server.