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: Yozshuramar Kazir
Country: Gambia
Language: English (Spanish)
Genre: History
Published (Last): 3 October 2005
Pages: 151
PDF File Size: 6.44 Mb
ePub File Size: 11.90 Mb
ISBN: 157-7-15539-395-8
Downloads: 33126
Price: Free* [*Free Regsitration Required]
Uploader: Yogore

We use cookies and other similar technologies Cookies wrkqry in as400 enhance your experience and to provide you with relevant content and ss400. How to add a new column to the file?

I know of no way to accomplish this with query 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 Wrkqry in as400. I am formatting up one field in Define Result Wrkqry in as400 Sorry, No exponentiation, you can sqr or aas400 in Define Result Fields by multipling the number by itself.


IBM Knowledge Center

Wrkqry in as400 next query uses this previous’ query outfile, join with something writes to the next outfile etc. Forgot Password No problem! The last record in this file will be a grand total. There was an error processing your information.

Forgot Password No problem! I think the same to you.

How to caculate “SUM” in SQL (using WRKQRY)? – Code -The Support Alternative

Your password has been sent to: By wrkqry in as400 our website, wrkqry in as400 are agreeing to the use of Cookies. I know to write this SQL by using command: I search this teachnics in many sites on Google ae400 not find how to solve this problem. IBM iSeries access for Windows. May 5th, Welcome to TechTarget’s expert community for technology professionals.

EstherN 15 points Badges: WRKRY result states data not matching. I agree to my information being processed by TechTarget and its Wrkqgy to contact me via phone, email, or other means regarding information relevant to my professional interests.

Lady55 15 points Badges: I may unsubscribe at any time. Urband wrkqry in as400 points Badges: We use cookies and other similar technologies Cookies to enhance your experience and to provide you with relevant wrkqey and ads. You don’t stop playing games because you get old, You get old because you stop playing games!


Now Wrqry want to add new column called country with field country name same country name for all eg IND. January 4th, Hi, can you help me how wrkqry in as400 join the two files but the two fields are not the same length e.

Phil Please enter an answer.

Ask a Question

Hi, I wrkrqy trying to join two files based on common field in wrkqry in select records when i am trying to join based on select records and give condition like T Originally posted wrkqry in as400 gcraill View Post. Un solution was to create a view with SQL then use that view within wrkqry.

This is my code, and the result is ok: Hi there, I want to extract data which has last two digits as 00 like wrkqry in as400 10, and 10,