November 10, 2017
- LEAD ARTICLE: TechTip: SQL2XLSX - The Starter Kit
- FEATURED ARTICLE: Key Considerations for Establishing a BYOD Policy
- FEATURED ARTICLE: How Can I Determine What an IBM i User Profile Is Used For?
- NEWS HIGHLIGHT: IBM Expands Watson Data Platform to Help Unleash AI for Professionals
- WHITE PAPER: White Paper: Node.js for Enterprise IBM i Modernization
- MC VIDEO SHOWCASE: Design an Invoice in 10 Minutes
- EVENT: How to Use Sequel from a Browser
- MC PRESS MAGAZINE: A Small Intro to Big Data, Part 3: HFDS and the MapReduce Algorithm
Two popular utilities from some years back get updated, and a favorite author from the past resurfaces.
By Giuseppe Costagliola
It's been over a decade since I presented two utilities that gave you the ability to create XLS worksheets from an SQL instruction in System i. Now it's time to present a revamped version of these utilities, the new SQL2XLSX command that will allow you to create XLSX worksheets.
Bring Your Own Device is considered a lower-cost way to equip employees with mobile devices for business. Before you go that route, there are numerous issues of which to be aware.
By John Ghrist
The proliferation of mobile devices is transforming the way we live our lives and, similarly, the way we do business. Mobile devices can make employees more productive and more motivated, as well as help streamline many routine business operations.
After surveying 500+ IBM i professionals, we discovered:
- The state of IBM i modernization in today's businesses and their goals for the future
- The effect legacy applications have on the businesses' internal and external processes
- The #1 concern upper managers have with the IBM i, and how to combat it
...and much much more!
Download your copy of The 2017 State of IBM i Modernization today.
1. Affordable Cloud Solutions
2. Efficiencies of MIMIX
3. Rising Cost of Downtime
This collaborative effort from Connectria Hostingand Vision Solutions will provide a review of the core causes and costs of both planned and unplanned downtime and will then provide a detailed discussion of current options for IBM i High Availability and Disaster Recovery in the Cloud.
Most importantly, as you read you will learn why true HA and DR protection are now within reach of even the smallest of businesses.
It's time to make your apps proud to be seen! Whether you have green screens or a drab GUI, your outdated apps can benefit from modern source code, modern GUIs, and modern tools. Alex Roytman and Liam Allan show you how Free-format RPG and Node.js make it possible to deliver apps your business will love.
You'll learn how you can use both Profound UI and Profound.js to: Transform legacy RPG code to modern free-format RPG and Node.js; Deliver truly modern application interfaces with Profound UI; Extend your RPG applications to include Web Services and NPM packages with Node.js.
High availability for IBM i has been a hot topic in 2017, becoming the #2 IT priority just behind cybersecurity. And no surprise with these two topics so closely tied to your most valuable asset: your irreplaceable business data. You must be asking yourself: am I doing everything I can to protect my organization's data? Tune in as our panel of IBM i high availability experts deliver lively discussion around the top high availability issues of today.
Once data is gone, it's gone...unless you have a data replication layer in place to protect it. Learn the value of strategic solutions and how to implement them in a hurry...watch now!
ACO MONITOR is a complete systems management solution for your Power Systems running IBM i. ACO MONITOR manages your Power System 24/7, uses advanced technology (like two-way messaging) to notify on-duty support personnel, and responds to complex problems before they reach critical status.
ACO MONITOR is proven technology and is capable of processing thousands of mission-critical events daily. The software is pre-configured, easy to install, scalable, and greatly improves data center (and staff) efficiency.
Produce bar code labels, electronic forms, ad hoc reports, and RFID tags – without programming! MarkMagic is the only document design and print solution that combines report writing, WYSIWYG label and forms design, and conditional printing in one integrated product. Why support 5 different products, when you can do it all with MarkMagic?
Sometimes you run across a user profile and you see that it's being used, but you have no idea of its purpose. This article discusses how to discover a profile's use.
By Carol Woodbury
When helping clients remove profiles from their systems or reduce authorities assigned to profiles, I often face a situation in which the current administrator is uncertain whether a profile is being used and, if it is, what it's used for. The first time I was faced with the dilemma of determining a profile's use, I thought it would be easy. Simply enable object auditing of *ALL on the profile and see when it's being used, right? Wrong. Not all operations on all object types are audited. When I checked Appendix E of the IBM i Security Reference manual, I realized that the use of a user profile is not audited via object auditing.