-QTY and -LSN adapter commands

The -QTY adapter command is used when fetching data from the database and it specifies the maximum number of rows to fetch from the database. The default value is 1, and the values S means all available rows. The -QTY command must always be accompanied by the -LSN 0 command. The -QTY and -LSN commands are managed automatically when the adapter is utilized in input card in the Design Server web UI. But when the adapter command line is specified directly, the -QTY and -LSN commands must be included in it manually.

When using an API to create or overwrite an input Azure SQL card:

  • When Fetch As is set to Integral mode, set the Fetch Unit to 1 and specify the following commands so that adapter reads and returns all available rows at one time:

    • -QTY 1

    • -LSN 0

    • -ARRAYSIZE 0

  • When Fetch As is set to Burst mode, set the Fetch Unit to 1 and specify the following commands so that adapter reads and returns one row per burst:

    • -QTY S

    • -LSN 0