• IF statement in AS/400 query

    Can I use an if-type statement to return a different value? For example, i thought i would use define results fields to say if(lnt03=34,"advance","payoff") liek I would in excel. of course this doesn't work...

    KPSTL5 pointsBadges:
  • Running AS/400 query in Specific job queue

    Is there a way to restrict user(s) to submit their queries to a specific job queue instead of going into qbatch?

    Msatbh175 pointsBadges:
  • Passing parms to Query400

    Has anyone ever come across a method of passing a parm into a query run - such as a date?

    Abbey120 pointsBadges:
  • Run query on AS/400

    How do I run a query on AS/400?

    dwaynef5 pointsBadges:
  • What program is calling a specific query?

    Is there a way to find out what program(s) are using a specific query?

    Skungy25 pointsBadges:
  • Convert hour in AS/400

    I have a query where the field 'Time' is on hhmmss and I need it only with hhmm. How can I do that?

    SusanaM60 pointsBadges:
  • Rounding values in AS/400

    How do l round up or round down values in a query/AS400?

    Tonchin5 pointsBadges:
  • print 1st 20 records of the file

    I need to dump the 1st record of a file using runqry is this possible

    crasherrider25 pointsBadges:
  • AS/400 Query File Reference

    How would you go about identifying file, field and output references of a group or *all AS/400 queries? I need to be able to identify files where used in queries.

    Modiyooch540 pointsBadges:
  • How many parameters can be used in as400 wrkqry?

    how many parameters can be used in as400 wrkqry

    Urband5 pointsBadges:
  • How to create a sort number in CL or query?

    Hi all, I already create a PF with a field name "NUMBER". I want to fill this Field "NUMBER" with a sort number like 1 2 3 4 5 6 7 Etc . Can anyone help me how to create CL programming to fill the NUMBER field with sort number like 1 2 3 4 Etc . It's almost creating a sort number in Excel . Please...

    indiesrm197315 pointsBadges:
  • Use Wild Card in Query/AS400

    How do you use wild card for the field in flat file in query AS/400. for example I want to display field acct# in position 150 and grade# in position 220 of CustInfor (flatfile)

    Cindytx00720 pointsBadges:
  • LIKE pattern matching in AS/400

    Hi, I have table with one column(ID), values are in the format of '123-456-7890'. Now I need to fetch all the rows from the table whose ID values are of the  same format. I tried to query as Select * from file where ID like ('%___-___-____%'). But no records found. Kindly let me know, how to...

    HABBIE895 pointsBadges:
  • AS/400 Query taking time to execute

    I am having a query which is having 7 inner join One table having record around ==>4770290 And second table with ==>50681241 And other tables have comparatively less records.

    jayshree185 pointsBadges:
  • AS/400 Query Rows

    We have been running a series of queries that create a final report for years. All of a sudden when we run the report, it only has the first 100 rows. Where would I look to see if somehow we have put a limit in one of the queries?

    Tinamh25 pointsBadges:
  • AS/400: How to copy member to new file?

    Hello - I'm unable to query a certain member directly, so I need to make a copy of the member in a file then query that file. How do I copy a member to a new file?

    MattToland25 pointsBadges:
  • AS/400 Query Customers Date of Last Order

    I am trying to create a query that shows the date of a customer's last order but cannot find where the file is located.

    LeslieDonoho25 pointsBadges:
  • OPNQRYF to emulate a joined logical file

    Hello everyone, I'm in a bit of a bind here. Hope you could help me.We have a requirement where we should modify an CLLE program to switch reading a file between two libraries (depending on the entry parameter). This would then be read by a called RPGLE program.Switch 1: Read environment...

    Vsevilod135 pointsBadges:
  • AS/400 Query – do not print report with ‘no records found’

    I am running a query interactively but I don't know how to do it with CL and SQL.

    bnobles125 pointsBadges:
  • AS/400 query select count distinct

    Hello, does someone knows how I can count distinct values on a column via query select? (same as count distinct via SQL)

    WOES9995 pointsBadges:

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.

Thanks! We'll email you when relevant content is added and updated.

Following