TechTips


Partner TechTip: Convert Queries for Increased Performance and Modern Results PDF Print E-mail
Tips & Techniques - Database
Written by Heath Kath   
Friday, 28 February 2014 00:00

Don't let a library of useful but outdated queries stop you from modernizing how you deliver your data.

heath kathWritten by Heath Kath

Are you still running IBM i green-screen queries? How many queries are you dealing with? Are you finding it hard to manage all those queries? Are your users tired of waiting for a slow-running query that can use only the Classic Query Engine (CQE)? Would your users prefer a modern, graphical interface with more distribution options?

Add a comment
Last Updated on Friday, 21 February 2014 14:17
Read more...
 
User Rating: / 1
PoorBest 
TechTip: Getting Free-form RPG on your IBM i PDF Print E-mail
Tips & Techniques - RPG
Written by Joe Pluta   
Friday, 21 February 2014 00:00

You may have heard that entirely free-form RPG is now available; this tip tells you how to start working with it.

joe plutaWritten by Joe Pluta

RPG /free (also known as free-form RPG) has recently gone entirely free. At least, the compiler has. Unfortunately, the source editing tools haven't caught up yet (and in the case of SEU, I don't think they ever will). That's probably the reason that you won't see the new compiler capabilities even if you update to the latest Technology Refresh. Instead, you'll need to install a specific PTF. Then you can at least compile a program, even if the editor doesn't like it.

Add a comment

Last Updated on Thursday, 20 February 2014 12:40
Read more...
 
TechTip: Excluding Files Using GNUtar or AIX tar PDF Print E-mail
Tips & Techniques - Programming
Written by David Tansley   
Friday, 14 February 2014 00:00

Read on to find out which is the right choice for you.

david tansleyWritten by David Tansley

When you need to back up a file system or perhaps do some ad hoc directory backups, you've got two tar utilities you can use: AIX tar or GNUtar. In the past, admins have usually gone for GNUtar when archiving big files because in early releases of AIX the file size limit was 2GB. However, since late AIX 5.3, you can archive files up to 8GB.

Add a comment
Last Updated on Wednesday, 12 February 2014 13:49
Read more...
 
User Rating: / 2
PoorBest 
TechTip: Get to the Time Machine, Marty! PDF Print E-mail
Tips & Techniques - SQL
Written by Scott Forstie   
Friday, 31 January 2014 00:00

Let's make a quick trip back to six years ago.

Written by Scott Forstie

In 2007, with the tireless editorial help from Skip Marchesani, I wrote an all-inclusive article entitled "Procedures, and Functions, and Catalogs! Oh My!". The fine folks at MC Press published the article in February 2008.

 

This article has served its intended purpose, providing customers and IBMers alike a resource to bridge the gap between the SQL Reference and the successful deployment and maintenance of SQL routines with DB2 for i. Even though I lack a DeLorean time machine, I feel compelled to return to this article and provide a few updates.

Add a comment

Last Updated on Tuesday, 28 January 2014 16:07
Read more...
 
User Rating: / 2
PoorBest 
TechTip: So Many Logical Files, So Little Time PDF Print E-mail
Tips & Techniques - RPG
Written by Craig Rutledge   
Friday, 24 January 2014 00:00

Speed up your search with the free, open-source JCRLKEY utility.

craig rutledgeWritten by Craig Rutledge

Why open source? Real simple. I use most of these pain-eliminator tools on the job every day to save myself time and effort. As I stated on my website, many people around the world have made excellent suggestions for improvement or enhanced functionality to meet their specific requirements. After making a requested modification, it invariably winds up with the tool being even more useful to me!

Add a comment

Last Updated on Thursday, 23 January 2014 11:24
Read more...
 
RPG Academy, Part 1: From OPM to ILE, ASAP PDF Print E-mail
Tips & Techniques - RPG
Written by Rafael Victoria-Pereira   
Friday, 17 January 2014 00:00

If you still write code as you did 20 years ago or have RPG ILE on your resume but don't actually use ILE, this is for you. This series will help you transition to RPG ILE by explaining the concepts of ILE, including the pros and cons.

rafael victoria preiraWritten by Rafael Victória-Pereira

I like it when my readers reach out to me with questions about my articles; every writer does. It means people are actually reading and trying to use the stuff I write about. However, I've noticed more and more that the questions are not about the Tips per se: they're about the foundations that every RPG programmerwhether novice or expert with 20 years of experienceshould know. This TechTip series will (hopefully) guide the reader on a quest for better programming. Better skills, better standards, and most of all, more-efficient code. So, without further ado, let's get started!

Add a comment
Last Updated on Friday, 17 January 2014 00:00
Read more...
 
User Rating: / 1
PoorBest 
TechTip: Program Messages 101 PDF Print E-mail
Tips & Techniques - RPG
Written by Joe Pluta   
Friday, 10 January 2014 00:00

joe plutaProgram messages are a fundamental part of the operating system, and the more you know about them the better.

Written by Joe Pluta

RPG has come a long way from its original, standalone report-generation days. We can integrate features from many other languages and from the operating system itself via simple calls. That additional functionality, though, leads to additional complexity. Many times, errors occur under the covers of our RPG programs, and while often it's enough just to know an error occurred (say on a file open), sometimes it's important to know the details of the error. The IBM i has a powerful messaging system that allows you to get that information, but you need to access it. This is the first in a series of tips that will help you do just that.

Add a comment
Last Updated on Friday, 10 January 2014 00:00
Read more...
 
User Rating: / 1
PoorBest 
TechTip: What's New in Free-Format RPG IV? PDF Print E-mail
Tips & Techniques - RPG
Written by Jim Martin   
Friday, 03 January 2014 00:00

 

jim martinThe Technical Refresh 7 (TR7) and PTFs are now available.

 

Written by Jim Martin

 

Last October, IBM announced big changes in free-format RPG IV, to be available in late November. If you are ready to try out the new capabilities of free-format RPG IV, you'll need Technology Refresh 7 (TR7), cumulative PTFs, and PTF SI51337 (which isn't a part of the cumulative package). If you haven't heard about these changes, this article will provide you with a basic idea of most of the changes.

Add a comment
Last Updated on Thursday, 02 January 2014 14:02
Read more...
 
User Rating: / 1
PoorBest 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 5 of 181

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