Passthrough Commands

The connector supports commands to http and to IOS. You can use these commands to retrieve a large quantity of data as a single row and column, which can then be processed in your application.

Using HTTP

The connector will accept any type of http command. For example, the following is a valid http passthrough command:

HTTP://www.infor.com

The result will be a single recordset with all HTML source available from the URL formatted as a single row and column. The name of the column will be "RESULT."

Using Lawson Internet Object Services (IOS)

Use Lawson IOS passthrough commands when you want to execute an IOS program that is not directly supported by the connector. The following example runs the IOS program gettokens. Note that the gettokens program is already supported by the connector when you use the agstoken connector command.

passthrough:/cgi-lawson/gettokens.exe?LAWAPP9&AC&OUT=TEXT

The result of this command will be a recordset that contains a single row and column containing the output from the IOS program. The name of the column will be "RESULT."

IOS passthrough commands execute under the IOS security that was established when you logged in to the connector. A recordset with one row and one column will be generated. This recordset contains output from the IOS program. The name of the column is "RESULT."

Replaceable parameters, as described in Replaceable Parameters in Command Strings, are not allowed in passthrough commands.

See "Test-ADO-PassThrough" in Configuring OLE DB Object Services for an example of using passthrough commands.