Re: 5722-ST1 DB2 Query Mgr and SQL DevKit

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

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.