MAGAZINES

MC Press Resource Centers
MC Systems Insight
MC Power Technology Manager
MC RPG Developer
MC Power Developer
MC TNT Tips 'n Techniques
MC AIX Expert
MC Linux Expert
MC Mobile on Power

 

September 21, 2012 | Volume 9 Issue 38

ISSUE HIGHLIGHTS

TOP STORY:  TechTip: Combining Aggregate and Detail in the Same SQL Result Set
ADVERTORIAL:  Partner TechTip: IBM i Security: The Simple Truth About IBM i's Network Exit Points
NEWS HIGHLIGHT: GoAnywhere Now Certified for Microsoft Server 2012
FORUM: Free MMAIL Utility Now Supports PDF Conversion
ON-DEMAND WEBCAST: Coffee with Carol: Step by Step Approach to Implementing Object Level Security
EVENT:  iBelieve New York - A Free IBM i Community Event
Manage Subscription | Contact Us

Sponsor - T.L. Ashford & Associates
 

Barcode400 Labeling Software makes it easy for IBM i users to design and print labels in minutes.

T.L. Ashford has over 28 years of experience in software development and backs that commitment with a highly qualified technical support team.

You can count on T.L. Ashford for your bar code, compliance and RFID labeling needs. Call 800-541-4893 to see what Barcode400 Software can do for you or use the Live Chat feature at www.tlashford.com


Read More >>

Feature Article - TechTip
 
TechTip: Combining Aggregate and Detail in the Same SQL Result Set

How can I do the impossible?

Written by Art S. Kagel

Suppose you're tasked to report on sales figures for the company's sales force. The report has to include the individuals' percentile contribution to the team, region, and company sales in addition to the raw sales numbers. Team percentile contribution to region and total company sales and region percentile contribution to total sales are also needed. You could run multiple queries—one to get the company totals, another to calculate the region totals, a third for the team totals, and finally a detail query by salesperson. Then you would have to perform the matchups of salesperson to team and region and then team to region to calculate the percent contribution for each of those and against the company total sales all in application code. No sweat, right?


Read More >>

Advertorial - PowerTech
 
Partner TechTip: IBM i Security: The Simple Truth About IBM i's Network Exit Points

Are you still debating the argument surrounding network exit points?

robin tatamWritten by Robin Tatam

PowerTech began selling a network exit point solution more than 16 years ago. Since then, hundreds of customers have embraced the concept of exit points, making Network Security our best-selling solution. However, many people remain unaware of the existence of exit points while others declare that they don't need them. Why is there such a marked difference of opinion? And who's right?


Read More >>

In the News

Read More >>
Support MC Press - Visit Our Sponsors

 

Forums Sponsor

POPULAR FORUMS

 

Forums

 

Search Sponsor

 

POPULAR SEARCHES

 

Search


Read More >>
   MC-STORE.COM