• How many parameters can be used in as400 wrkqry?

    how many parameters can be used in as400 wrkqry

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

    HABBIE820 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:
  • 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:
  • AS/400 query security

    I have a library we will call liba. In liba i have files for different companies. For eg: files aa01.itm is an inventory file for co# 01 and bb01.cms is a customer file for co# 01. I also have files aa07.itm and bb07.cms. These files are for co# 07.I want to grant someone access to only the files...

    Lougoalie5 pointsBadges:
  • Library compare between 2 library lists using Query

    I have to lists of libraries on the same system as PFs. Using query, I want to see what libraries are not on one system, but on the other and vis-virus and generate a report. Can you offer solution? The two library lists come from two different systems.  I FTP'd the one file over to another so...

    northwoods180 pointsBadges:
  • Find # days between 2 dates in Query 400

    I have never used this function but it looks like the startdate and enddate must be alpha expressions for this to work. Is that correct?

    Abbey120 pointsBadges:
  • Find # days between 2 dates in a AS/400 query

    How do I find the # of days between 2 dates. I'm trying to do this in AS/400 Query 400. I'm looking to do this in the Results area where you do calculations. Can anyone help??? Thanks!!!!!

    Pherrick20 pointsBadges:
  • Multiple record retrieval

    If a single key like student id has multiple records like many subjects. While trying to update the subjects, how do I retrieve multiple values from a single key field?

    harshaanklikar5 pointsBadges:
  • Query selected data convert into XML file in AS/400

    I have 5 PF. Now I want to select data from my PF and selected data need to convert into XML. Please give me guidelines, how do I do a step-by-step?

    madhuchowdary350 pointsBadges:
  • AS/400 via Access, update query

    Hi all, My DB is on AS/400 and I use Microsoft Access to run queries. However, whenever I try to run an update query, I receive the following error message: "[IBM][ISeries Access ODBC Driver][DB2 UDB]SQL7008 - table in library not valid for operation. (#-7008)" Any idea what is missing? Thanks in...

    Antser5 pointsBadges:
  • Query

    Hi Team, I have scenario with me. For that I need to create a query. The scenario is as follows: When My Location And Department is equal in the file I want to Multiply Quantity Column with Cost Column and Add it. Loc Dept Quantity Cost 1 10 10 2 1 10 10 3 1 10 11 5 2 10 10 7 For above example in...

    ankit2002770 pointsBadges:
  • AS/400 Query: Current Date

    Is there a quick way of running a query to select records based on current sysdate. I know you can get current date using Current command but I can't use it in selection.

    Gerrib150 pointsBadges:
  • AS400 Query Dates

    How do you computed dates in Query

    Philip915 pointsBadges:
  • Convert data to character string in AS/400 query

    I use Query400 to output negative temperatures to a database file. The output file is currently created by the query at run time. The data is output as packed but I need the sign separate. I can't see how to convert the temperature to a character string either as the sign is ignored. Any other...

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

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