STORE command in Dataquery online fails with
DQ027E - REQUEST FAILED DUE TO SYSTEM ERROR - DB RETURN 94 (170) QEXEI
after upgrade to Datacom version 12.0
Release: Datacom
With Datacom 12.0 and beyond, any database being used with SQL Data Definition Language (DDL) statements needs to be optimized in Multi-User (meaning ACCESS NOOPT can NOT be coded for this DBID).
This is a requirement as documented in APAR RI23671. Internally for this STORE command an EXEC SQL CREATE TABLE is executed. This is a DDL statement resulting in a Datacom return code 94 (170) when the database is not optimized in Multi-User.
Remove the DBID from ACCESS NOOPT in the Multi-User startup cards .