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: Sami Tosar
Country: Nepal
Language: English (Spanish)
Genre: Software
Published (Last): 20 March 2009
Pages: 437
PDF File Size: 20.27 Mb
ePub File Size: 2.75 Mb
ISBN: 669-5-57641-636-5
Downloads: 9398
Price: Free* [*Free Regsitration Required]
Uploader: Shalkis

Join Stack Overflow to learn, share knowledge, and build your career.

AS Technology: Creating AS Query WRKQRY

Based on this field being numeric 1. We’ll send you an e-mail containing your password. Submit your e-mail address below. This will output the required details to a file for you.

wkqry Its a very easy to use tool for displaying, extracting and reporting on data. The screen will look like: Hi, I am trying to join two files based on common field in wrkqry in select records when i am trying to join based on select records and give condition like T I need to run this query in a batch mode,just by changing the date range.


Unconfigured Ad Widget

Start a thread and discuss wrkqrt topics with top experts. Post as a guest Name. If the field data is going to wrqkry referenced elsewhere the select based on the newly defined field but save the original value in your output if it is to be used again. Forgot Password No problem! And that field is numeric? Karl Richter 2, 11 29 Share this item with your network: 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.

Now I want to add new column called country with field country name same country name for all eg IND.

WRKQRY Archives – IT Answers

Is there a way to place the count of a item on the same line instead of underneath each counted value? March 23rd, I know to write this SQL by using command: FLD1 I get an error data types are not compatible. Send me notifications when members answer or reply to this question. I ran into the same problem. But the problem is when i use this new field like: I may unsubscribe at any time.


sponsored links

Welcome to TechTarget’s expert community for technology professionals. Then in Select Summary Report Functions select 1 on your salary field.

Is there any way to work with this? Alternatively, you could look at the SQL based web-query product.

There was an error processing your information. Newer Post Older Post Home. Read the latest tech blogs written by experienced community members. Lastly in Define report breaks select break level as your dept number.

The next option down, the Define result fields option, is described thus: How to add a new column to as4000 file? May 5th, Urband 5 points Badges: Lady55 15 points Badges: Press F21 to select all. Your password has been sent to: