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):||28 December 2016|
|PDF File Size:||7.25 Mb|
|ePub File Size:||17.18 Mb|
|Price:||Free* [*Free Regsitration Required]|
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?
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.
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
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!
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.