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. In order 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 will load records until either VEN-VENDOR-GROUP changes or VEN-VENDOR changes. If "_KEYLEVEL=1" is specified, the connector will load records until VEN-VENDOR-GROUP changes.

To set the key level for a form query

  1. 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. Enter the number for the key level, press Enter, and click OK.
  6. Click Execute to test the query.