GET_FIXED_FILE_RECORDS_USED¶
Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex
This command returns the value of DF_FILE_RECORDS_USED if it has been set to a fixed value by SET_FIXED_FILE_RECORDS_USED. If anything greater than or equal to 0 is returned then that is the fixed value returned by any SELECT COUNT(*) statements, internal or not. If something less than zero is returned, then DF_FILE_RECORDS_USED returns a dynamic count whenever it is called.
By default the value of this is -1
Syntax
GET_FILE_RECORDS_USED to {variable}
Parameter |
Description |
|---|---|
variable |
Variable to hold the fixed value |
Example
GET_FIXED_FILE_RECORDS_USED to iRecords