Permits a web service to set an HTTP header in the result.

Syntax

sa_set_http_header( 
fldname, 
val 
)

Arguments

Remarks

Setting the special header field @HttpStatus sets the status code returned with the request. The status code is also known as the response code. For example, the following command sets the status code to 404 Not Found.

CALL dbo.sa_set_http_header( '@HttpStatus', '404' );

The body of the error message is inserted automatically. Only valid HTTP error codes can be used. Setting the status to an invalid code causes a SQL error.

With the exception of the Connection response header, response headers generated automatically by the database server can be removed. For example, the following command removes the Expires response header:

CALL dbo.sa_set_http_header( 'Expires', NULL );

Permissions

None

Side effects

None

See also

• SQL Anywhere web services
• HTTP_HEADER function [HTTP]
• -xs server option
• sa_http_header_info system procedure
• sa_http_variable_info system procedure
• sa_set_http_option system procedure
• sa_split_list system procedure
• Web services functions
• Web services system procedures

Example

The following example sets the Content-Type header field to text/html.

CALL dbo.sa_set_http_header( 'Content-Type', 'text/html' );