• 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,410 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 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,410 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,410 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:
  • Way to restrict by user id, permissible libraries for WRKQRY

    On OS400, Is there a way to manage limitation for permissible librairies when they use the command WRKQRY? And for those limited librairies can we assign a limit or quota to the storage usage per user id ou user group to avoid creation of enourmous files? Thanks in advance for reply on that,

    Umponcel5 pointsBadges:
  • QUERY on V6R1

    I am buying a 520 w V6R1. I need to have the following features on it. STRQRY WRKQRY STRSQL What is the lic pgm on 6.1? On V5R4 it was 5722QU1 or 5722qu2 & 5722st1? What is the difference between the 3?Would like to know what to order for the 6.1 box  Thxs Stephen

    Svocal120 pointsBadges:
  • Restrict File Size created by WRKQRY

    How to restrict file size created using RUNQRY ? e.g. Created the query using WRKQRY to join 2 transaction file and output type selected is databasefile. We don't have the exact primary key to relate 2 files, hence we are not sure about the no. of transaction expected from this query. Can we...

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

    ToddN20006,360 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:
  • AS400 Retrieve QUERY Print Definitions inside of CL procedure.

    Inside of a CL procedure, I want to retrieve the printer name being used by the designated query. I need to do this without any prompting, therefore using WRKQRY, option 6 to print definitions will NOT work. What is the alternative. I simply need to know the printer name used in all of the queries...

    MeAndCL50 pointsBadges:
  • Access AS400 Query Print Definitions

    I need to generate a report that shows the output type and the name of the output device found in the print definitions of a designated query. Since there are a lot of queries to check, I need to get access to the query print definitions without using WRKQRY option 6. I would be happy if there is...

    MeAndCL50 pointsBadges:
  • WRKQRY – V5R4

    Are there any issues concerning an upgrade from V5R2 to V5R4 with regard to WRKQRY?

    ARIZONAJO5 pointsBadges:
  • How many parameters can be used in as400 wrkqry?

    how many parameters can be used in as400 wrkqry

    Urband5 pointsBadges:
  • wrkqry command

    Hi, Please explain me this unfortunate incident. I did WRKOBJ(*All/aa) where aa being a query definition. After that the object was deleted from general purpose library. Is this some kind of demerits of query defnition

    Siddharth90245 pointsBadges:
  • WRKQRY’S USE TO ADD NUMERIC FIELD’S RECORDS

    How can i add up the records of my physical file's numeric field lets say Esal's records using wrkqry? Please help me by an appropriate code example. thanks in advance.    

    6r1,485 pointsBadges:
  • WRKQRY

    How do I create CL program that will execute WRKQRY command?

    Chardyjr45 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