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

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