Database Query Commands
Following is reference information about database query commands. Creating Database Queries
| OLE DB Object Services Internal Name | Screen Name | Default Values | Description |
|---|---|---|---|
| ACAS | All Strings | 0 (off) | Select this option if you want to override data typing and treat all columns in the rowset as strings. |
| OTM | One To Many Query type | 0 (off) | Select this option if you want to use hierarchical recordset feature. If you have specified a DME command that will generate one-to-many output, this option will give you a hierarchical rowset where each row in the parent recordset will have columns that represent child recordsets. |
|
1 (hierarchical recordset) |
Select this option if you want to use the hierarchical recordset feature. If you have specified a Database command that will generate one-to-many output, using this option will give you a hierarchical rowset where each row in the parent recordset will have columns that represent child recordsets. | ||
|
2 (flat recordset) |
OTM Flat Recordset: Select this option if you want to use the flat recordset feature. A flat recordset does not distinguish between parent and child recordsets. Parent recordsets are repeated in a child recordset. Use this method of retrieving data if your reporting tool, such as Crystal Reports, requires it. | ||
| OTMMAX | One To Many Max | 25 | Maximum number of related records to return in an OTM query. |
| OTMNEXT | One To Many Next | 0 (off) | Use this option in conjunction with the One To Many option if you want your output to include an additional column in the parent recordset for each child recordset. The additional columns will contain the Database command to retrieve the next set of child rows. |
| FSZ | PageSize | 1000 | Sets the number of rows per fetch from the Lawson application server. |
| _CMDTYPE | Command Type | Servlet | Infor Lawson System Foundation Release 9.0 and higher: All queries are to servlets. |
| NOIROWLOCATE | Disable IRowLocate Interface | N/A | Disable the row locate interface, which can make some queries that will be run with Crystal Reports process more efficiently. To use this parameter, just include it as a parameter in the query. For example, dme:PROD=LOGAN&FILE=VERSION &NOIROWLOCATE&FIELD=CYCLICAL |
|
IOS database query parameters These are parameters that you will typically use when creating database queries with OLE DB Object Services. |
|||
| PROD | Data area or product line | ||
| FILE | Table name | ||
| FIELD | Returned field list, separated by semi-colons | ||
| PREV | Reverse query direction | ||
| INDEX | Index name | ||
| KEY | Index key values | ||
| COND | Filter returned records by condition name | ||
| SELECT | Filter returned records | ||