Operating Condition
Syntax: SET QUALCOLS n
Default: 10
QUALCOLS specifies the number of qualkeys to assign to SQL attached tables.
When attaching external tables by selecting "Utilities" > "Attach SQL Database Tables" from the menu bar, or using the SATTACH command (without the "USING ALL/collist" keywords), the QUALOCOLS setting is used to assign what columns uniquely identifies a row.
If a primary key or unique key was not found for the table being SATTACHed, and the USING collist clause was not used to specify what columns uniquely identifies a row, then R:BASE assigns primary and unique key qualkeys for the attached table. R:BASE assigns a set of columns to identify the rows starting with the first column of the table. The number of columns used is limited by the value for QUALCOLS.
The following command line sets QUALCOLS to 5:
SET QUALCOLS 5
See Also: