Register FAQ Memberlist Search Linoma Software Forum Index

Linoma Software Forum Index -> Crypto Complete -> Examples of Function calls
This forum is locked: you cannot post, reply to, or edit topics.  This topic is locked: you cannot edit posts or make replies. View previous topic :: View next topic 
Examples of Function calls
PostPosted: 01/02/08 03:21:32 PM Reply with quote
Support
Site Admin
 
Joined: 12 Mar 2004
Posts: 378
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 = ' '
View user's profile Send private message Send e-mail Visit poster's website
Examples of Function calls
  Linoma Software Forum Index -> Crypto Complete
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
All times are GMT - 6 Hours  
Page 1 of 1  

  
  
 This forum is locked: you cannot post, reply to, or edit topics.  This topic is locked: you cannot edit posts or make replies.  



Powered by phpBB 2.0.6 © 2001-2003 phpBB Group Style created by Vjacheslav Trushkin