FEATURE ARTICLES >>

Go Mobile with IBM i Access for Web

IBM i Access for Web is the newest weapon in the IBM i admin's mobile arsenal.

steve pitcherWritten by Steve Pitcher

I've been a fan of IBM i Access for Web for a long time. About five years ago, my company started giving tablets to our sales team in the field, and IBM i Access for Web quickly became an invaluable tool for securely accessing green-screen applications.

Read more >>
 
SQL 101: String-Related Functions, Part 2 - Changing Case of a String Without %XLATE and More

RPG provides a few ways to replace characters in a string, such as the %XLATE BIF. SQL also has interestingand, more importantly, easy to usefunctions to transform strings, changing the case of its characters or replacing them altogether.

rafael victoria preiraWritten 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.

Read more >>
 
TechTip: Running PHP Scripts - Zend Server

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.

david shireyWritten 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.

Read more >>
 
Practical RPG: Work Files and EXTFILE

Sometimes the only answer to a problem is a work file, and ILE RPG makes it really easy to use one.

joe plutaWritten by Joe Pluta

Work files aren't exactly sexy. With it being so easy to embed SQL into RPG, work files seem absolutely passé. Even back in the olden days, the joy of OPNQRYF allowed us to avoid the need for work files. (If you find yourself suddenly twitching and muttering to yourself, take a breath; this article is not about OPNQRYF!) Today we revisit the concept of work files and see where they still makes sense and just how easily they fit into the new world of ILE.

Read more >>
 
RPG Academy: /FREE Your Code – What the Most-Used Operation Codes Look Like in Free-Format

It's time for a few more examples of free-format code, which help you memorize the coding rules and will speed up your transition to this new coding style.

rafael victoria preiraWritten by Rafael Victória-Pereira

The previous TechTip introduced the rules you need to abide by to write code in free-format and provided a simple example. This time around, I'll provide additional examples and discuss a few important things you'll need to keep in mind while coding in this new way.

Read more >>
 

INDUSTRY NEWS >>

HelpSystems Makes Data Warehousing Easy and Worry-Free

New release enhances data warehouse management for users.

Read more >>
 
IBM Watson Analytics for Social Media: New Pricing Options for Organizations with Multiple Users

IBM Watson Analytics for Social Media can help marketing professionals tackle their biggest challenge: knowing their audience.

Read more >>
 
IBM Security QRadar Core Appliance QFlow Collector 1202-C/1301-C and 1310 SR-C/LR-C

IBM Security QRadar Core Appliance QFlow Collector 1202-C/1301-C and 1310 SR-C/LR-C support specific security requirements with hardware manufactured in North America.

Read more >>
 
The IBM Power Systems Family Offers the Following Option for the IBM Power S822 Server

 

4-core processor card for entry clients (#EPXN)

Read more >>
 
IBM Data Engine for Hadoop and Spark - Power Systems Edition

An integrated and optimized solution for high-performance Hadoop-based and Spark-based analytics

Read more >>
 
Fresche Legacy Named One of Montreal's Top Employers for 2016

Employee-friendly working conditions and opportunities for growth help Fresche employees smile while they work.  

Read more >>
 
ASNA Announces Business Partners in Morocco and Mexico

ASNA has acquired two more international distributors, one in Morocco and one in Mexico.

Read more >>
 
FieldFLEX Mobile for TRIRIGA

FieldFLEX Mobile for TRIRIGA applications bring the power of IBM TRIRIGA Integrated Workplace Management processes to mobile devices.

Read more >>
 

VIDEOS>>

Introduction to Configuring iAccess Servers to use SSL

To see a list of all the MC Press videos, click here

UPCOMING EVENTS >>

Thu Feb 11 @11:00 - 12:00PM
Signing Documents Doesn’t Have To Be So Hard

Events Calendar

February 2016
S M T W T F S
31 1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 1 2 3 4 5

LATEST COMMENTS >>

RESOURCE CENTERS >>

NEW eBook in the MC Resource Center

BCD Software

Top 10 Reasons to Choose PHP for IBM i Web Application Development

 

MC PRESS STORE >>

NEW BOOK!

Move from OPM to ILE...and Beyond

EVOLVE YOUR RPG CODING

ORDER YOUR COPY

*******************

Click for this Week's

Bookstore Special Deals

WEBCAST

MC Webcast CenterFEATURED WEBCAST

See What i Can Do With Modern RPG Development

Your applications deserve more than just a new look! Change the perception of the IBM i as “old” with modern development tips from IBM and Profound Logic Software.
Watch as Barbara Morris, Brian May and Alex Roytman dive beneath the GUI surface to show the benefits of:

 

  • Working with free-format RPG in IBM i TR7
  • Breaking free from “The Cycle” of traditional RPG development
  • Going beyond the 10 character limit in display and database files
  • And more!

You'll also see a live demonstration of these techniques as the presenters create a modern web application before your eyes! 

 

Watch the Webinar Now!

 

TRIAL SOFTWARE

MS Office Connector for Query/400

NGS' Qport Office enables Windows users to run IBM Query/400 queries to: 

 - Create and update Excel spreadsheets and Access databases

 - Create Word documents

 - Send to Windows screen and PC printers

No query conversion is required. Works with i5/OS V5R1 & above. Installs in minutes!

If you don’t have a budget to replace IBM Query/400, but want your users to have one click enhanced output of their queries.… Request the online license agreement and product download instructions today!

Offer good through December 31, 2013.

   MC-STORE.COM

Latest Offer from the MC Press Bookstore >>

Element Break

NEW BOOK!

 

Move from OPM to ILE...and Beyond
Evolve Your RPG Coding
 ORDER YOUR COPY TODAY
 Element Break

 Bookstore Special Offer
Take an Extra 10% Off Any Top 10 Bestseller

 

eBook Special >>

Save 20% Off the Hard Copy Sale Price

 ShopeBooks