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

April 1, 2015 | Volume 14 Issue 7

ISSUE HIGHLIGHTS

TOP STORY: Practical SQL: DB2 at Home, Part 4, Making XML Data
FEATURED ARTICLE: RPG Academy: BIF Up Your Code! Part 4, Simplifying String Operations with BIFs
NEWS HIGHLIGHT: Cilasoft Introduces CENTRAL for IBM i
WHITE PAPER: Affordable Query Tool for Software Developers
EVENT: Applications to Go: Mobile Technologies on IBM i
MC VIDEO PORTAL: Introduction to Configuring iAccess Servers to use SSL

Sponsor - T.L. Ashford & Associates
 

TLA Forms from TL Ashford is the easiest, most cost-effective way to turn traditional IBMi spool files into Full-Color, professional forms in about 10 minutes! NO Programming is necessary to create forms using text with a wide range of fonts, a full selection of bar codes, including 2-dimensional bar codes, images, overlays, tables, lines, rectangles and circles.

How much time and money will you save yourself and your company? Watch this 2 minute video to learn more, and order a 30-day trial here.


Read More >>

Feature Article - Programming
 
Practical SQL: DB2 at Home, Part 4, Making XML Data

We've been using XML data in our relational world; now let's turn the tables.

joe plutaWritten by Joe Pluta

The previous "Practical SQL"articles have followed a theme of accessing your XML data in a relational way. Every article led us a little further down that path, and future articles will continue to do so. I've got a way, for example, to easily create a relational table from an XML document with a single line statement that you'll really love. But for now, I'd like to take a little detour and show the other side of the world: creating XML data from your relational files.


Read More >>

Sponsor - The MC Press Bookstore
 

  Have you heard? RPG is now fully free-format! This latest edition from RPG expert Jim Martin is your one-stop resource for free-format information. It’s a must-read for all RPG programmers, featuring completely updated code. See the new H, F, D and P specs in action in this easy-to-use reference guide. You’ll learn rules and syntax but also grasp how this modern style of coding can improve your overall productivity--from initial development through maintenance. Get your copy today!


Read More >>

Feature Article - Programming
 
RPG Academy: BIF Up Your Code! Part 4, Simplifying String Operations with BIFs

You can simplify your code with the set of string-related BIFs presented in this TechTip. Master them and you'll be the one pulling the strings of your code and not the other way around.

rafael victoria preiraWritten by Rafael Victória-Pereira

Working with strings in RPG can be a real pain: all of those MOVE and CAT op codes and work variables with different lengths just to "stitch" the appropriate string together!


Read More >>


Sponsor - The MC Press Bookstore
 

An old dog can learn new tricks! Flexible Input, Dazzling Output with IBM i is full of clever ways to get data into your IBM i system, as well as new techniques to export and present this data in a modern, business-friendly manner. No more boring spreadsheets or ugly printouts! Your DB2 data will look great in program-generated spreadsheets and browser-based, interactive charts. Whether you’re an old dog or not, you’ll get the most out of your ILE RPG programs with the open source, free tools in this smart new release! Order your copy today!


Read More >>

MC Webcast Center
 

Don't miss these Featured On-Demand Webcasts:

 

Affordable Query Tool for Software Developers

NGS’ Software Developer Kit (SDK) gives IBM i developers comprehensive query, dynamic mobile reporting, analytics and Web report design features at an affordable cost. Install and create meaningful outputs for managers in one day! Web page and portal integration, email, FTP are included.

The $895* SDK includes a one user license, online training, user manuals, one year of software maintenance; toll-free support and online incident reporting.

If you….

want to modernize beyond Query/400 and PC files transfers

need a Web reporting solution without the learning curve and overhead of DB2 Web Query

have many reporting needs, but a tight budget and small staff

 

view a demo; then order a Free Trial of the SDK.

* Limited time offer.

 

Element Break

The Explosion of Security Vulnerabilities Requires Diligent Act with Carol Woodbury & special guest Jeff Uehling

Carol is pleased to be joined for this Coffee with Carol by friend and former colleague Jeff Uehling, current Chief Security Architect for IBM i.  Jeff and Carol will be discussing a number of the recent Security Vulnerabilities which have had a huge, industry-wide impact on both hardware and software vendors - including IBM and the IBM i development groups. These security vulnerabilities include well-publicized ones such as Heartbleed, Bash/Shellshock and Poodle as well as numerous vulnerabilities that haven’t hit the media. These vulnerabilities exist in areas such as Java, OpenSSL and many networking areas of your systems.

 

IBM i has long been known as a secure platform on which you can run your business critical applications. However, securing the system requires careful attention to the system-wide security configuration options, managing the authority settings on your data objects which contain your business critical data (corporate assets), and - as importantly - staying current with your enterprise-wide maintenance and ensure the latest PTFs/Fixes are installed in order to close "real" or "potential" security holes.

 

Element Break

Take IBM i Everywhere with Mobile Apps – Watch the Webinar!

Is mobile an initiative for your business? Find out how you can go beyond Web applications to create applications with native device capabilities, such as Camera… even if you’ve never created a mobile application!
Watch this on-demand Webinar with IBM’s Tim Rowe and Profound Logic’s Scott Klement and Alex Roytman, and discover how you can create high-quality mobile applications using your existing RPG knowledge and the right tools.

You’ll learn:

  • How the IBM i platform supports mobile development
  • Why hybrid applications are a great option to deliver mobile apps with more functionality than Web apps can offer
  • How to develop mobile apps with native capabilities without becoming an Obj-C and Java expert, or using overly complicated tools

Element Break

Introduction to Configuring iAccess Servers to use SSL Presented by Carol Woodbury

Due to popular demand, Carol has updated her presentation on configuring iAccess to use SSL sessions to include, not just the step-by-step configuration guidance but also a discussion on the benefits and challenges of using certificates from a well-known CA (Certificate Authority) vs a self-signed certificate as well as practical tips for enterprise implementation.

Element Break

 

 


Plus choose from the Complete Collection in the MC Press Webcast Center

 

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

 

The MC Resource Centers bring you the widest selection of white papers, software, webcasts and more for you to choose from and at MC Press we’re all about choice. We’re even giving one lucky person the opportunity to choose their own prize in our “It’s All About Choice” contest for a $250 Best Buy gift card.  Visit the MC Webcast, MC White Paper, MC Software, MC Case Study, MC Security,  and MC Disaster Recovery 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 a $250 Best Buy gift card!

 

Have a Webcast you would like to list? click here or call (208) 629-7275 Ext.504 for information.

 

 


Read More >>

In the News

Vendors:  Have a press release to share?  Send it to MC Press.


Read More >>
The Latest from IBM

Read More >>
Support MC Press - Visit Our Sponsors

Forums Sponsor

POPULAR FORUMS

Forums

Search Sponsor

POPULAR SEARCHES

Search


Read More >>
MC Video Portal

MC Video Portal

Introduction to Configuring iAccess Servers to use SSL

 

Due to popular demand, Carol has updated her presentation on configuring iAccess to use SSL sessions to include, not just the step-by-step configuration guidance but also a discussion on the benefits and challenges of using certificates from a well-known CA (Certificate Authority) vs a self-signed certificate as well as practical tips for enterprise implementation.


Read More >>
   MC-STORE.COM