Re: V7R1 Field Procedures

[David Gibbs <david@xxxxxxxxxxxx>]

On 3/17/2011 7:28 PM, Jon Sinner wrote:
> The boss had decided that he wants to encrypt a couple of fields in
> our customer master file.  I have been reading the SQL programming
> manual and found field procedures which seams to be the process to
> use.  The manual has a sample program written in "C" (I think),
> anyway I don't understand the sample program.
>
> Has anyone written a program that is called as a field procedure and
> if so would you be willing to share the program?

I wrote a very (very) simple fieldproc program when we were adding support for them to Implementer.

The program itself isn't very hard, although doing encryption isn't trivial.

> From what I gathered, talking to some IBMers and other ISV's, Fieldproc program's are intended to be provided by ISV's.

You can find the data structure for the input parameter in QSYSINC/QRPGLESRC,SQLFP

david