• 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:
  • 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:
  • Select code within AS/400 query

    I have to run a Query based on PF without DDS with record length 2997. I have to select Company Code '01' which is the 925-927 positions in the file. How do I do select in the Query? Please advice. Thank you.

    Larisagas265 pointsBadges:
  • Define query without WRKJOBSCDE

    How can I Define a query to run only Monday thru Friday not using WRKJOBSCDE (we have a customised WRKQRY) scheduler and doesn't have an option to input the schedule day e.g. *Mon *Tues =, etc....I'll like to see if any one knows how to Define the query using the DEFINE RESULTS FIELDS e.g....

    Querys100 pointsBadges:
  • IBM TXSeries and AS/400

    The customer is using custom gateway using IBM TX series (multiplatform v6) on AIX platform and the client's all IVR related transactions are available through LU 0 protocol only and we should not use any other in order to intract with AS 400 host (CICS). Please clarify the below: 1. The IBM TX...

    Srinivas naikk115 pointsBadges:
  • Query products

    What are the different query products in AS/400? How do they function?

    Durgesh813375 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