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

June 26, 2015 | Volume 12 Issue 25

ISSUE HIGHLIGHTS

TOP STORY: TechTip: Store and Parse JSON Data Natively with DB2 for i
FEATURED ARTICLE: TechTip: Wizard Analytics on DB2 Web Query, Part 1
NEWS HIGHLIGHT: Did You Know That Most IBM i Sites Change More Than Three Pickup Trucks’ Worth of Data Per Day?!
WHITE PAPER: Business Intelligence for the IBM i Customer
EVENT: No Time for IBM i Security? No Problem.

Sponsor - The MC Press Bookstore
 

Don't miss out! This is the hands-on guide to IBM's strategic language for IBM i. Database Design and SQL for DB2 delivers everything you need to know about database design and SQL. Author Jim Cooper gives you all the tips and techniques you need in one convenient place, whether you’re a beginner or an advanced developer. Includes real-life examples to help you hone your skills. The bonus companion website explains embedded SQL and explores client-side technologies.


Read More >>

Feature Article - TechTip
 
TechTip: Store and Parse JSON Data Natively with DB2 for i

Learn how the latest DB2 for i features can reduce development time when interacting with the popular JSON data format.

Written by Michael Sansoterra

In my prior tip about using JSON with DB2 for i, I articulated a method of accessing JSON with SQL by use of Java external user-defined functions (UDFs) that convert JSON to XML and XML to JSON. Starting in IBM i 7.1 TR10 (Database Group PTF Level 34) and IBM i 7.2 TR2 (Database Group PTF Level 5), IBM has added native JSON support to the DB2 for i database engine. Keep in mind that, at this first release, the JSON support is still considered a "technology preview," so be sure to test any JSON implementations carefully before using them in production. Also, based on available documentation, some of these features and JSON functions are not yet advertised by IBM for the IBM i and may be subject to change.


Read More >>

Sponsor - The MC Press Bookstore
 

Get the latest and greatest advice from the DB2 for z/OS gurus! DB2 11: The Ultimate Database for Cloud, Analytics, and Mobile provides essential advice and explanations to ensure a successful upgrade--including feedback from early customer experiences. This book describes new DB2 11 features that can help you respond cost-effectively to the data explosion resulting from mobile applications, cloud computing, social media, and smart devices. Understand the new functions in DB2 11, plan your migration strategy, and learn about important new support for application compatibility. Get your copy today!


Read More >>

Feature Article - TechTip
 
TechTip: Wizard Analytics on DB2 Web Query, Part 1

Business analysts, developers, administrators, and even non-technical individuals can get started generating sophisticated reports and visualizationsover their own datain minutes!

kathy steinbrinkWritten by Kathy Steinbrink

IBM DB2 Web Query for i is an analytics tool for modernizing Query/400 reports and delivering analytics to the web or mobile devices. It's a web-based Business Intelligence (BI) solution for visualizing, analyzing, and sharing critical business data. Available since 2007 on the IBM i platform, DB2 Web Query has delivered through the years a steady heartbeat of new function.


Read More >>

Sponsor - The MC Press Bookstore
 

This is the definitive guide to preparing for IBM’s Certification Exam 612: DB2 10 for z/OS Database Administration. This book, written by members of the team that created the test, provides a comprehensive review of all the topics covered on the exam and introduces you to important new features found in DB2 10 for z/OS. Get your copy today. >>


Read More >>

MC White Paper Center
 

Don't miss these great Featured White Papers:

 

Data Masking and Assuring Security During Software Testing

Data masking during software testing is not the simple process that the uninitiated might suppose. Gone are the days when replacing personally identifiable information with random characters makes the grade. Learn why entering into your data masking project with a clear, systematic road map will help you better understand these critical data protection factors during software testing: 1) Where the sensitive data is located 2) What data needs to be masked 3) How to properly desensitize the data to maintain compliance

Element Break

8 Very Good Reasons to Use Your Power i For Shipping

Learn how companies are reducing shipping costs by Centralizing all of their Shipping Systems and Transportation Management Systems (TMS) on One Platform with One Vendor. See how companies deployed an enterprise-wide, multi-carrier shipping solution to manage both their Parcel and Freight shipments directly from their IBM i, and seamlessly integrated it to their back end IBM i ERP and WMS. This Whitepaper examines eight reasons for centralizing standalone shipping solutions on the IBM i. In addition, you will see how a Modular TMS Solution integrated with ERP has driven significant efficiencies and cost reductions in companies shipping and transportation operation.

Element Break

Getting Started with IBM i Security

The IBM i platform is known for its robust security capabilities. And it’s this reputation that often keeps staff from giving IBM i the same attention as other platforms. But as new staff rotate in, IBM i expertise rotates out. Eventually organizations find themselves with maintenance gaps and dangerous security holes on a system once considered bulletproof. Even worse—no one has the knowledge to patch them up! From beginner basics to advanced tactics, this white paper provides the background and instruction you need to restore your IBM i security back to its former glory.

Element BreakMobile Computing and the IBM i

Mobile computing is rapidly maturing into a solid platform for delivering enterprise applications. Many IBM i shops today are realizing that integrating their IBM i with mobile applications is the fast path to improved business workflows, better customer relations, and more responsive business reporting. The ROI that mobile applications can produce for your business is substantial. This ASNA whitepaper takes a look at mobile computing for the IBM i. It discusses the different ways mobile applications may be used within the enterprise and how ASNA products solve the challenges mobile presents. It also presents the case that you already have the mobile programming team your projects need: that team is your existing RPG development team!

Element BreakBusiness Intelligence for the IBM i Customer

Are you on information overload from the barrage of announcements and ads for BI solutions, including IBM’s new DB2 Web Query V2.1? End the confusion and get informed. This White Paper guides you in evaluating which solution may be the best fit for your company, users, budget, environment and more. It also examines:

  • IBM’s analytics and services strategy
  • the repackaged DB2 Web QueryV2.1
  • IBM’s Cognos solution
  • other BI software in the market

The White Paper offers a comparison of these products with NGS-IQ, NGS’ scalable, proven BI suite of products used by thousands of i customers of all sizes in virtually every industry.

It concludes with a section designed to help IBM i and DB2 supporters explain the strengths of the environment to critics and the uninformed.

Element BreakRobot in Modern IBM i Environments

As hardware and software technologies evolve, so too does the complexity of the data center.

IBM i often serves as the backbone for business-critical applications, including ERP packages, leaving other servers to run email, print serving, and the website—but users and other computing technologies still draw data from the transactional database on IBM i.

Robot systems management solutions have been helping customers manage IBM i operations for over 30 years. This white paper is intended primarily for IT management and attempts to explain, in plain English, the components of modern IBM i environments and how Robot can be deployed to maximize business objectives.

Download this white paper to learn about:

  • IBM i virtualization technologies like SAN, LPM, and VIOS
  • IBM i high availability and disaster recovery technologies like PowerHA and VTL
  • Robot automation solutions for enhancing the ROI of IBM i

Element Break

 

Plus Choose From The Full Selection in the MC Press White Paper 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 White Paper 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

POPULAR FORUMS

Forums

Search Sponsor

POPULAR SEARCHES

Search


Read More >>
   MC-STORE.COM