Difference between revisions of "Query"

From MidrangeWiki
Jump to: navigation, search
(new sub-head)
(Query Tips and Techniques)
Line 9: Line 9:
  
 
=== Query Tips and Techniques ===
 
=== Query Tips and Techniques ===
 +
 +
Here are links to "how to" do various things in Query, in which Query is part of the name of the topic, so that other people can use the same name with SQL or RPG or some other 400 tool to get similar results.
 +
 +
* [[Absolute Value via Query]]
 +
* [[Query BPCS]] = a separate "article" page of Query Tips of interest to BPCS users that might not be of interest to the larger 400 community
 +
* [[Date Math in Query]]

Revision as of 12:16, 27 May 2005

Query/400 is a basic user oriented database report writer.

It is designed to allow non-technical users to create basic reports and online inquiries in a simple, menu driven way.

It is a tool that is pretty safe to put into the hands of users, so long as we know how to prevent them from creating an *OUTFILE that gets same name as a pre-existing real file in our data base.

See CLP/400 examples of CLP programs that give people access to Query stuff that can go on a Menu, so that they do not have Command Line Access which has some security concerns.

Query Tips and Techniques

Here are links to "how to" do various things in Query, in which Query is part of the name of the topic, so that other people can use the same name with SQL or RPG or some other 400 tool to get similar results.