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.

Author: Dajind Mahn
Country: Ghana
Language: English (Spanish)
Genre: Finance
Published (Last): 13 September 2015
Pages: 159
PDF File Size: 3.87 Mb
ePub File Size: 16.80 Mb
ISBN: 757-4-82368-817-8
Downloads: 50405
Price: Free* [*Free Regsitration Required]
Uploader: Gurn

Neha 5 points Badges: I know to write this SQL by using command: The last record in this file will be a grand total.

Key field is Itemkey and User Example: Itemkey User Quantity I need the result is: Lady55 15 wrkqry in as400 Badges: I agree to TechTarget’s Terms of UsePrivacy Policyand the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.

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

Then next wrkqry in as400 uses this previous’ query outfile, join with something writes to the next outfile etc. I know of no way to accomplish this with query We’ll email you when relevant content is added and wrkqry in as400. We use cookies and other similar technologies Cookies to enhance your experience and to provide you with relevant content and ads. Replace file Option 4: Hi there, I want to extract data which has last two digits as 00 like in 10, and 10, ItemKey group and grand total as4000 quantity of the ItemKey.

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.

sponsored links

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.