Troubleshooting
Problem
This document contains resource links regarding encryption with DB2 field procedures.
Resolving The Problem
This document contains resource links regarding encryption with DB2 field procedures.
Several SQL enhancements were added to 7.1.0 IBM i. The encryption can be done at field level by using the DB2 field procedures.
The following article is an excellent resource on Field Procedures:
Enable Transparent Encryption with DB2 Field Procedures - MC Press Article written by Kent Milligan
http://www.mcpressonline.com/index.php?option=com_content&view=article&id=15145&catid=36&Itemid=1179
IBM i 710 Infocenter
General guidelines for writing a field procedure:
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/index.jsp?topic=/sqlp/rbafyfpguidelines.htm
Defining a Field Procedure:
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/index.jsp?topic=/sqlp/rbafyfieldproc.htm
Field Procedure examples:
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/index.jsp?topic=/rzajq/rzajqfieldprocsexamples.htm
Specifying a Field Procedure:
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/index.jsp?topic=/sqlp/rbafyfpspecifying.htm
Using Field Procedures to provide column level encryption:
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/index.jsp?topic=/rzajq/rzajqfieldprocs.htm
When Field Procedures are invoked:
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/index.jsp?topic=/rzajq/rzajqfieldprocs.htm
Example of a Field Procedure example:
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/index.jsp?topic=/sqlp/rbafyfpexample.htm
Field definition for Field Procedure:
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/index.jsp?topic=/sqlp/rbafyfpfielddef.htm
Field Procedure parameter list
http://www.ibm.com/support/knowledgecenter/ssw_ibm_i_71/sqlp/rbafyfpparameterlist.htm
Historical Number
567646494
Was this topic helpful?
Document Information
Modified date:
18 December 2019
UID
nas8N1012119