• AS/400 Query file

    We have updated a couple of fields in our system, which are contained in many files. We also have batch jobs that run queries. Is there anyway around having to change each query individually so they don't stop processing because of errors?

    gdrehfal5 pointsBadges:
  • AS400 – Queries

    Hi I have one query Which is a join of table A and Table B. select store,sum(amt) from table A and table B where A.fld1 = B.fld1 A.fld2 = B.fld2 A.fld3 = b.fld3 AND A.fld3 between date range group by Store order by store. I need to run this query in a batch mode,just by changing the date range.how...

    iiiiiiiiiiiii335 pointsBadges:
  • AS/400 query: Extract character between two characters

    Is there a way to extract the number of character between 2 chars? I need to extract email addresses that are between <....@...> in a field that is 228 bytes long.

    nsmartello5 pointsBadges:
  • 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?

    Msatbh185 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.

    Modiyooch760 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:

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