sa_set_http_header system procedure

Syntax

sa_set_http_header( 
fldname, 
val 
)

Arguments

• fldname – Use this CHAR(128) parameter to specify a string containing the name of one of the HTTP header fields.
• val – Use this LONG VARCHAR parameter to specify the value to which the named parameter should be set. Setting a response header to NULL, effectively removes it.

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 script sets the status code to 404 Not Found:

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

You can create a user-defined status message by specifying a three digit status code with an optional colon-delimited text message. For example, the following script outputs a status code with the message "999 User Code":

CALL sa_set_http_header( '@HttpStatus', '999:User Code' );

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.

The sa_set_http_header procedure always overwrites the existing header value of the header field when called.

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

CALL sa_set_http_header( 'Expires', NULL );

Permissions

None

Side effects

None

Example

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

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