RTI_Bitmap_Index_Search function
Description
The RTI_BITMAP_INDEX_SEARCH function searches a bitmap index to return the set of keys whose values which match the search criteria.
Syntax
RTI_BITMAP_INDEX_SEARCH( tableName, columnName, searchType, searchVals )
Parameters
| Parameter | Type | Description |
|---|---|---|
| tableName | In | Name of the table to search. Required. |
| columnNane | In | Name of the index column. Required. |
| searchType | In | Type of search to perform. This can be one of the following values: “AND” "OR" |
| searchVals | In | @vm delimited list of terms to search for. |
Returns
@vm delimited list of keys that match the search query. Errors are returned via Set_Status
Example
Function test_rti_bitmap_search(void)
/*
** Example of using RTI_BITMAP_SEARCH
*/
Declare Function RTI_BITMAP_INDEX_SEARCH
* filename is Name of the indexed table
filename = "UTF8_WORDS"
* fieldname is Name of the indexed column
fieldname = "NON_ASCII_LEN"
* searchtype can one of "OR", "AND", defaults to "OR"
searchType = "OR"
* Searchvals is VM delimited list
* Exact match only. Qualifiers such starting with, contains, from...to are not supported.
item1 = "96"
item2 = "71"
searchVals = item1:@vm:item2
* returns vm delimited list of keys
hits = RTI_BITMAP_INDEX_SEARCH(filename, fieldname, searchType, searchVals)
this_cnt = dcount(hits, @vm)
Return hits