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 user VARCHAR, IN tblname LONG VARCHAR )
BEGIN
    -- write SQL code utilizing the user 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 user and tblname parameters, respectively.

For more information about passing the URL as a host parameter, see Browsing an HTTP web server.