You can call this servlet from either a URL or an SSI in an HTML file, and with it you can invoke either a function, SQL statement, or stored procedure.
http://server/servlet/com.ibm.netdata.servlets.FunctionServlet?LANGENV=language& FUNC=function_name&parmn=valuenn
For example:
http://server/servlet/com.ibm.netdata.servlets.FunctionServlet?LANGENV=DTW_REXX&FUNC=custinput.cmd&field1=custno
http://server/servlet/com.ibm.netdata.servlets.FunctionServlet?LANGENV=database_lang& SQL=SQL_statement&parmn=valuenn
For example:
http://server/servlet/com.ibm.netdata.servlets.FunctionServlet?LANGENV=DTW_SQL&SQL=select+lastname+from+customers
http://server/servlet/com.ibm.netdata.servlets.FunctionServlet ?LANGENV=DTW_SQL&FUNC=stored_procedure_name(parameter_list)
For example:
http://server/servlet/com.ibm.netdata.servlets.FunctionServlet ?LANGENV=DTW_SQL&FUNC=myStoredProc(IN+CHAR(20)+"inval")
<servlet code="com.ibm.netdata.servlets.MacroServlet"> <param name="LANGENV" value="language"> <param name="FUNC" value="function_name"> <param name="parmn" value="valuen"> </servlet>
<servlet code="com.ibm.netdata.servlets.MacroServlet"> <param name="LANGENV" value="language"> <param name="SQL" value="SQL_statement"> <param name="parmn" value="valuen"> </servlet>
<servlet code="com.ibm.netdata.servlets.MacroServlet"> <param name="LANGENV" value="language"> <param name="FUNC" value="stored_procedure"> <param name="parmn" value="valuen"> </servlet>
For example:
<servlet code="com.ibm.netdata.servlets.FunctionServlet"> <param name="LANGENV" value="DTW_SQL"> <param name="FUNC" value="myStoredProc(IN CHAR(20) invalue)"> </servlet>