Re: What OS feature is OPNQRYF?

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).