5.11.4 SET

The SET command is used set the title and caption for a HTML table result.

Also, the SET command can be used to set the SQL query and the result set content type.

The SET command can also be used to include HTTP header properties in the HTTP response protocol.

The HTTP property name value pairs are passed as entries in a two-column working list.

The SET command can be called any time before the SEND command that creates the HTTP response.

Syntax:

Command Keyword Value Developer notes SET TITLE value Optional. HTML page title. *NONE Default. CAPTION value Optional. HTML table caption. *NONE Default. HEAD *NONE Optional. Show column header. *LONG Use long names. *SHORT Default. Use short names. QUERY *LIST Optional. SQL query. The list argument contains a large SQL statement. An SQL statement is created by concatenating the list entries and replaces the current query. *NONE   CONTENT *HTML Default is text/html. *CSV   *XML   *TEXTXML   PROPERTY *LIST Conditional. Set HTTP header properties.

Example

SET QUERY(*LIST) #WRKLST(TXT)

 

SET HEAD(*SHORT) TITLE(Report) CAPTION(List of Employees)