• Query Administration

    Is there a way to get the last date a query was run?

    Dmojares5 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:
  • AS/400 Query – wild card for LIKE test

    When I select records usinf the LIKE test, what wild card character do I use? LIKE 'air%'?

    CooperDuper5 pointsBadges:
  • AS400 query print landscape/legal?

    How do you get Query to print in landscape on legal sized paper? I tried adjusting the paper size but that didn't seem to help.

    Lilarose75 pointsBadges:
  • Exporting a query in AS/400

    How do I export a query that I'm currently viewing?

    HIM30 pointsBadges:
  • AS/400 query join

    I have 2 files I am joining. The primary file is an employee master. The secondary is a history file with the employees time punches. Using a type 1 join it works fine. The user wants a change to the query to show the employees who did not punch in for a specific day as well, which would be a type...

    ToddN20006,360 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:
  • Select only updates/deletes/changes to files using query

    How can I Only select updates/deletes/changes to files and dont want  I/O type access  using query

    carlosdl65,110 pointsBadges:
  • AS/400 Query Job Log

    Dear all, Its my first time I submit a question so, please forgive me if I do something wrong. My question is if it possible to have a detail job log from a query. I mean if I can see what files I have used or what criteria I have used. Thank you Lambros

    Lambros25 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:
  • AS/400 Query – Current date -1

    Is there a quick and easy way to calculate yesterdays date by using "Define result fields"

    Soren5 pointsBadges:
  • AS400 Retrieve QUERY Print Definitions inside of CL procedure.

    Inside of a CL procedure, I want to retrieve the printer name being used by the designated query. I need to do this without any prompting, therefore using WRKQRY, option 6 to print definitions will NOT work. What is the alternative. I simply need to know the printer name used in all of the queries...

    MeAndCL50 pointsBadges:
  • Signed field to a packed field in AS/400 query

    Does anyone know of a way to move a signed numeric to a packed numeric in query? Is it even possible?   Been playing with it and can't find a way.  Any answer appreciated. 

    Lilarose2260 pointsBadges:
  • How can I concatenate files for transfer from the iseries

    I have 3 files with a common layout in a common library on the i5. The source files (query results) have different definitions so I am unable to append the result of query2 to query1. So what I want is to perform a UNION or concatenate them into a single download file. I have tried a UNION but...

    Mgaylard5 pointsBadges:
  • AS400 Query – div by zero

    Hi I have a query as follows:- I want to define the following:- Field       Column                                 Heading     Len     Dec PERCENT (t01.amtdol/t02.pvsddl)*100 When I run the query it displays the above field but it converts the percent...

    devan390 pointsBadges:
  • Using Query on 4 different files

    Hi i have four different files each containing a Customer name ,number and sales amounts ,each file is for a different quarter of the year ,i would like to join the four files so that i can produce a report which lists across the page by quarter the sales for each customer,however not all the...

    ZETA5 pointsBadges:
  • AS400 query

    I want to be able to write a query that says take xdate field plus a number of days. How do I do this

    Kzjtbm5 pointsBadges:
  • Retrieving Last 7 days Details in AS/400

    I've a senario, In that i need to extract last 7 days details using query in AS/400. I tried with MAX function. In that it takes MAX(&CURNTDATE) as whole number and subtract. For example i'm subtracting 7 from today's date (1101027 - 7), i got 1101020. If i subtract 40 means i got 1100987. Can...

    Dsaran2007150 pointsBadges:
  • Reconciliation of Input and Output file with same primary key but different values

    We do a recocciliation of input and processed output file. There is always instances where we have same primary key with 2 same different values in the output and input file. When i do amatching query, it returns 4 variances instead of just showing 2 variances of zero amounts. It shows extra 2...

    Lakeside19005 pointsBadges:
  • AS400 Query Output Font

    Here is the screen that I am working with: Define the Query Query . . . . . . : REFUND1.00 Option . . . . . : CHANGE Library . . . . : QS36F CCSID . . . . . . : 65535 Type options, press Enter. Press F21 to select all. 1=Select Opt Query Definition Option > Specify file selections > Define...

    lorit365 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