TechTips


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 
TechTip: Dynamic Menu Using Tree Data Structure PDF Print E-mail
Tips & Techniques - System Administration
Written by George Karkavitsas   
Friday, 20 December 2013 00:00

This method for deploying menus uses only three objects to represent as many menus as needed. And menus can be changed by editing the file's records, instead of the code.

george karkavitsasWritten by George Karkavitsas

A menu is a list of options from which the user makes a selection. Each option is a brief description of the job that will be run when the user makes that selection. An option can lead to a program or to another menu of options. In IBM i, a menu consists of one display file, one message file, and one *MENU object [1]. In the IBM i environment, the display file contains the menu image, the message file contains the commands, and the *MENU object contains the name of the display file and the message file. In order to create one menu, we have to create a source file for the specified menu, define prompts for the menu image, define the command source for the menu, and finally save and compile the menu and command sources. If we want to change the menu, we have to reedit the code and recompile objects. This method is inconvenient if there's a large amount of menus, if we need to change options, or even if we want to avoid editing code.

Add a comment
Last Updated on Thursday, 19 December 2013 16:30
Read more...
 
User Rating: / 6
PoorBest 
TechTip: Add Lock Detection to Your DB2 for i Arsenal PDF Print E-mail
Tips & Techniques - Database
Written by Michael Sansoterra   
Friday, 13 December 2013 00:00

Use the table function equivalents of Display Record Lock (DSPRCDLCK) and Work with Object Locks (WRKOBJLCK) in your SQL code.

Written by Michael Sansoterra

If you've ever wanted to yell at users and tell them to exit a specific screen (or wanted to just happily end their job automatically) because they're locking a record, then this tip is for you. Best of all, you'll be able to use this functionality right from the comfort of your SQL code.

Add a comment
Last Updated on Friday, 13 December 2013 00:00
Read more...
 
User Rating: / 1
PoorBest 
TechTip: Dip Your RPG Toe into the JavaScript Framework Pool PDF Print E-mail
Tips & Techniques - Web Languages
Written by Robert Swanson   
Friday, 06 December 2013 00:00

Valence provides a free and easy way to explore this exciting web and mobile technology.

robert swansonWritten by Robert Swanson

Of all the interfaces used to interact with business data over the years, arguably nothing has evolved more rapidly than the technology behind what we see in today's desktop and mobile web browsers.

Add a comment
Last Updated on Thursday, 05 December 2013 12:18
Read more...
 
User Rating: / 3
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