Re: SQL Triggers where Production and Test on Same iSeries

[Michael Schutte <mschutte369@xxxxxxxxx>]

Okay thanks Rob,  I may go this route in the future, however, at the moment
I have SQL triggers and would like to resolve this issue without having to
make changes to the production code.  Boss probably wouldn't approve to go
back and redo.


On Wed, Apr 10, 2013 at 2:05 PM, <rob@xxxxxxxxx> wrote:

> Of course they still give you all the minutiae of details:
>
> Journal  . . . . . . :   QSQJRN          Library  . . . . . . : ROB130410
>
> Sequence . . . . . . :   29
> Code . . . . . . . . :   R  - Operation on specific record
> Type . . . . . . . . :   UP - Update, after-image
>
> Object . . . . . . . :   TEST
>   Library  . . . . . :     ROB130410
>   Member . . . . . . :     TEST
>   Type . . . . . . . :     *QDDS
> Date . . . . . . . . :   04/10/13
> Time . . . . . . . . :   13:55:48
> Flag . . . . . . . . :   0
> Count/RRN  . . . . . :   1
> Commit cycle ID  . . :   0
> Nested commit level  :   0
> Job  . . . . . . . . :   347321/ROB/ROBS1
> User profile . . . . :   ROB
> Ignore APY/RMV . . . :   No
> Ref constraint . . . :   No
> Trigger  . . . . . . :   No
> Program  . . . . . . :   QCMD
>   Library  . . . . . :     *OMITTED
>   ASP device . . . . :     *OMITTED
> System sequence  . . :   0
> Thread identifier  . :   *OMITTED
> Receiver . . . . . . :   QSQJRN0001
>   Library  . . . . . :     ROB130410
>   ASP device . . . . :     *SYSBAS
> Journal identifier . :   X'EBF0000855FF4E2A0005'
> Remote address . . . :   *OMITTED
> Address family . . . :   *OMITTED
> Remote port  . . . . :   0
> System name  . . . . :   GDISYS
> Arm number . . . . . :   6
> Logical unit of work :   *OMITTED
> Transaction ID . . . :   *OMITTED
>
> You can, of course, get more details.  From the help
> The remote address will have the value *OMITTED if receiver size
> option (RCVSIZOPT) *MINFIXLEN was in effect for the journal when the
> entry was deposited or if the fixed length data option (FIXLENDTA)
> in effect at the time the entry was deposited would have omitted
> this data.  The value will also be *OMITTED if the journal entry was
> not deposited on behalf of a remote client.
>
>
> Rob Berendt
> --
> IBM Certified System Administrator - IBM i 6.1
> Group Dekko
> Dept 1600
> Mail to:  2505 Dekko Drive
>           Garrett, IN 46738
> Ship to:  Dock 108
>           6928N 400E
>           Kendallville, IN 46755
> http://www.dekko.com
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.