Re: AS400 Query vs SQL question

[michael.ellis@xxxxxxxxxxxxxxx]

You can use AS/400 SQL most easily to accomplish what you need.   If you 
are licensed for the IBM SQL Product (don't remember the exact name or 
product number, something like SQL Query Manager/400), you can use the 
STRSQL command and enter your specific command.  If not, then you can 
place your statement in a source member and run the RUNSQLSTM command 
(comes in the operating system).

Also, I have a little utility I wrote that lets me run SQL commands 
interactively even if not license for the SQL product.  It obviously uses 
the source member approach but makes it appear interactive to the user.

Michael G. Ellis
Information Systems International, Inc.
A Global ERP Consulting Firm
815-398-1670 x23
 
Choose ISI consultants to ensure consistently top quality implementation 
services at all levels of your organization.

"To enjoy the things we ought and to hate the things we ought has the 
greatest bearing on excellence of character. "
Aristotle, Nichomachean Ethics