• How to install Query/400

    I don't have WRKQRY in my iSeries. How can I install query/400?

    7ankareto5 pointsBadges:
  • Query/400: Subtract one date from another

    I only want my calculate to use number of business days.

    queryhelpserena105 pointsBadges:

    In WRKQRY, there is an option to save the selected records to an output file. Similarly is there a way to use OPNQRY in a CL or in an SQLRPG to directly move the selected records to another file?

    AnonymousUser49,520 pointsBadges:
  • API or procedure to print layout of spool file in app program

    Hi all, I stuck in one of the procedure where I am selecting one file and their fields,on next screen function should availble for user to see the layout of spool file for selected filed. Please share if there is any api or procedure I can call from this screen. (this functionally is simillar to...

    Samule400160 pointsBadges:
  • AS400 Query Dates

    How do you computed dates in Query

    Philip915 pointsBadges:
  • Query400 authorizations

    We have used a generic user ID for our support persons to sign on to a data center. Due to audit requirements we were forced to elimiate the Generic User. Many queries were created over the years for customers and were saved with *CHANGE auhority instead of *ALL. Now that the generic user is no...

    Kellyd100 pointsBadges:
  • Calling query/400 through CL

    Hi, Is it possible to call query/400 through a CL program? Please suggest some idea.. Thanks, Jayashree V.      

    VJayashree185 pointsBadges:
  • IBM I-series Data Download

    I run a query in query/400 and tried to download that file using IBM Iseries. in the downloaded file, the column headers are in field ids and not the descriptions i have given in Query/400 report column formatting. Is there any way to download a file with column descriptions given in query?...

    VJayashree185 pointsBadges:
  • Displaying amount field in query 400.

    In query400, i created a report which will be downloaded to excel. If i download report, it is showing amount fields without decimal values. How to display amount fields with decimal fields using query400?  

    VJayashree185 pointsBadges:
  • AS/400 query

    Is there a way to create a query that gives you a report with an average price, but does not include the zero prices in the count of the average? Those "zero price records" must be included in the report for other info.  

    Hf30 pointsBadges:
  • How do I parse out a timestamp ISO format into a date field

    How do I parse out a timestamp ISO format into a date field? This is how the field looks: Timestamp ISO Format 2008-10-08- Here is the description of the field: Field From To Length Type Description XXXXXXX 57 82 0 Z Timestamp ISO Format I need to get the 2008-10-08 into a date...

    SaraP5 pointsBadges:
  • I want to reterive all users list with last logon date inculuded(help me with the query)

    am running with AS400 iseries system V4R5.

    Janand5 pointsBadges:
  • find a named query

    i know the name of a query, but not the name of the library it was stored in. company is large and libraries are many -- is there a simple way to find this query and which library it is in?

    Jtkiii15 pointsBadges:
  • Query 400 – Problem appending data from 1 file to another.

    In Query 400 i am trying to append File B to File A. (5=Add to member). Each time i run the 2nd query for File B it gives me "Query output definition does not match file <FILENAME> in <LIBRARYNAME>". I notice that file A is of Type CHAR and file B is of Type ZONED. Would this prevent an...

    Jkbritvic65 pointsBadges:
  • Best way to retrieve values, SQL or Queries and how?

    Hello everybody, my problem is, in a iseries i have ia file and in this file exist one field with 10000 lenght (character) and i want retrieve a value like (  60F: ) but i don´t know in what position, after i find this value i need the follow values. ex: this is a part of one record  {4: ...

    BUG68235 pointsBadges:
  • Finding Files used by Query/400

    Somewhere I know I had notes and maybe code to do this, but the clock is ticking, so does anyone have the way to extract what files are being used in exisiting (old!) queries - *QRYDFN type I have an extract utility written, but it's old stuff, and iteratively prints and reads the output. this...

    Yorkshireman6,085 pointsBadges:
  • Using ‘IF’ statements in query/400

    I need to create a work field that will be populated differently, dependin on a series of 'If' statements. Ex: If TMRPER = 'M', use TMRFRQ value. If TMRPER = 'D', then use TMRFRQ divided by 30, rounded to the nearest whole number. Any idea how to do this?

    HTLFTMP5 pointsBadges:
  • Auto-Generated Serial Numbers?

    I want to know that how do i generate serial numbers by using Query/400.For eg a database named employlist having name,address and phno.Now i want to add one another column which is serial. How???????? Can anyone please tell me the solution by using Query/400. I've done it from SQL. Name Address...

    Ria15 pointsBadges:
  • How do I print dates in range selection on headings?

    Have query setup for user to enter selection date range when running query...how do I print the date range selected by the user on the headings?

    Bplocki35 pointsBadges:
  • subtotal and average

    Can anyone tell me how/if I could using query400 take a list of records, subtotal and create a file with only the subtotals for export to excel? My file is all orders, with line items and $$ for each line. I need to subtotal the orders by order # and create a file listing only the customer #,...

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