5.11.1 SERVICE_LOAD

Loads and initializes the service.

Syntax:

Command

Keyword

Value

Developer notes

SERVICE_LOAD

SERVICE

HTTPInboundQueryService

 

TRACE

 

Refer to Service Load Tracing for value details.

TRACE_NAME

 

TRACE_GROUP

 

BIND

 

Optional. See BIND.

ENCODING

 

Optional. See ENCODING.

 

Associated Service Properties File

Properties that affect the operation of service are loaded from the HTTPInboundQueryService.properties file.

Example

SERVICE_LOAD SERVICE(HTTPInboundQueryService) TRACE(*YES)

 

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.

Example client HTML:

 

<HTML>

<BODY>

<FORM METHOD="POST" ACTION="http://server1:1099/cgi-bin/jsmdirect?service=query">

 

<TEXTAREA NAME="QUERY" ROWS="10" COLS="50">select * from [email protected]</TEXTAREA></BR>

<INPUT NAME="CONTENT" TYPE="TEXT" VALUE="text/html"/>

<INPUT TYPE="SUBMIT" VALUE="Send Query"/>

 

</FORM>

</BODY>

</HTML>