Re: 5722-ST1 DB2 Query Mgr and SQL DevKit

[rob@xxxxxxxxx]

I've often not received the license keys with the POE packet and have had 
to contact the business partner.  I routinely do a 
DSPLOG PERIOD((*AVAIL *BEGIN)) MSGID(CPI9E75 CPI9E77 CPF9E7D CPF9E72 
CPF9E17)
to look for program products that might have been missed along with a 
WRKLICINF and searching for any *KEYED product with an expiration date.

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 




Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
03/28/2003 09:26 AM
Please respond to Midrange Systems Technical Discussion
 
        To:     Midrange Systems Technical Discussion 
<midrange-l@xxxxxxxxxxxx>
        cc: 
        Fax to: 
        Subject:        Re: 5722-ST1 DB2 Query Mgr and SQL DevKit


You can use WRKLICINF to see what you have. Put a 5 next to this item. 
You're looking for a usage limit of *NOMAX.

Someone should have a red & black (?) striped packet which will contain 
proofs of entitlement (POE). If you have this, you will also have a sheet 
with the license key information. Option 1 of WRKLICINF (or ADDLICINF) 
lets 
you enter this stuff.

If all you need is ad hoc querying, you can do this with query management 
queries (QMQRY). You put an SQL statement into a source member (record 
length = 91), CRTQMQRY to create it, STRQMQRY to run it.

You may also have RUNSQLSTM. This uses a source member with multiple SQL 
statements. You cannot run a SELECT with it, however.

Midrange Computing had a pretty good utility for running any SQL statement 

from a command line (www.midrangecomputing.com), and I thought Buck 
Calabro 
had one - Buck? These are based on QMQRYs with nothing but replacement 
variables. BTW, QMQRYs are the only way to use substitution variables in a 

CL or command line - they'll even use merge variables of Query/400 queries 

as substitution variables.

HTH

Vern

At 04:48 PM 3/27/2003 -0800, you wrote:
>Folks --
>
>The captioned program is installed on my system, but is not functioning
>because no licensing has been setup.
>
>I am fairly new here and did not purchase this system, so I don't know
>for certain what should be on it.  Is this a free licensed program?  Is
>there a convenient way to tell if what programs I am entitled to install
>and use?
>
>Thanks.


_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.