1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

AS/400 Query

Discussion in 'All Other Software' started by mad-martin, Feb 14, 2003.

Thread Status:
Not open for further replies.
Advertisement
  1. mad-martin

    mad-martin Thread Starter

    Joined:
    Jul 5, 2002
    Messages:
    1,309
    Anyone knows where i can find a good site, that discribes the creating of queries in general for the AS/400? I haven't worked with the AS/400 for about a year and a half so it is all a bit rusty, all I remember is that queries make life a lot easier :)

    thanks in advance
     
  2. RSM123

    RSM123

    Joined:
    Aug 1, 2002
    Messages:
    5,531
  3. mad-martin

    mad-martin Thread Starter

    Joined:
    Jul 5, 2002
    Messages:
    1,309
    sure is tnx mate :)
     
  4. Bryan

    Bryan

    Joined:
    Jul 3, 1999
    Messages:
    11,943
    First Name:
    Bryan
    If you have any specific questions about Query/400, let me know and I'll help you.

    And you can get the IBM reference manual online for Query/400. Go <a href=http://publib.boulder.ibm.com/pubs/html/as400/online/v4r4eng.htm> here</a> and click on the link, "Search or View All V4R4 Books". Then in the search box key in SC41-5210-00 and be sure to click on "FIND" just to the Right of the search box, not "Search Books". That will give you access to the online Query/400 manual.
     
  5. fvlmasl2

    fvlmasl2

    Joined:
    Apr 3, 2003
    Messages:
    2
    I am trying to select destinct records from 2 files. 1 file is invoice history and the other is customer history. I need for a given time period to select new customers. So, if i have cutomer number 5 he may have 3 invoices for a given week. What i need is just 1 occurance of the customer for that given week.

    Thanks
     
  6. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/118814

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice