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