• 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:
  • Web message in AS/400 is stuck

    There is a message in one of our inboxes that has been labeled as new and IN for the past year. We cannot read the message without the error: Job 440522/USERNAME/COLL18 started on 12/14/10 at 21:16:56 in subsystem QINT Permanent I/O error occurred in file WEB002D (C G D F). C CEE9901 received by...

    Wachoelz15 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:
  • Global change of file libraries in Query

    Is there a way to globally change the libraries of the input files for a set of AS400 Queries, or possible force it to use *libl. I know that I entered *libl for the file selection, but it then defaults to a specific library.

    Modiyooch540 pointsBadges:
  • Jreport problem – floating point literal

    hi! I'm new here! I have a report and this is connect to db2/as400. When I compile i have the next error "[SQL0410] Floating point literal 2.00805121133377101E18 not valid. Cause...." I don't know what is happenning. The query I run in other program and this is right, so I think is something with...

    LouIT5 pointsBadges:
  • How to view unique entry of record in collumn?

    I have table containing same multiple records in collumn, when I goes into 'Define Query' and 'Select Records' of 'Query Definition Option', it shows me all record list, but I like to view only a single entry of each record. How could be querry in 'Select Records' of 'Query Definition Option' or do...

    Shreekant40 pointsBadges:
  • Passing parms to Query400

    Has anyone ever come across a method of passing a parm into a query run - such as a date?

    Abbey120 pointsBadges:
  • Query/400 replacement needed

    I need to get serious about finding a replacement for Query/400 on our 9407/515. At first glance, there seems to be a variety of packages available from IBM and third parties, most of them much more capable and more complicated than Query/400. Unfortunately, I am not expected to spend any more of...

    SBatSI415 pointsBadges:
  • Client access Printing

    I created a printer session to run as400 queries to a cannon IR 3225 printer.  The printer appears to be disconnected and had been working fine before.  What could have gone wrong

    Davidma5 pointsBadges:
  • Find user profile list who has his audit code is blank or NONE

    All, How can we find a user profile (part of audit group) who has his audit code is blank or NONE. Thanks Archie

    Archunan30 pointsBadges:
  • AS400 – Query

    How to find the Count using RunQry and WrkQry Command without using Pagedown Key?  

    rajeshece1,215 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