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.
|Published (Last):||25 May 2017|
|PDF File Size:||10.86 Mb|
|ePub File Size:||5.73 Mb|
|Price:||Free* [*Free Regsitration Required]|
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.
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.
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.