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

    northwoods175 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?

    Durgesh813370 pointsBadges:
  • Search in QRYDFN

    I am looking for an utility which will search for the sources of QRYDFN and tell me which query is using the string that I am looking for.

    RamvishakRamesh2,410 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