• WRKRY result states data not matching

    HOW DO I FIX THIS: WRKRY result states data not matching?

    GENTAH20165 pointsBadges:
  • AS/400: How to add a new column to the file?

    Is it possible to create/add new column to one file using WRKQRY? Eg: I have a file/table called City and it has some columns like city name, pin code. Now I want to add new column called country with field country name(same country name for all eg IND). Is there anyway for this?

    patnam80 pointsBadges:
  • How to retrieve an outfile in QMQRY?

    I am working at new place where they have a lot of Queries which works as series one after another, doing selection, writing to outfile. Then next query uses this previous' query outfile, join with something writes to the next outfile etc. To analyze this numerous queries, I used RTVQMQRY command...

    EstherN15 pointsBadges:
  • How to extract specific data in AS/400

    Hi there, I want to extract data which has last two digits as 00 (like in 10,000 and 10,001. I need to get only the records of 10,000) by using WRKQRY.

    patnam80 pointsBadges:
  • AS/400: How to insert data from one table to another?

    How do I insert data from one table to another by using WRKQRY? Is it possible to use INSERT INTO condition in WRKQRY? or else is there any other possibility?

    patnam80 pointsBadges:
  • Wrkqry for join files

    Hi, can you help me how to join the two files but the two fields are not the same length e.g. 1st field (left side) is 9 (ex. A005B2589 job#) and the 2nd field (right side) is 11 (ex. A005B258901... the last two digit 01 is for partial#), kindly advise if it's possible?  Thanks and regards...

    Mario0525 pointsBadges:
  • CHAR comaparision is not matching in WRKQRY

    I'm comparing two fields in WRKQRY. 1st field is of length '10' and 2nd field  is of length '3'. First field is having value  '6' And Other has '06'. When I'm comparing above fields then its showing O/P as fields are not matching even though having same value '6' Kindly suggest some way to do...

    Neha33335 pointsBadges:
  • OPNQRY and WRKQRY

    In WRKQRY, there is an option to save the selected records to an output file. Similarly is there a way to use OPNQRY in a CL or in an SQLRPG to directly move the selected records to another file?

    AnonymousUser18,240 pointsBadges:
  • 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:
  • How many parameters can be used in as400 wrkqry?

    how many parameters can be used in as400 wrkqry

    Urband5 pointsBadges:
  • WRKQRY Count in AS/400

    Is there a way to place the count of a item on the same line instead of underneath each counted value?

    Darrylf15 pointsBadges:
  • Get average through WRKQRY

    I have a file which has daily balances. I need to find the Average of the daily balance as the last record. I have selected the report summary functions from WRKQRY and have given (2=Average) on the desired field. I have selected the output type as 3 = data base file. After this if I take a F5 I...

    RamvishakRamesh2,505 pointsBadges:
  • Define query without WRKJOBSCDE

    How can I Define a query to run only Monday thru Friday not using WRKJOBSCDE (we have a customised WRKQRY) scheduler and doesn't have an option to input the schedule day e.g. *Mon *Tues =, etc....I'll like to see if any one knows how to Define the query using the DEFINE RESULTS FIELDS e.g....

    Querys100 pointsBadges:
  • WRKQRY issue

    Hi, I am trying to join two files based on common field in wrkqry in select records when i am trying to join based on select records and give condition like T01.fld1 EQ T02.FLD1 I get an error data types are not compatible. both fields are of 6 length but one is numeric and other is character....

    6r1,765 pointsBadges:
  • WRKQRY query

    Hi, I have a CL program which uses WRKQRY to generate a report out of it. Now I have a requirement to change a field which holds Quantity and I want to divide this by 10 to the power of another field say DecFld. ie if Quantity is 359686 and DecFld is 2, I want 359686/10**2 = 3596.86 . Is it...

    RamvishakRamesh2,505 pointsBadges:
  • What is the difference between replacing a file and replacing a member in AS/400

    What is the difference between replacing a file and replacing a member in AS/400? Option 2: Replace file Option 4: To replace the member I mean the difference between below options in WRKQRY?

    vnaren915 pointsBadges:
  • Converting a character to numeric

    In WRKQRY environment, what is the function that can be used to convert a string or character to numeric? By Sulaiman "Sem" Salomon Bernat

    SEMSBERNAT5 pointsBadges:
  • WRKQRY query

    In WRKQRY, while selecting the collating sequence, what is option 2-Query for iSeries English? I am trying to learn the options in WRKQRY and came across this. F1 help details are not digesting. Please help.

    RamvishakRamesh2,505 pointsBadges:
  • WRKQRY Call LOADITMCL

    When I run a WRKQRY for ITEMSQRY after I'm done query completes fine. I use Call LOADITMCL to load the WRKQRY but when I run call LOADITMCL application error. cee9901 unmonitored by LOADITMCL at statement 0000000600, instruction x’000. This does work in our production side but in test it doesn't....

    jcmunoz11825 pointsBadges:
  • Expand Counter Size in WRKQRY

    I use WRKQRY to produce a summary file. I use '5' to indicate the counting on a special field. The counts is larger than 9,999,999. I got field overflow. How to expand the counter field?

    chen755515 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