• 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:
  • 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:
  • like query not running in pg

    hi i am running a query to select records which contains abc_ so i am running : var1= 'abc_' + '%'; so i am running in rpg as select name from table where name like :var1; query is running but not selecting any records ..please help me out

    munduuu435 pointsBadges:
  • AS400 user profile query

    Can you query which users are enabled and have a specific initial menu?

    Kiok45 pointsBadges:
  • STRQMQRY: The variable should appear without quotes

    In my cl the strqmqry I am passing 2 variables that are character but should be numeric when the query runs.............now they have the quotes around them.................how do I get the quotes out of there so they are treated as numeric????

    Harrigan5 pointsBadges:
  • Next step in my AS/400 career

    Hi, I've been working for last 3.5 years in AS400 and in which Cobol400 as programming language. I didnot get any chance to work in RPG in these years. Actually i want to grow in my career as technical expert in AS400. But being only knowledge in cobol and cl, i am not sure that i will make it....

    Thotts45 pointsBadges:
  • with Delphi-adoquery AS400 to access

    My question is, with Delphi-adoquery AS400 to access, but I have AS400 member at my table. How should we proceed, I need urgent help. Thank you for everything Library table field names: my library narpak2: tables mgpyvm: Members narpak2009

    Zagerx20 pointsBadges:
  • OUTPUTQUE with CHGSPLFA

    I have 2 users, one *USER and another *SECOFR When the user *USER change the spoolfile, the options was displayed                            Additional Parameters                      ...

    PutzGrilla785 pointsBadges:
  • When Prototype changes, can we use binder source?.

    When Prototype changes, can we use binder source?. I mean when procedure prototype changes ( parameter list changes), can we use binder source?. I guess no, we have to recompile and update all programs uses that procedure. pleae confirm

    Alicsc370 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