TechTips


TechTip: Getting off the Ground with PHP PDF Print E-mail
Tips & Techniques - Programming
Written by David Shirey   
Friday, 27 March 2015 00:00

PHP is a serious contender for "best bet" for developing robust web applications on the IBM i, but how much do we know about it? Or, more appropriately, how much do you know about it?

david shireyWritten by David Shirey

This is going to be the start of a series, a series on PHP. And that certainly seems appropriate as PHP is one of a number of ways to do web applications from the i. And from my point of view, it's one of the best ways. But unfortunately, it still remains pretty much one of the best-kept secrets in the i world for many of us.

Add a comment
Last Updated on Friday, 27 March 2015 00:00
Read more...
 
Partner TechTip: "Oh! Data Breach" Is Quickly Becoming the New U.S. National "Anthem" PDF Print E-mail
Tips & Techniques - Security
Written by Robin Tatam   
Friday, 20 March 2015 00:00

The current breach epidemic could impact IBM i, but it doesn't have to.

robin tatamWritten by Robin Tatam

Unless you're filing your taxes with an address listed as "under a rock," you're probably painfully aware of a few high-profile data breaches that have occurred in recent years. While Target, Home Depot, and Anthem might not openly share whether any of their compromised systems included IBM Power Servers, we all need to learn numerous lessons, regardless of the technology platform our critical data resides upon.

Add a comment
Last Updated on Friday, 20 March 2015 00:00
Read more...
 
TechTip: Dealing with Blank Checks in DB2 PDF Print E-mail
Tips & Techniques - SQL
Written by Kent Milligan   
Friday, 13 March 2015 00:00

Enhance performance by improving SQL coding practices.

kent milligan 117x117Written by Kent Milligan

Handing out blank checks in the world is definitely not a best practice if you're looking to avoid financial headaches and hardships. After a recent set of SQL performance engagements with clients, it's clear to me that a number of IBM i developers don't understand how to best check for blanks when using SQL with DB2 for i databases. As a result of these suboptimal coding practices, many developers are destined for performance and code maintenance headaches in the future.

Add a comment
Last Updated on Thursday, 12 March 2015 12:00
Read more...
 
User Rating: / 1
PoorBest 
Partner TechTip: 2015 IBM i Marketplace Survey Results Are In PDF Print E-mail
Tips & Techniques - IBM i (OS/400, i5/OS)
Written by Tom Huntington   
Friday, 13 March 2015 00:00

Has planning your IT initiatives on i ever felt like playing darts blindfolded? A new survey reveals what 350 of your peers on the platform are doing.

tom huntingtonWritten by Tom Huntington

Historically, the IBM i marketplace has had very little exposure, with few independent analyses of the way businesses use the technology. While IBM has funded studies from International Technology Group (ITG), organizations like Forrester and Gartner have considered this market to be similar to that of the mainframe: stable and not changing. On the highest level, that's nice to know, but those of us who are using this platform with SAN, VIOS, VTL, Java, PHP, and other modern technologies need a little more meat.

Add a comment
Last Updated on Thursday, 12 March 2015 14:05
Read more...
 
TechTip: Sinatra Sings, Ruby Plays PDF Print E-mail
Tips & Techniques - Programming
Written by Aaron Bartell   
Friday, 06 March 2015 00:00

Looking to develop your first web app with Ruby? Try Sinatra. Sinatra is a DSL for quickly creating web applications in Ruby with minimal effort.

aaron bartellWritten by Aaron Bartell

Frank Sinatra—classic music you can tap your foot to while coding. Sinatra the web framework? That's something you can use to quickly create a web app in Ruby with minimal effort. My history with Ruby-based web apps leans more on the RubyOnRails web framework. A framework that is beyond excellent, though, also takes time to learn how to fully use it. Sinatra on the other hand doesn't do as much "magic" as Rails. By "magic," I mean the things that just work and you don't know why. Sinatra simply has more in plain view, like how routing of requests works. In this article, I'll introduce you to Sinatra on IBM i and explain how to install and use it.

Add a comment
Last Updated on Friday, 06 March 2015 07:39
Read more...
 
User Rating: / 2
PoorBest 
Partner TechTip: Three Tactics to Optimize Your IBM i Disk Space PDF Print E-mail
Tips & Techniques - System Administration
Written by Chuck Losinski   
Friday, 06 March 2015 00:00

Don't wait for a critical iSeries storage issue to catch you off-guard. Instead, follow these top three tips for using Robot SPACE to manage your disk space automatically.

ChuckLosinski 116x116Written by Chuck Losinski

As the old adage goes, if a tree falls in the woods, does it make a sound if no one is there to hear it? If your disk storage is about to hit the threshold and you get no notification, will there still be a consequence? You bet.

Add a comment
Last Updated on Friday, 06 March 2015 00:00
Read more...
 
TechTip: SQL Date and Time Arithmetic PDF Print E-mail
Tips & Techniques - SQL
Written by Jim Cooper   
Friday, 20 February 2015 00:00

Are you looking for a hands-on approach that provides start-to-finish coverage of database design and SQL

Written by James Cooper

Editor's note: This TechTip is an excerpt from Chapter 6, "Single-Table Queries," of Database Design and SQL for DB2 (MC Press, 2013).

 

SQL on IBM i includes expressions and functions for working with date and time values. Externally, date values are character strings containing numbers for the year, month, and day and (in some formats) date separators. When a literal date is entered, the value is coded as a string. The format of the string depends on the values specified for the DATFMT and DATSEP parameters. For example, if *ISO format is specified, the following string represents May 1, 2011:

Add a comment
Last Updated on Thursday, 19 February 2015 11:25
Read more...
 
User Rating: / 1
PoorBest 
TechTip: More on Combining Multiple Row Values into a Single Row with SQL in DB2 for i PDF Print E-mail
Tips & Techniques - SQL
Written by Kent Milligan   
Friday, 13 February 2015 00:00

Leverage recursive table expressions to pivot row values into a single column.

kent milligan 117x117Written by Kent Milligan

After my last article, I had a number of readers express interest in a solution that would work on servers running pre-IBM i 7.1 operating system release levels. Luckily, recursive SQL capabilities were first made available with the DB2 for i V5R4 release, so this article will provide a solution that can run on release levels of V5R4 and newer.

Add a comment
Last Updated on Friday, 13 February 2015 00:00
Read more...
 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 1 of 185

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