Modifying Drill Around Query Command Properties

Use this procedure to set the command properties for Drill Around queries. You can set these properties at the global level, the level of all Drill Around queries, or the level of an individual query or command.

  • Global

    Property Description
    Use Default DataArea Queries will always be run against the user's default data area. The default data area is assigned in the user's Resource Management Information in the Lawson Security Administrator. Users who have access to other data areas can select them at query specification time.
    Show All Users Show all users (such as for reports) in the Query Builder.

  • Form Query Properties (AGS)

    Option name Selection
    All Strings Controls whether all retrieved data is treated as strings. Use of this parameter may lead to a performance improvement, but only use if you do not need to maintain the data types of the data.
    OleDB Formatted Drill Command Select this option to specify that the Drill Around URL command be connector-compatible.
    Fast Mode If this option is selected, the connector makes up a default schema for the command. The column names will be "COLUMN0" through "COLUMN15." All columns will be of the string data type.
    Command Type Infor Lawson System Foundation Release 9.0 and above: All queries are to servlets.

  • Active Command Properties (Form Query)

    Option name Selection
    All Strings Controls whether all retrieved data is treated as strings. Use of this parameter may lead to a performance improvement, but only use if you do not need to maintain the data types of the data.
    OleDB Formatted Drill Command Select this option to specify that the Drill Around URL command be connector-compatible.
    Fast Mode If this option is selected, the connector makes up a default schema for the command. The column names will be "COLUMN0" through "COLUMN15." All columns will be of the string data type.
    Command Type Infor Lawson System Foundation Release 9.0 and above: All queries are to servlets.

To modify Drill Around query command properties

  1. Define the basic Drill Around.
  2. Right-click in the Query pane when the query properties are displayed. (Click Properties if necessary to display the query properties.)
  3. Select Command Properties. The User Preferences windows appears.
  4. Click the plus sign for the level of command properties you want to modify.
  5. Right-click on the property you want to modify and select Edit Property Value.
  6. Select a value, or type a value and press Enter.

    If you are modifying the active command properties, the query string is modified to reflect your changes.

  7. Modify additional properties if you need to.
  8. Close the User Preferences window.

Additional Information for Drill Around Options

It is not possible for the connector to determine the schema for a Drill Around query command (that is, a Drill Around call to IOS) from Lawson system metadata. Therefore, the connector can either represent an Drill Around query command by using a predetermined schema or it can execute the Drill Around query command (requesting only one row of data) to determine the schema from the result of executing the command.

If fast mode is TRUE, the connector does not do the schema determination Drill Around query call. This will execute faster, and you will be guaranteed to have the default schema information even if the Drill Around query call fails because there isn't any data. However, the default schema is a URLCMD column and columns "COLUMN0" through "COLUMN15," and the data type for all of the columns will be string.

If fast mode is FALSE, the connector tries to make a Drill Around query call (requesting only one row of data) and uses the result of the Drill Around query call to determine the schema. This takes a little more time to make the extra request to IOS. Also, if the Drill Around query call doesn't return any data or fails for any other reason, the consumer must be prepared to not have schema information as well as be unable to execute the command.

If you use replaceable parameters with the Drill Around query call, you will be in fast mode, because the connector cannot execute the Drill Around query call until the parameter values are supplied, and parameter values are not supplied until after the consumer has already requested schema information. See Replaceable Parameters in Command Strings for more information.