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.
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":
A user defined status text message is not translated into a database character-set when logged using the LogOptions protocol
option.
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: