MAGAZINES

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
This Week @ the MC Press Bookstore

 

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 >>

MC Webcast Center
 

SB SkyView PPL 5212FEATURED WEBCAST

Coffee with Carol: Step by Step Approach to Implementing Object Level Security

More organizations are realizing the need for implementing object level security – especially for database files that contain information which must comply with various laws or regulations. But the question many administrators have is, how do you secure files without breaking the application or other processes?

Watch the On-demand Webinar Now!

Be sure to check out these other useful offerings in the MC Webcast Center.

 

 

*Some offers may be limited to U.S. and/or Canadian citizens only. Please see the site for details.


Don’t “Play” with IT problems. Instead, visit the MC Webcast, MC White Paper, MC Software, MC Case Study, MC Security, and MC Disaster Recovery Centers where you’ll find the widest selection of white papers, software, webcasts and more to help you resolve your worst IT issues. We’re even giving one lucky person a Sony PlayStation Vita console worth $250! Visit the MC Resource Centers today and select as many of the FREE offerings you would like to receive. While there, enter the contest and you may just win that PlayStation Vita for yourself!

 

Have a On-Demand Webcast you would like to list? click here or call (208) 726-6822 for information.

 

 


Read More >>

In the News

Read More >>
Support MC Press - Visit Our Sponsors

 

Forums Sponsor

POPULAR FORUMS

 

Forums

 

Search Sponsor

 

 

Search


Read More >>
   MC-STORE.COM