How can I tell if I have SQL loaded.

10 pts.
Tags:
AS/400 SQL
STRSQL
V4R5
I am an old AS/400 hack.  I used to be able to start a SQL session by typing in the STRSQL command.  This is not working for me.  Is this the wrong command or is SQL not loaded on this machine?  How do I validate?

Software/Hardware used:
os/400 v4r5

Answer Wiki

Thanks. We'll let you know when a new response is added.

You’ve received good advice on interactively determining if a product is on the system. From a program the correct approach to find if a product (or option of a product) is on the system is to use the Retrieve Product Information API. The API approach is great when writing install exits for a product that has dependencies on another product (or option).

Bruce

============================================================

It could be that you do not have authority to the command. Try WRKOBJ *ALL/STRSQL. If the command is on your system, this will find it.

If you still do not find it try GO LICPGM. Take option 10 and look for :

5722ST1 *COMPATIBLE DB2 Query Mgr and SQL DevKit

I think that this is the licensed program that contains the command.

============================================================

It’s quite possible that GO LICPGM won’t work for you. A better chance is WRKLICINF. The product will be 57xxST1 where xx will change for different versions of i5/OS.

If STRSQL doesn’t work (and doesn’t show as unauthorized), then there’s a good chance that the product isn’t installed. If it’s not installed, it’s unlikely that you have a license for it.

Note that REXX can run SQL. Also, iSeries Navigator has a useful Run SQL Scripts function that can do more than STRSQL can.

Tom

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following