Setting the key level

If you set the key level, a form query treats a change in key value at the level specified as an End of Set condition. Set the key level to a value between 1 and 16 to have the connector treat a change in key value as an end of set condition. For the KEYLEVEL feature to work properly, the form query must be constructed with the key fields in order of key precedence.

Example:

ags:_TKN=AP10.1&FC=I&VEN-VENDOR-GROUP=120&VEN-VENDOR=100&_ACRW=1

If "_KEYLEVEL=2" is specified, the connector loads records until either VEN-VENDOR-GROUP changes or VEN-VENDOR changes. If "_KEYLEVEL=1" is specified, the connector loads records until VEN-VENDOR-GROUP changes.

To set the key level for a form query

  1. On Query Builder, define the basic form query.
  2. Right-click in the Properties view of the query and select Command Properties.
  3. Expand the Active Command Properties.
  4. Right-click on KeyLevel and select Edit Property Value.
  5. Specify the number for the key level and press Enter.
  6. Click OK.
  7. Click Execute to test the query.