On 09-Mar-2012 08:51 , Vern Hamberg wrote:
If you do not have any select/omit logicals, you don't need toThe job CCSID must be set to a value other than *HEX [aka 65535] to
change the derived-index item in QAQQINI. You want to look, though,
at the IGNORE_DERIVED_INDEX entry - all the entries are set to
*DEFAULT, what you should do is look at the description in the file.
Use RUNQRY () QAQQINI, DSPPFM doesn't show it, since the description
is in unicode, I think.
enable the RUNQRY to effect any better output than the DSPPFM.
<<SNIP>>The model file [with data] is shipped in QSYS. No file QAQQINI in
Do NOT change the model file that is in QUSRSYS or in QSYS. Make a
copy of the one in QUSRSYS (I think - what you read will tell you)
and modify that.
QUSRSYS should exist normally... and if one does exist in that library,
then the INI options from that file are effectively system values; i.e.
to avoid the global effects, CHGQRYA must be issued to change to use a
The definition of "make a copy" is specifically to issue CRTDUPOBJ
[or save\restore], and must include the triggers; i.e. CPYF or any other
data-only copy that creates the database *FILE named QAQQINI is not
acceptable for creating the INI options file. And although data is
optional, typically DATA(*YES) is desirable on the CRTDUPOBJ as well, to
enable UPDATE versus INSERT for most [i.e. those existing in the model]
INI options and settings.