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 |