×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
On 15-Oct-2014 11:09 -0500, Thomas Garvey wrote:
Anyone know how to find out what OS licensed program and feature code
is necessary for OPNQRYF to function on v6 of the OS? <<SNIP>>
That information can be found, by reviewing the output from the
requests of both DSPOBJD and DMPOBJ of the Command object; explained
how, later in my reply, if interested, given the impetus of the inquiry
seems to have changed after some followup replies.
Regardless, I can state definitively in response to the "Subject:"
question, that the Open Query File (OPNQRYF) feature is part of the base
Operating System. Thus the feature is available immediately after the
LIC and OS has been installed. Nothing else is required to be installed
beyond the OS, to use the OPNQRYF feature; no options of the OS, not
even the mandatory option(01) with QSYS2, nor even the QGPL and QUSRSYS
need be installed. Some additional options of the OS could allow the
OPNQRYF to perform [to implement] queries differently than if those
additional options were not installed; e.g. either of the DB2 SMP option
or DB2 MultiSystem might enable the OPNQRYF to perform functions and\or
perform functions with a level of capabilities, that would be
unavailable until the option\feature had been installed.
The Display Object Description (DSPOBJD) for the *SERVICE DETAIL()
information will show that "Licensed program" matches the installed OS.
The OPTION() of the OS is stored as a four-byte character value at
offset x/0084 in the .SERVICE- information of the Dump Object (DMPOBJ)
of the command definition. Perform an F16=Find for the undelimited
string value '.SERVICE-' in the Display Spooled File (DSPSPLF) of the
spooled file QPSRVDMP as the dump output; a few lines of data further
down, the line starting with the undelimited string value two blanks and
'000080' should show EBCDIC hex string that defines the primary National
Language Version (NLV) identifier and the Option identifier, as the
first eight bytes of data:
DMPOBJ QSYS/OPNQRYF *CMD
DSPSPLF QPSRVDMP SPLNBR(*LAST)
/* F16=Find on .SERVICE- will appear much like: */
.SERVICE-
000000 [...]
000020 [...]
[...]
000080 F2F9F2F4 F0F0F0F0 [...]
From the above output, the dumped *CMD object was installed with the
NLV2924 which is USEnglish, and the OPTION(0000) which is identical to
the OPTION(*BASE).
As an Amazon Associate we earn from qualifying purchases.