How to run query in AS/400?

40 pts.
Tags:
AS/400 database
New user, like to know in detail how to run query in AS/400 with snapshot will be better.

Answer Wiki

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

how do you write use wild card in qry ?  I have flat file length 2000.   I would like to run query  and select 3 fields  Acct # in position 161,  code# in position 1500, and Grade# in position 1550 .   Thanks for your help

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
  • TomLiotta
    What kind of query? What language are you using? What operating system version is installed? What will you do with the query result set -- use it for reporting? for display? for updating? Tom
    125,585 pointsBadges:
    report
  • Shreekant
    Any querry, with SQL language. Version 5.9 for Windows.
    40 pointsBadges:
    report
  • TomLiotta
    You run a query against an AS/400 database on Windows the same way you run a query on Windows against any remote database. You can install a client product that executes queries, or you can write a program, e.g., a VB program, that executes queries through an ODBC connection (or JDBC or ADO or whatever driver connection you can configure). Since you're running Windows, it's not clear what the question is about. Are you wanting to learn how ODBC is used on Windows? (Or JDBC or any other remote database connection technology?) Do you want to know about writing programs on Windows for remote database access? A common way for developers to run basic SQL queries is through the iSeries Navigator "Run SQL Scripts" feature. Are you familiar with iSeries Navigator? Are you a developer? Tom
    125,585 pointsBadges:
    report
  • sudheer794
    for AS/400 - Use WRKQRY command.. (Query/400)..
    315 pointsBadges:
    report
  • TomLiotta
    You should do a Google search on Query 400 and try reading the book first. ...and... for AS/400 - Use WRKQRY command.. (Query/400).. A search for { query 400 } might be useful, though if you had actually run such a search and tried to sift through the results, you would find little to do with SQL. Such a search wouldn't help much. And WRKQRY isn't appropriate. QUERY/400 is not a good tool for those who are familiar with SQL. It's been nearly obsoleted by Query Manager for 20 years or so. WRKQRY is only useful when SQL can't be used or when QUERY/400 was used in the past to create queries that need to be modified. STRQM should be used whenever it's available. AS/400s, iSeries and later systems with the SQL Development product installed should using QM and moving away from any QUERY/400 queries. If QUERY/400 queries already exist, QM can also execute them. Tom
    125,585 pointsBadges:
    report
  • ToddN2000
    Define your work fields.
    WORK1       substr(myfield,161,len)
    WORK2       substr(myfield,1500,len)
    WORK3       substr(myfield,1550,len)

    then on select records
           WORK1             LIKE   '%mychk%'  
    OR     WORK2             LIKE   '%mychk2%' 
    OR     WORK3             LIKE   '%mychk3%'

    For a true wild card use an underscore to replace all wildcard positions like this.

    WORK1  LIKE 'J__n'   will return (John, Jean, Joan, ...)

    8,500 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