5.6.1 SERVICE_LOAD
On the SERVICE_LOAD event the service stores the HTTP properties for later access by the GET command.
If there is content, the service checks that the content type is application/x-www-form-urlencoded, if it does not support the content type, then an error is returned to the program. The service determines the encoding to apply to the received content to convert it to Unicode name value pairs and looks for the two reserved names QUERY and CONTENT.
The QUERY name value contains the SQL query to be executed.
The CONTENT name value specifies the format of the SQL result being returned to the client program. The default value for CONTENT is text/html.
- text/csv
- text/html
- text/xml
- application/xml
Syntax:
|
Command |
Keyword |
Value |
Developer notes for Command/Keyword/Value |
|
SERVICE_LOAD |
ENCODING |
|
Optional. See ENCODING. |
Example client HTML:
<HTML>
<BODY>
<FORM METHOD="POST" ACTION="http://lansa01:1099/cgi-bin/jsmdirect?query">
<TEXTAREA NAME="QUERY" ROWS="10" COLS="50">select * from dc@w29</TEXTAREA></BR>
<INPUT NAME="CONTENT" TYPE="TEXT" VALUE="text/html"/>
<INPUT TYPE="SUBMIT" VALUE="Send Query"/>
</FORM>
</BODY>
</HTML>