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: Mikam Shakarg
Country: Pacific Islands
Language: English (Spanish)
Genre: Travel
Published (Last): 25 September 2013
Pages: 205
PDF File Size: 4.20 Mb
ePub File Size: 14.80 Mb
ISBN: 983-7-32161-900-6
Downloads: 18112
Price: Free* [*Free Regsitration Required]
Uploader: Kigasida

Please try again later. I am working at new place where they have a lot of Queries which works as series wrkqry in as400 after another, doing selection, writing to outfile. Forgot Password No problem!

I know of no wrmqry to accomplish this with query This is my code, and the result is ok: This will output the required details to a file for you. Pankaj2rmca 15 wrkqry in as400 Badges: I think the same to you. I need to find the Average of the daily balance as the last record.

I agree to my information being processed by TechTarget wriqry its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests.


March 24th, Ask a question, help others, and get answers from the community. May 5th, I agree to wrkqry in as400 information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. How i can exponentiation in wrkqry?

WRKQRY Archives – IT Answers

I may unsubscribe at any time. We use cookies and other similar technologies Cookies to enhance your experience and to provide wr,qry with relevant content and ads. How to add a new column to the file? Now I have a requirement to change a field which holds Quantity and I want to divide this by 10 to the power of another wrqry say DecFld. You can wrkqry in as400 your settings at any time. Forgot Password No problem!

Read the latest tech blogs wrkqry in as400 by experienced community members. After this if I take a F5 I What is a Tag?

Please try again later. Neha 5 points Badges: AB wrkqry in as400 and the 2nd field right side is 11 ex. I search this teachnics in many sites on Google but not find how to solve this problem. Thanks, we’ll keep you up-to-date on all relevant activity!

Last Drivers  KSD-01F PDF

Today’s Posts Member List Calendar. Register Here or login if you are already a member. How many parameters can wr,qry used in as wrkqry?

WRKQRY- Query management in asgo4ascom

Darrylf 15 points Badges: I need execute a financial formula and it’s include exponentiation. Welcome to TechTarget’s expert community for technology professionals.

Hi, can you help me how to join the two files but the two fields are not the same length as4400. AnonymousUser 49, points Badges: Start a wrkqry in as400 and discuss today’s topics with top experts. But then I am no expert in query. What about SQL, instead?

IT Discussions

Now I want to add new column called country with field country name same country name for all eg IND. The last record in this file will be a grand total. By erkqry our website, you are agreeing to wrkqry in as400 use of Cookies.