AS/ 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. 31 Jul How i can exponentiation in wrkqry? How many parameters can be used in as wrkqry? For one library WRKQRY must be prohibited. IBM i (aka OS/, i5/OS) is the premier OS on the Power System boxes. Share information with your peers here.
|Published (Last):||13 September 2015|
|PDF File Size:||3.87 Mb|
|ePub File Size:||16.80 Mb|
|Price:||Free* [*Free Regsitration Required]|
Neha 5 points Badges: I know to write this SQL by using command: The last record in this file will be a grand total.
We’ll wrkqry in as400 you an e-mail containing your password.
Welcome to TechTarget’s expert community for technology professionals. My solution was to create a view with SQL then use that view within wrkqry.
Wrkqry – Code -The Support Alternative
We’ll send you an e-mail containing your password. I need execute a financial formula and it’s include exponentiation. Originally posted by gcraill View Post. There was an error processing your information. Share this item with your network: Submit your e-mail address below. To follow this tag Wrkqry in as400 have a file which has daily wrkqry in as400. Wroqry I want to add new column called country with field country name same country name for all eg IND.
Unconfigured Ad Widget
How to caculate “SUM” in SQL (using WRKQRY)? – Code -The Support Alternative
Thanks, we’ll keep you up-to-date on all relevant activity! Darrylf 15 points Badges: Login or Sign Up. This is my wrkrqy, and the result is ok: AB job and the 2nd field right side is 11 ex. All my answers were extracted from the “Big Dummy’s Guide to the As” and I take no wrkqry in as400 for any of them.
What is a Tag? We’ll email you when relevant content is added and updated. May 6th, Please try again later.
You a4s00 change your settings at any time. I may unsubscribe at any time. Now I have a requirement to change wrkqry in as400 field which holds Quantity and I want to divide this by 10 to the power of another field say DecFld. Register Here or login if you are already a member.
But then I am no expert in query. 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.
FLD1 I get wrkqry in as400 error data types are not compatible.
Read the latest tech blogs written by experienced community members. January 4th, We’ll let you know when a new response is added.