NEXT_HTTP_HEADER function [HTTP]

Get the next HTTP header name.

Syntax
NEXT_HTTP_HEADER( header-name )
Parameters

header-name   The name of the previous header. If header-name is NULL, this function returns the name of the first HTTP header.

Returns

LONG VARCHAR

Remarks

This function iterates over the HTTP headers included within a request and returns the next HTTP header name. Calling it with NULL causes it to return the name of the first header. Subsequent headers are retrieved by passing the function the name of the previous header. This function returns NULL when called with the name of the last header, or when not called from a web service.

Calling this function repeatedly returns all the header fields exactly once, but not necessarily in the order they appear in the HTTP request.

See also
Standards and compatibility
  • SQL/2003   Vendor extension.

Example

When used within a stored procedure that is called by an HTTP web service, the following example returns the name of the first HTTP header.

BEGIN
DECLARE header_name LONG VARCHAR;
SET header_name  = NULL;
SET header_name = NEXT_HTTP_HEADER( header_name )
END;