Re: PF Trigger question

[Peter Dow <petercdow@xxxxxxxxx>]

Hi Rob,

Instead of the FTP "put" command, "append" will add a record to the 
target file.

--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx <mailto:petercdow@xxxxxxxxx>
pdow@xxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxx>/

On 3/26/2013 4:51 AM, rob@xxxxxxxxx wrote:
> First of all, how does FTP insert a single row?  I can see how ODBC, etc;
> but FTP?  FTP should be able to put a single row table up on your IBM i.
> But would that table still include the trigger or would all definitions of
> the table now be changed?  Or does the (REPLACE option on ftp allow this?
>
> One thing to consider is not adding a new row, nor updating this row after
> it's written, but instead intercepting this row before it's written.
> Triggers allow that.  ADDPFTRG ... ALWREPCHG(*YES).  That ALWREPCHG(*YES)
> is the key to interception.  Then you can take buffer of the row, before
> it's written to disk, and modify the contents.  Before IBM added "row
> change timestamp" and other such capabilities to the database this was a
> common use of triggers.
>
> Rob Berendt