• 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:
  • 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,590 pointsBadges:
  • WRKQRY

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

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

Following