| Support |
| Site Admin |
|
| |
| Joined: 12 Mar 2004 |
| Posts: 370 |
| Location: Omaha, NE |
|
|
|
 |
|
 |
|
Here are some examples of the Function calls
Example of the EncFld
UPDATE TESTLIB/CREDITCRD SET ENCRYPTED = F_ENCFLD('CRED', '1234567890123456')
Example of the DecFld
UPDATE TESTLIB/CREDITCRD SET ENCRYPTED = F_DECFLD('CRED', ENCRYPTED)
Example of the Update with a numeric field
UPDATE TESTLIB/CREDITCRD SET VALUE = F_UPDENCFLD('VALUE', VALUE, '33333') WHERE CRED = 'yyy'
Example of the Update with a character field
UPDATE TESTLIB/CREDITCRD SET TEST20 = F_UPDENCFLDCHR('TEST20', TEST20, 'ABCDE')
Example of the Insert with a numeric field
INSERT INTO TESTLIB/CREDITCRD (VALUE) VALUES ( F_INSENCFLD('VALUE', '55000') )
Example of the Insert with a character field
INSERT INTO TESTLIB/CREDITCRD (TEST20) VALUES ( F_INSENCFLDCHR('TEST20', 'ABCDE') )
Example of the Get with a numeric field
SELECT F_GETENCFLD('VALUE', VALUE) FROM TESTLIB/CREDITCRD WHERE VALUE = 12
Example of the Get with a character field
SELECT F_GETENCFLDCHR('TEST20', TEST20) FROM TESTLIB/CREDITCRD WHERE TEST20 = '9'
Example of the Delete with a numeric field
DELETE from TESTLIB/CREDITCRD WHERE VALUE = F_DLTENCFLD('VALUE', 10)
Example of the Delete with a character field
DELETE FROM TESTLIB/CREDITCRD WHERE TEST20 = F_DLTENCFLDCHR('TEST20', '16 ')
or
DELETE FROM TESTLIB/CREDITCRD WHERE TEST20 = F_DLTENCFLDCHR('TEST20', TEST20) AND CRED = ' ' |
|
