• Qry Mgmt losing edit word specs

    My 400 query has edit words specified for proper printing of the dates in my report, but I am passing parameters to select the correct data using STRQMQRY. My output is ignoring the edit words specified in the query

    smKny5 pointsBadges:
  • SIL File, field ILQTY make it numeric

    How can I make the field ILQTY in the SIL file (for invoices) make numeric, so that I can make a count in summaries? Thank you!

    David4045 pointsBadges:
  • Simple question about AS/400 query

    Maybe for you that will be a stupid question, but I'm taking the first steps and I don't know what exactly I have to do in the "Specify how to join files" screen. If I put more joints in more rows it is how there was an "and" before every new row? I mean, all the rows are conditions that have to be...

    Fabio5 pointsBadges:
  • AS 400 Query File Reference

    How would you go about identifying file, field and output references of a group or *all AS400 queries? I need to be able to identify files where used in queries.

    Modiyooch540 pointsBadges:
  • Using LIKE in AS/400 Cobol

    How to use 'LIKE' in Cobol similar to query/400(example Field_A LIKE '%777%')

    111719555 pointsBadges:
  • Rounding

    how do l round up or round down values in a query/AS400?

    Tonchin5 pointsBadges:
  • Number of days between 2 dates

    How do I find the number of days between 2 dates? Julian or MM/DD/YY?

    Pherrick20 pointsBadges:
  • changing qpquprfil in query

    how do i change the qpquprfil in as/400 query. i have doone it before and i know it is doabe but ican't rember how. i mean thesystem one not the one at the user level??

    Zonar5 pointsBadges:
  • Forcing AS/400 query data to respect original data order

    000012   FROM      DISACTDTA1/COGJREP T02,  000013             DISACTDTA1/COGKREP T01,  000014             DISACTDTA1/COCXREP T04,  000015             DISACTDTA1/COGDREP T03,  000016             SATACTDTA1/FINURED T05  000017  ...

    AS400 - Ask the Expert485 pointsBadges:
  • Duplicate Records

    Help - My query is returning duplicate records.  How do I eliminate that?  In addition, how can I total the adjustment amount and report one record?  Here's the query: SELECT Distinct "T16.GNAM".N_NAME, "T16.GNAM".N_CITY, "T16.CADJ".AD_TOTAL_ADJUSTMENT, "T16.CRDC".RD_COMMENT    FROM...

    lorit365 pointsBadges:
  • AS/400 Query Join Duplicate Records

    I have three files A, B, C in my join query. Test is between A - B, B - C. The type is 2 (match records to primary file). When I run the query, it is returning duplicates. What am I doing wrong?

    lorit365 pointsBadges:
  • AS400 Query Join

    I need expert help. I need to create a query that will use four tables. Each table has a column of data that I need for the report. The end result should display the following: Name, City, Amount, Reason.  Here is my first query that gives me the name and city: SELECT "T16.GNAM".N_NAME,...

    lorit365 pointsBadges:
  • AS/400 Query Join

    I am joining four files. Each file has one field I need for my report. How do I determine which file is the primary one? Should the select records criteria all come from the primary file? As long as I test fields First>Second, Second>Third, Third>Fourth, shouldn't it work just fine?

    lorit365 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:
  • AS/400 Query – Timestamp of entry to char field

    Hi friends, I am creating an account file with the command below: DSPJRN JRN(QSYS/QACGJRN) FROMTIME('26/09/2009') TOTIME('25/10/2009') ENTTYP(SP) OUTPUT(*OUTFILE) OUTFILFMT(*TYPE4) OUTFILE(QTEMP/QAPTACG4) How can I convert the Timestamp field called JATSTP to a new char field with the first four...

    RBDSILVA550 pointsBadges:
  • Converting date values in AS/400 database

    How do I convert a date value 20/09/1231 for 31st Dec 2009 in the database to be able to use a query of checking this date against current(date)?

    Bonbon7830 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:
  • How do I disable the query timeout property?

    I'm calling a stored procedure on the AS/400 from Visual Basic .Net. When the stored procedure executes, I get the SQL0666 message (query exceeds specified time limit or storage limit). The query timeout property on the box is set to *NOMAX and I've Reorg'd the files too. The message appears to be...

    JasonWV5 pointsBadges:
  • AS/400 QUERY ; how can I calculate the month and year of 3 months ago in define result fields?

    I am using an AS/400 query in which I need the month and year of 3 months ago based on today's date. To get today's date I use current(date) but I need to know the month/year 3 month ago and the month/year of previous month undepending which day of the current month it is. Is that possible? I...

    Chrisjegoderie30 pointsBadges:
  • Query Xref to file

    The other day I added a field to the DDS of a file. I recompiled all of the RPG programs and display files that use the physical file. But I got burned when I found that I neglected to include all of the queries that used the file. Is there a way to query all of the query definitions to find if my...

    Abbey120 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