11 Oct As Query, QUERY/ as it used to be called or IBM Query for Iseries, At the as command line type in WRKQRY and hit ENTER. In WRKQRY command, I do not know where can specify SUM All my answers were extracted from the “Big Dummy’s Guide to the As”. Re: Wrkqry Hi Jamie – actually I was using: Query for iSeries Use Version 5 SC41 but still couldn’t get the calculated date to end up as.

Author: Mikagore Nikor
Country: Saint Lucia
Language: English (Spanish)
Genre: Finance
Published (Last): 25 May 2017
Pages: 368
PDF File Size: 10.86 Mb
ePub File Size: 5.73 Mb
ISBN: 925-8-69690-901-9
Downloads: 41192
Price: Free* [*Free Regsitration Required]
Uploader: Mezizragore

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.

How to extract specific data in AS/ – IT Answers

Press F9 to specify an additional file selection. RamvishakRamesh 2, points Badges: I think the same to you. Convert the numeric data to character and substring the last two characters of the character and use that as a comparison.

Ij follow this tag Please make sure that this is still what you want to ask because the question is quite hard to read. Name, F4 for list Library. Hi, Let us think we have a basic Employee Table with fields like Ename ,dept ,salary,location. This is my code, and the result is wrkqfy Managing storage for virtual environments Complete a brief survey to get a complimentary page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts.

TOP Related  2SC2921 PDF

Please try again later. Share this item with your network: By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies. Typing a 1 next to the customer number field will ensure that the data is produced in customer number order. Oldest Newest Sorting replies To change the sequencing of the query, type 1 next to “Select Sort Fields”.

sponsored links

Upgrading Active Directory domain controllers Raid 5 performance. WRKRY result states data not matching.

F12 to cancel returns to the main definition screen Next is to take option 1 for Column Formatting to modify the column ss400 to be more descriptive. Thanks, we’ll keep you up-to-date on all relevant activity! There was an error processing your information.

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 field say DecFld.

Register Here or login if you are already a member. Therefore, I must implement by RPG code.

Is there sa400 way to work with this? Originally posted by gcraill View Post. The next step is to decide which records to select. Hi there, I want to extract data which has last two digits as 00 like in 10, and 10, 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.

Based on this field being numeric 1. Now we need to save the query. Darrylf 15 points Badges: Newer Post Older Post Home.

AS Technology: Creating AS Query WRKQRY

I need to find the Average of the daily balance as the last record. Megha – check the previous posts it was fromwhile your reply is accurate it may be a little late.


Itemkey User Quantity I need the result is: Is there a way to place the count of a item on the same line instead of underneath each counted value? Its a very easy to use tool for displaying, extracting and reporting on data.

Wrkwry a question, help wrkqrg, and get answers from the community. January 4th, Then in Ih Summary Report Functions select 1 on your salary field. But the problem is when i use this new field like: Read the latest tech blogs written by experienced community members.

Rohit Deshpande September 5, at We’ll let you know when a new response is added. F21 will split the screen into two mini windows, one fixed and one moveable, so you can view 2 parts of the data similultaneously.

I got it by defining with new field in Define result fields. Join Stack Overflow to learn, share knowledge, and build your career. Register Here or login if you are already a member. How to add a new column to the file? Lastly in Define report breaks select break level as your dept number. I may unsubscribe at any time. Submit your e-mail address below. It will show sum of salaries broken as per dept.