Difference between Structured Query and Query in AS/400?

420 pts.
Tags:
AS/400
QRY
SQL
We used STRSQL- FOR START SQL(Structured Query Language) and STRQRY- FOR START QUERY. 

What is the difference between Structured Query and Query? (SQL and QRY)




Software/Hardware used:
software/hardware

Answer Wiki

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

Discuss This Question: 6  Replies

 
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
  • philpl1jb
    You should see a lot of the differences, when you issue the commands. STRQRY - Query/400 is a mature product, limited in scope to reporting data and rather more user friendly (or constricting, depending on your perspective and sense of adventrue).
    49,960 pointsBadges:
    report
  • TomLiotta
    Although Query/400 (STRQRY) is more user-friendly than STRSQL (interactive SQL), the presence of STRSQL on a system indicates that STRQM (QM query) is also available. The 'PROMPT' mode of QM query is very similar to STRQRY.   Also, QM query is a SQL interface where STRQRY is not. That means that newer SQL data types can be processed by QM but not by STRQRY. I.e., newer files might not be available at all for STRQRY.   It also means that QM query can use the SQE while STRQRY is restricted to the CQE. If the database is properly designed, the SQL interfaces will perform better and use less system resources.   Other advantages exist for STRQM over STRQRY. Except for having fewer options, which for some users can make it feel less "complicated", I can't think of a single reason to use STRQRY when STRQM is available.   Tom
    125,585 pointsBadges:
    report
  • WoodEngineer
    You will probably find it easier to format a report for users using Query/400.  By that I mean report headings, column headings, totals and sub-totals.  We find SQL is a great tool for developers who just want to see the data right now and are not worried about format.  These are typically ad hoc listings.
    6,680 pointsBadges:
    report
  • TomLiotta
    You will probably find it easier to format a report for users using Query/400.   Between straight SQL and Query/400, that's true. SQL (itself) doesn't do reports. Some type of "Report Writer" function is needed for that. A minimal default reporting function is supplied as part of STRSQL, but it doesn't include any formatting functions for page headers, page footers, totals, etc.   However, the QM query interface to SQL has a much more sophisticated reporting tool than Query/400. Reports can be created in QM that are effectively not possible with Query/400. As is often true, though, determining whether those are "easier" or not gets foggy when sophistication increases.   Tom
    125,585 pointsBadges:
    report
  • philpl1jb
    And SQL can update, insert, and/or delete record.  It can create stuff (tables, indexes, views).  It can delete (drop) stuff.  And that's just a bit of what SQL can do. 
    49,960 pointsBadges:
    report
  • ToddN2000
    Another benifit I like is when running SQL within operations navagator you can save you results right to an Excel file with the allow save results option. Also you can run CL commands for example CL: CLRPFM DATALIB/PGMS
    11,245 pointsBadges:
    report

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