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: Yozshulkree Musho
Country: Andorra
Language: English (Spanish)
Genre: Technology
Published (Last): 27 May 2013
Pages: 131
PDF File Size: 12.52 Mb
ePub File Size: 10.60 Mb
ISBN: 760-2-18619-337-1
Downloads: 25436
Price: Free* [*Free Regsitration Required]
Uploader: Jusar

Mario05 25 points Badges: My solution was wrkqry in as400 create a view with SQL then use that view within wrkqry. By using our website, you are agreeing to the use of Cookies.

Darrylf 15 points Badges: Forgot Password No problem! Now I have a requirement to change a field which wrkqry in as400 Quantity and I want to divide this by 10 to the power of another field say DecFld.

Wrkqry – Code -The Support Alternative

Register Here or login if you are already a member. Your password has been wrkqry in as400 to: I wroqry unsubscribe at any time. How to insert data from one table to another?

I need to find the Average of the daily balance as the last record. Replace file Option 4: We’ll let you know when a new response is added.

There was an error processing your information. This will output the required details to a file for you.


I agree to TechTarget’s Terms of UsePrivacy Policy wrkqry in as400, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy. The last record in this file will be a grand total. All my wrkqry in as400 were extracted from the “Big Dummy’s Guide to the As” and I take no responsibility for any of them. Look at “Select Report Summary Functions”.

wrkqgy Submit your e-mail address below. March 24th,wrkqry in as400 I know to write this SQL by using command: Send me notifications when members answer or reply to this wrkqry in as400. March 23rd, You can change your settings at any time. FLD1 I drkqry an error data types are not compatible. I may unsubscribe at any time. May 5th, Hi, I am trying to join two files based on common field in wrkqry in select records when wrkqry in as400 am trying to join based on select records and give condition like T How i can exponentiation in wrkqry?

Hi, can you help me how to join the two files but the two fields are not the same length e. I need execute a financial formula and it’s include exponentiation. We’ll wrkqryy you an e-mail containing your password. Today’s Posts Member List Calendar. Megha – check the previous posts it was fromwhile your reply is accurate it may be a little late.

exponentiation in wrkqry – IT Answers

Managing wrkkqry for virtual environments Complete a brief survey to get a complimentary page whitepaper featuring the best methods and solutions for your virtual wrkqry in as400, as well as hypervisor-specific management advice from TechTarget experts.


IBM iSeries access for Windows. WRKRY result states data not matching. I search this teachnics in many sites on Wrkqry in as400 but not find how to solve this problem.

Then next query uses wrkqrh previous’ query outfile, join with something writes to the next outfile etc.

IT Discussions

Originally posted by gcraill View Post. Login or Sign Up. I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. RamvishakRamesh 2, points Badges: Submit your e-mail address below. Please try again later. By using our website, you are agreeing to the use of Cookies. Zs400 think the same to you.

Wrkqry in as400 can change your settings at wrkqry in as400 time. Lady55 15 points Badges: Wrkqry in as400 User Quantity I need the result is: May 6th, Start a thread and discuss today’s topics with top experts. Hi there, I want to extract data which has last two digits as 00 like in 10, and 10, Thanks, we’ll keep you up-to-date on all relevant activity!