UDFs for FPE
The following table lists the UDFs for FPE. These UDFs are categorized by data type:
CHAR
| Data Type | Function | Action |
|---|---|---|
| CHAR | ing_e_chr_fcl | encrypt |
| CHAR | ing_e_chr_fnm | encrypt |
| CHAR | ing_e_chr_cl_fdb420 | encrypt |
| CHAR | ing_e_chr_nm_fds420 | encrypt |
| CHAR | ing_d_chr_fcl | decrypt |
| CHAR | ing_d_chr_fnm | decrypt |
| CHAR | ing_d_chr_cl_fdb420 | decrypt |
| CHAR | ing_d_chr_nm_fds420 | decrypt |
NCHAR
| Data Type | Function | Action |
|---|---|---|
| NCHAR | ing_e_ncr_cl_fdb420 | encrypt |
| NCHAR | ing_e_ncr_nm_fds420 | encrypt |
| NCHAR | ing_d_ncr_cl_fdb420 | decrypt |
| NCHAR | ing_d_ncr_nm_fds420 | decrypt |
INT
| Data Type | Function | Action |
|---|---|---|
| INT | ing_e_int_fcl | encrypt |
| INT | ing_e_int_fnm | encrypt |
| INT | ing_e_int_cl_fdb420 | encrypt |
| INT | ing_e_int_nm_fds420 | encrypt |
| INT | ing_d_int_fcl | decrypt |
| INT | ing_d_int_fnm | decrypt |
| INT | ing_d_int_cl_fdb420 | decrypt |
| INT | ing_d_int_nm_fds420 | decrypt |
BIGINT
| Data Type | Function | Action |
|---|---|---|
| BIGINT | ing_e_bin_fcl | encrypt |
| BIGINT | ing_e_bin_fnm | encrypt |
| BIGINT | ing_e_bin_cl_fdb420 | encrypt |
| BIGINT | ing_e_bin_nm_fds420 | encrypt |
| BIGINT | ing_d_bin_fcl | decrypt |
| BIGINT | ing_d_bin_fnm | decrypt |
| BIGINT | ing_d_bin_cl_fdb420 | decrypt |
| BIGINT | ing_d_bin_nm_fds420 | decrypt |
NVARCHAR
| Data Type | Function | Action |
|---|---|---|
| NVARCHAR | ing_e_nvc_cl_fdb420 | encrypt |
| NVARCHAR | ing_e_nvc_nm_fds420 | encrypt |
| NVARCHAR | ing_d_nvc_cl_fdb420 | decrypt |
| NVARCHAR | ing_d_nvc_nm_fds420 | decrypt |
VARCHAR
| Data Type | Function | Action |
|---|---|---|
| VARCHAR | ing_e_vrc_fcl | encrypt |
| VARCHAR | ing_e_vrc_fnm | encrypt |
| VARCHAR | ing_e_vrc_cl_fdb420 | encrypt |
| VARCHAR | ing_e_vrc_nm_fds420 | encrypt |
| VARCHAR | ing_d_vrc_fcl | decrypt |
| VARCHAR | ing_d_vrc_fnm | decrypt |
| VARCHAR | ing_d_vrc_cl_fdb420 | decrypt |
| VARCHAR | ing_d_vrc_nm_fds420 | decrypt |
