Drill Around Query Commands

Following is reference information about Drill Around query commands. These options appear on the Drill Around tab of Query Builder. See Creating Drill Around Queries for complete instructions.

Lawson Internet Object Services Namd OLE DB Object Services Screen Name Default Value Description
_URLASCMD OleDB Formatted Drill Command 0 (off) Select this option to specify that the Drill Around URL command be connector-compatible.
_ACAS All Strings 0 (off) Select this option if you want to override data typing and treat all columns in the rowset as strings.
_FAST Fast Mode 0 (off) If you select this option, the connector creates a default schema for the command. The column names will be "COLUMN0" through "COLUMN15." All columns will be data type string.
_CMDTYPE Command Type Servlet Infor Lawson System Foundation Release 9.0 and higher: All queries are to servlets.

IOS Drill Around query parameters

These are parameters that you will typically use when creating Drill Around queries with OLE DB Object Services. Additional information on these parameters is available from Lawson's support web site.

_PDL Data area (or product line)
_TYP Drill type