Connect CDC SQData

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.

For more information about Hash Tables, please see the  Connect CDC SQData User Guide.

Category

Specialized

Syntax

HASH_REMOVE(hash_table, hash_key)

 

Parameter Descriptions

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)