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: Turisar Akinojas
Country: Grenada
Language: English (Spanish)
Genre: Medical
Published (Last): 28 December 2016
Pages: 18
PDF File Size: 7.25 Mb
ePub File Size: 17.18 Mb
ISBN: 347-8-50772-625-3
Downloads: 76842
Price: Free* [*Free Regsitration Required]
Uploader: Yogal

On the report Summary Functions, select Total 1 for Quantity. FLD1 I get an error data types are not compatible. I am working at new place where they have a lot of Queries which works as series one after another, doing selection, writing to outfile. EstherN 15 points Badges: This allows you to change wrkqqry to be more meaningful to the out being produced. Its a very easy to use tool for displaying, extracting and reporting on data. Neha 5 points Badges: Ask a question, help others, and get answers from the community.

We’ll send you an e-mail containing your password. What is a Tag?

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. Please enter a reply.


Welcome to TechTarget’s expert community for technology professionals. Rohit Deshpande September 5, at Press F9 to specify an additional file selection. I may unsubscribe at any time. We’ll wrrkqry you an e-mail containing your password.

Weare going to select the following columns: Sign up or log in Sign up using Google. Oldest Newest Sorting replies This tool has a very straightforward user interface, so is often used by both aa400 and non technical staff with relevant training of course.

IT Discussions

As a result you will get an output file with last two columns containing desired information i. To follow this tag Then next query uses this previous’ query outfile, join with something writes to the next outfile etc. But it also allows straight SQL. I have a file which has daily balances. In this case we only want to select records with a location code ln ”. What is ass400 Tag? Hi, Let us think we have a basic Employee Table with fields like Ename ,dept ,salary,location.

ItemKey group and grand total of quantity of the ItemKey. I search this teachnics in many sites on Google but not find how to solve this problem.

WRKQRY Archives – IT Answers

March 23rd, Stack Overflow works best with JavaScript enabled. We do need to select fields that we want to report on. After extracting the data we will create a report.


Upgrading Active Directory domain controllers Raid 5 performance. You don’t stop playing games because you get old, You get old because you stop playing games!

Your password has been sent to: Submit your e-mail address below. By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service. Please try again later. Now I want to add new column called country with field country name same country name for all eg IND.

Newer Post Older Post Home. We’ll email you when relevant content is added and updated. RamvishakRamesh 2, points Badges: May 6th, 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. To follow this tag Join Stack Overflow to learn, share knowledge, and build your career.