Query & Reporting for IBM i Users 1.Qport Office for Query/400: No license fee for 2 users. Run IBM Query/400 queries from Windows. Create/refresh Excel sheets, Access tables, & Word docs. 2.NGS SDK - $895:Query & Web reporting for 1 developer & 1 concurrent user. Fee includes online education & support. 3. NGS-IQ: Query, reporting, & OLAP. Windows, Web, & 5250 interfaces. Date math, conditional calculations, prompting, email. Output to Excel, Word, Access, PDF, DB2, CSV, & more. www.ngsi.com
RPG provides a few ways to replace characters in a string, such as the %XLATE BIF. SQL also has interesting—and, more importantly, easy to use—functions to transform strings, changing the case of its characters or replacing them altogether.
Written by Rafael Victória-Pereira
The previous article in this series discussed a set of scalar functions you can use to convert data to its representation in string format. Once this data is in string format, you can use it with text information from your files in order to create descriptions or other texts, which you can use in reports. However, these texts might require a different type of conversion; their case might not be the most adequate, or you might want to replace a character somewhere in the middle of the string. I could argue that his is also a conversion, albeit a different one.
We looked at WAMP/MAMP/LAMP and how they can quickly and cheaply give you the ability to run the PHP scripts that you develop on your PC. But other options are available.
Written by David Shirey
Even though MAMP and its two amigos do a good job of letting you run your PHP scripts, there are other, more sophisticated ways to do this. And the first thing that we will look at is using Zend Server to provide the server capability for you.
This ain’t your mama’s RPG! Time to move on from OPM—with Evolve Your RPG Coding. This comprehensive new book gives you all the tools to move to a more modern, modular, and efficient ILE RPG. The book guides you through the transition at a comfortable pace, making every ILE concept totally accessible. You’ll start with simple, easy-to-understand examples and analogies to OPM, then advance to complete and complex ILE code. Finally, you’ll go beyond ILE with a detailed discussion of SQL, code organization, and structure. Pre-order your copy today!
Now in its second year, HelpSystems surveyed over 800 IBM i users from around the world to produce the IBM i Marketplace Survey Results. The expanded 2016 survey builds on last year’s results to provide even greater insight into the IBM i marketplace.
From manufacturing and retail to finance and healthcare, IBM i professionals from around the world reported their plans and concerns for their IT environments, revealing how IBM i is being used and how it relates to their broader IT objectives.
Download the survey results to see how over 800 of your peers on the platform address:
Today’s businesses must be available 24/7 with fewer people having to manage more complex systems and processes.
IT departments receive a constant bombardment of information from a diverse variety of operating systems, business applications, and critical processes and support a complex array of servers and devices running across their entire network.
With tight resources and the need to keep costs in check, more and more is expected of IT operational staff to handle this information efficiently. They need to ensure a swift response with appropriate actions, that essential data is received at the right time, prove service levels are maintained, that contingency and high availability strategies are fully operational, and that vital business activities run smoothly and without disruption.
What kind of safety net processes can you put in place so you can combat information overload, yet not miss a single thing, drop the ball, or cause a negative impact on the business—and more importantly, how do you go about it?
Learn how to handle the daily deluge of information and discover five strategies you can deploy to become an IT superhero in your organization.
For all manufacturing industries, growth remains top of mind. Post-recession cautiousness has given way to confidence and more ambitious business goals. From automotive to fashion, more manufacturing leaders are ready to take bigger risks in the hopes of bigger payoffs, and optimism is the highest it’s been in years.
To help manufacturers choose the right software in a rapidly changing industry landscape, this guide will explore four key technologies that are essential to any successful manufacturing operation:
Enterprise Resource Planning (ERP)
Enterprise Asset Management (EAM)
Configure Price Quote (CPQ)
Supply Chain Management (SCM)
We’ll discuss the market trends increasing the need for adoption of each technology, provide a “shopper’s checklist” of essential features and functions, and share success stories from real-life industry leaders. This guide will also outline how Infor’s industry-specific software and cloud-based technology are helping global companies thrive.
We've all heard the complaints from IBM i users: "Green screens look outdated. I want to use my mouse. What about mobile?"
Before decision-makers approve your modernization project, you'll need to make a compelling business case and highlight why it’s about more than giving your applications a pretty face. It's also about adding value to your IBM i.
Download this ebook to learn about the top business reasons for green screen modernization, including:
Modern, browser-based look and functionality
Improved workflows and access to information
Leveraging and future-proofing existing applications
Increased end-user productivity
Taking advantage of mobile devices
You'll also see real-world examples that include screenshots and links to videos.
Creating mobile applications for IBM i on Power Systems doesn't have to be difficult!
Mobile applications can take your business to new levels of engagement, customer support and competitiveness. By making your ERP, Sales, Line of Business, and other applications mobile, you empower your workforce to get more done - from anywhere, at any time. If your business runs on IBM i (formerly known as AS400 or iSeries) there's no need to worry. You can easily make your RPG applications available on any mobile device!
Read this free white paper, and learn how you can overcome the most common challenges to mobile for IBM i shops, including:
*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 and MC Software 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!