MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » October 2012

Re: SQL and trigger s



fixed

The message
Member BSYSQSP2 in SECWRK not journaled to journal *N.
BSYSQSP2 not valid for operation.
can be resolved by either
RUNSQLSTM ... COMMIT(*NONE)
or by adding WITH NC to the end of your sql statement.

Can you recreate the test environment (aka re add the deleted rows) and
see if
SELECT ...
FROM SECWRK/BSYSQSP2
WHERE QSSEC2 <> '@ADR' AND
QSFN01 = 'BOC151' AND QSSW01 = 'E'
returns rows?

Rob Berendt





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact