FEATURE ARTICLES >>

TechTip: Riding the Rails, Part 2

Go further into the Rails generators and Convention over Configuration. It just keeps getting better. Saving time never felt so good.

aaron bartellWritten by Aaron Bartell

In the January 2016 article "Riding the Rails, Part 1," I introduced you to how a Rails project is created. We walked through the various files and directories that were generated. We also made it through starting the Rails web server and ended with being able to see a "Hello World" type of screen. In this article, we'll pick up where we left off by generating a Create, Read, Update, Delete (CRUD) application.

Read more >>
 
TechTip: How to Change a Database Code Set

Learn how to migrate data from a non-Unicode database to a Unicode database.

mohan saraswatipuraWritten by Mohankumar Saraswatipura

Editor's note: This article is an excerpt from the book DB2 10.1/10.5 for Linux, UNIX, and Windows Database Administration (Exams 611 and 311): Certification Study Guide.

 

 Both BLU and pureScale require databases to be Unicode, so you should create all new databases as Unicode. Chances are good that the requirement to convert data to a Unicode code set will happen. Because a database cannot be altered to a different code set, this will mean you must unload and load the data.

 

 In the past, string units of character data have been stored in a relational database in bytes. So for a single-byte character set (SBCS), each character represents one byte. The string unit of the column data type is a byte, sometimes referred to as an octet.

Read more >>
 
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 >>
 

INDUSTRY NEWS >>

TD/OMS Integrates with WebSmart PHP to Enable Robust PHP Web ALM on IBM i

The Remain Software IBM i Application Lifecycle Management solution, TD/OMS is now integrated with WebSmart PHP from BCD Software to enable PHP and RPG developers to deliver high quality and modern web applications quickly, within budget and according to best practices and standards.

Read more >>
 
IBM Launches Cloud Data and Analytics Marketplace for Developers

IBM announced a broad expansion of its Cloud Data Services portfolio with more than 25 services now available on the IBM Cloud.

Read more >>
 
IBM Study: Leading CEOs Aim to Transform Business with Cognitive Computing

Half of leading CEOs believe cognitive computing will revolutionize their business in the next three to five years.

Read more >>
 
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 >>
 

VIDEOS>>

Introduction to Configuring iAccess Servers to use SSL

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

UPCOMING EVENTS >>

Tue Feb 16 @19:00 - 10:00PM
OCEAN User Group Meeting - POWER Linux
Wed Feb 17 @10:00 - 10:45AM
Tango/04 Introduces the New Alignia for Business Processes
Wed Feb 17 @12:30 - 01:30PM
See What's New In Profound UI 5.3
Wed Feb 17 @14:00 - 03:00PM
Data Breaches - Is IBM i Really At Risk?
Thu Feb 18 @10:00 - 10:30AM
What’s New with Robot?
Thu Feb 18 @12:00 - 01:00PM
Webinar: Learn Why Managed File Transfer is becoming Popular
Thu Feb 18 @12:00 - 01:00PM
Learn Why Managed File Transfer Is Becoming Popular

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