MBSCAN parameter

From m204wiki
Jump to navigation Jump to search

Max table B records scan


Default value
Parameter type
Where set
By any user
Related products
Model 204 V9.0 or earlier


Whether Model 204 automatically performs a direct search and how many records are searched

For SQL requests and Host Language Interface calls, if MBSCAN is zero, the direct search feature is disabled. If MBSCAN is nonzero, direct searches are always performed.

For User Language, if MBSCAN is -1, all direct searches are performed automatically. If MBSCAN is zero, direct searches are never performed. When MBSCAN is greater than zero, Model 204 counts the records that would have to be searched after the inverted conditions have been evaluated. The count is compared to MBSCAN:

  • If the count is less than or equal to MBSCAN, the search is performed automatically.
  • If the count is greater than MBSCAN, you are told how many records must be searched, and you can choose either to perform the search or to cancel the request. In batch jobs, in application subsystems, or if the value of the PROMPT parameter includes the hexadecimal 10 option, this interaction with you does not happen and the request is canceled.