The HASH_REMOVE function removes a row of data from a Hash Table. Hash Tables allow data to be stored in-memory for fast, efficient retrieval during processing. They are most commonly used for lookups to reference data vs selecting data from a relational table in a database.
Category
Specialized
Syntax
HASH_REMOVE(hash_table, hash_key)
Parameters and Descriptions
| Parameter | Description |
|---|---|
| hash_table | The name of a previously declared hash_table. |
| hash_key | This parameter specifies the value that will be compared against the key of the hash_table. The search value may be a field/column of a source datastore, a literal value (i.e. ABC), a variable or the result of another Function. |
Example
Delete a row from hash table H_EMPTBL1 using field EMPNUM as the key.
HASH_REMOVE(H_EMPTBL1, EMPNUM)