• Converting Julian date to Gregorian in WRKQRY

    I work on an Iseries AS/400 and when I do a wrkqry for reports I need to convert the date ccyyyddd(julian) to mmddyyy(gregorian)

    Lady5515 pointsBadges:
  • I’m having trouble with a simple query in DB2 for AS/400

    I know I'm an amateur when it comes to AS/400. I have this "easy" query but I still can't do it. Here's what I have:A B C 1 1100 5 1 1100 5 1 500 1 2 1200 4 2 1200 4 2 600 1 3 1300 3 3 1300 3 3 700 1And this is how I want it returned:A B C 1 1100 10 2 1200 8 3 1300 6I tried this but it's only...

    ITKE346,360 pointsBadges:
  • Export multiple files to Excel using CL

    Hello, I have these queries on a job schedule now and I want to export them to Excel using CL. PGM RUNQRY MYENTRIES1 RUNQRY MYENTRIES2 COPYTOIMPF FROMFILE(MYLIB/MYFILE1) (MYLIB/FILE2) ENDPGM Where do I send these two files to? And can I run both queries this way?

    Querys100 pointsBadges:
  • Query products

    What are the different query products in AS/400? How do they function?

    Durgesh813370 pointsBadges:
  • iSeries query: Compare two fields in one file

    Try to do a multiple select statement and then compare the results of that statement. See below: SELECT "T16.APAR".P._PARCEL_NR FROM QS36F."T16.APAR" WHERE "T16.APAR".P_PARCEL_NR NE "T16.APAR".P_PARCEL_NR (SELECT "T16.APAR".P_PARCEL_NR FROM QS36F."T16.APAR" AS "T16.APAR" WHERE "T16.APAR".P_YEAR =...

    lorit365 pointsBadges:
  • AS400 i series – command/field for qry report “last payment date” and during scheduling – how to flag appts

    I am new to using AS400 i series/applications and am becoming familiar with creating/working with existing qry reports.   I am attempting to tweak an existing qry report so that it will also pull (from field needed) data  to include a customer's "last payment date".  I realize that this can be...

    Newlearner2IT30 pointsBadges:
  • Can you mass change file libraries in AS/400 query?

    Here's a tough one. We currently have a few hundred user defined queries. Created with the WRKQRY command. We are looking at a software upgrade that now puts the production data in a new library. When a user creates a querey and leaves the library *LIBL,  it defaults in the first library it finds...

    ToddN200011,245 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:
  • 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 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:
  • 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:
  • 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:
  • Query help-all columns are not coming over

    When I look at query on define query it has all columns. When I actually run it to spool file its missing columns. Thanks Pam

    PamFaccone5 pointsBadges:
  • Can a nested query be run in AS/400?

    There are multiple lines (sequenced) of my records in a table with the same Key. Example of the table Student No.     Name         Grade      1001              Michelle       Fail 1001              Michelle       Fail...

    Bonbon7830 pointsBadges:
  • SQL/400 Query to update one field in File1 with other field in File2

    Hi All, I want to update one field(PCUSR6) in NBSPCNTR file for all records with MCUSR6 field from CASCNTRM file. I tried below combinations, but i couldn't do it. Can any one please help to update whole file with another file field. Please find below queries i tried: i have to update NBSPCNTR file...

    Mohan K695 pointsBadges:
  • Notes in AS400 query

    How do you add notes to a AS400 query?

    RoRo10 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:
  • AS/400 date format

    How do format a date field to MM/DD/YYYY?

    ZSID35 pointsBadges:
  • AS/400 Query – How to combine 2 fields but delete the null space?

    fields a: School , in the fileld a there are 3 null space after school, field b: I choose , now I want to combine filed a and field b by using "||" as a new field, how to delete the null space

    Milahuang995 pointsBadges:
  • Iseries Queries.

    Hello, I have a query schedule that runs Daily and looks for events for the previous day and, it's access in access database, but on Mondays I don't get anything because is set for previous day and Sat and Sunday overwrite the query so I get ZERO results. I've set for YESTERDAYX. How can I change...

    Querys100 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