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

    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,640 pointsBadges:

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

    Chardyjr45 pointsBadges:
  • WRKQRY Security Flaw / Users can Alter/ Replace Data in Production Files

    Can a user change or replace data, members, or the file itself (a prodcution file in a production lib) using WRKQRY...??? I have an auditor who believes in the "Define the Query" display, 2nd to last option ("Select output type and output form") you can specify 3 in the output type (3 = datafile...

    Gambitt7150 pointsBadges:
  • exponentiation in wrkqry

    How i can exponentiation in wrkqry? I need execute a financial formula and it's include exponentiation.

    Robertord5 pointsBadges:
  • For one library WRKQRY must be prohibited.

    Some users in my company may use the command WRKQRY. Then they can also select files from the financial library. The management want to change this. The users may select by WRKQRY all files of all libraries except the fiancial library. This library is also used by our applications and that must be...

    Faelledj5 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:
  • Can we use TRIM in WRKQRY?

    I am formaing up one field in Define Result Fields Field JOBNM Expression x9jbno||'/'||x9jbus||'/'||x9jbnm Here can I use TRIM function with x9jbus filed to avoid blanks If anybody knows pls let me know at pankajmahajan@hsbc.co.in

    Pankaj2rmca15 pointsBadges:
  • running queries in infinium application manager

    Is it possible to have a wrkqry command in an infinium menu to generate reports. Do you have to have access to specific objects?

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