• 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...

    RBDSILVA540 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:
  • What is the proper syntax for using the RANGE test in select records?

    I am trying to test for a date range in my query. I dont know what the proper syntax is for testing range. Any ideas? Thanks

    Bmatts1410 pointsBadges:
  • test value of list in AS/400

    What is the definition of the test value list?

    Qwerty545 pointsBadges:
  • AS400 QUERY-Beginning of year date

    How can I create a date field with the 1st day of the current year ie: 01/01/2009 using WRKQRY. Thanks!

    TB2G35 pointsBadges:
  • How to see records in ALL Files to an OutFile

    I have a programmer that wants to see all Files in a specific library that have 0 records. I know I can do a dspfd on all files in a specific library but I can't display it to an outfile. I wanted to run a query over the outfile. Can someone offer any suggestions on which command or program I could...

    Alison88380 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