Programming


Book Review: Programming in ILE RPG, Fifth Edition PDF Print E-mail
Programming - RPG
Written by Bruce Guetzkow   
Wednesday, 18 May 2016 00:00

This book really hits the mark and is a must-read for all RPG developers.

bruce guetzkowWritten by Bruce Guetzkow

 

The fifth edition of Programming in ILE RPG by Bryan Meyers and Jim Buck provides an excellent progression of subject matter for the next generation of RPG developers. There is a strong emphasis on free-format coding with plenty of references to fixed-format code. This perspective on RPG will make it easy for students to learn RPG and aid experienced developers in making a transition to more modern coding techniques.

Add a comment
Last Updated on Wednesday, 11 May 2016 15:12
Read more...
 
SQL 101: String-Related Functions, Part 5—Cutting and Stitching Strings PDF Print E-mail
Programming - SQL
Written by Rafael Victoria-Pereira   
Friday, 13 May 2016 00:00

Stringscaping continues! This article explores functions to extract parts of a string that are similar to MS Excel functions and ways to stitch the strings back together. This “stitching” will introduce another function: LENGTH.

rafael victoria preiraWritten by Rafael Victória-Pereira

The functions discussed in the previous article allow you to add, replace, and remove characters from a string. While this is interesting and somewhat useful, being able to “stitch” two strings together is usually more useful. This article covers a group of functions that helps with that task.

Add a comment
Last Updated on Friday, 13 May 2016 00:00
Read more...
 
Practical SQL: GET DIAGNOSTICS PDF Print E-mail
Programming - SQL
Written by Joe Pluta   
Wednesday, 04 May 2016 00:00

SQL can be something of a black box, but the GET DIAGNOSTICS statement allows you to peek under the hood.

joe plutaWritten by Joe Pluta

SQL is especially powerful at set-based database operations: those operations that affect multiple rows at once. One of the coolest things a programmer can learn is how to write a single SQL statement that updates a whole set of records, all without the requirement of any sort of looping mechanism whatsoever. But usually not long after comes the realization that at some point you have to know how many records you updated. In the beginning, that was only available through the use of the little-known and obscurely named SQL result variables. This article shows you how that goes away with the GET DIAGNOSTICS statement.

Add a comment
Last Updated on Tuesday, 17 May 2016 14:17
Read more...
 
User Rating: / 1
PoorBest 
RPG Academy: /FREE Your Code - Convert Fixed-Format Code to Free-Format, Part 3 PDF Print E-mail
Programming - RPG
Written by Rafael Victoria-Pereira   
Wednesday, 04 May 2016 00:00

The last two TechTips provided some insights about the process of converting RPG “classic” code to free-format. This one covers a topic often overlooked, but extremely important: handling arrays.

rafael victoria preiraWritten by Rafael Victória-Pereira

Aside from the terrible trio (CABXX, TAG, and GOTO), I discussed in the previous TechTip another fact that’s hard for some to swallow: that MOVEA didn’t make it to free-format. This operation code is used for some specialized assignment functions related to arrays; it transfers character, graphic, UCS-2, or numeric values from factor 2 to the result field. However, there are some restrictions when moving numeric values. (Check IBM’s ILE RPG Reference Manual for details if you need to refresh your memory.) One of the fields must contain an array, and the fields cannot specify the same array, even if the array is indexed. The following operations are allowed:

Add a comment
Last Updated on Tuesday, 17 May 2016 14:09
Read more...
 
SQL 101: String-Related Functions, Part 4—“Stringscaping” with TRIM and Related Functions PDF Print E-mail
Programming - SQL
Written by Rafael Victoria-Pereira   
Wednesday, 20 April 2016 00:00

You have no idea what “stringscaping” is, do you? Well, it’s the not-so-old-because-it-was-just-invented art of landscaping strings. SQL allows you do that with a nice set of user-friendly functions.

rafael victoria preiraWritten by Rafael Victória-Pereira

If you want to landscape your garden, you use pruning shears and hedge clippers, right? Well, if you want to landscape your strings (or, as I called it, “stringscaping”), you use the SQL functions I’ll cover in this article and the next.

Add a comment
Last Updated on Wednesday, 20 April 2016 00:00
Read more...
 
Practical RPG: Using Work Files with SQL PDF Print E-mail
Programming - RPG
Written by Joe Pluta   
Wednesday, 06 April 2016 01:00

Create work files in SQL, but update them with ILE RPG—the best of both worlds.

joe plutaWritten by Joe Pluta

In a previous article, I went into some detail on using work files in ILE RPG. Next came an article that demonstrated how to build a work file using SQL. Here, I show you how to combine those two techniques in applications where you want to use SQL as much possible but you still need to use RPG to perform some in-depth calculations that SQL doesn't handle particularly well. The good news is that you can do that quite easily by using SQL to build a work file and then use ILE RPG to update the file with more complex calculations. After you're done, you can use SQL again to access the data, and everyone is happy!

Add a comment
Last Updated on Tuesday, 05 April 2016 12:21
Read more...
 
RPG Academy: /FREE Your Code - Converting Fixed-Format Code to Free-Format, Part 2 PDF Print E-mail
Programming - RPG
Written by Rafael Victoria-Pereira   
Wednesday, 06 April 2016 01:00

Most fixed-format op codes are available in free-format, but IBM left a few behind (rightfully so, if you ask me). This article will help you replace COMP, CASXX, CABXX, TAG, and GOTO when converting to free-format.

rafael victoria preiraWritten by Rafael Victória-Pereira

The operation codes discussed in the previous TechTip were the easier ones. Let’s move on to more-complicated operation codes, which will certainly require some time to properly convert to free-format.

Add a comment
Last Updated on Wednesday, 06 April 2016 01:00
Read more...
 
Book Review: Subfiles in Free-Format RPG PDF Print E-mail
Programming - RPG
Written by Mike Faust   
Wednesday, 16 March 2016 01:00

Whether you're a newbie or a seasoned pro, this book has something for you.

mike_faustWritten by Mike Faust

For System i developers, mastering the ability to develop subfile applications is an absolute must! In Subfiles in Free-Format RPG, Kevin Vandever takes the reader through the subfile concept—from start to finish. Unlike other books on the topic, this one specifically focuses on coding subfile applications in free-format RPG and does an excellent job of explaining how to use subfiles in the modern rendition of the RPG language.

Add a comment

Last Updated on Monday, 14 March 2016 16:50
Read more...
 
User Rating: / 3
PoorBest 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 1 of 224

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