Programming


SQL 101: Date-Related Functions, Part 1—Converting Almost Anything to a Date, Time, or Timestamp PDF Print E-mail
Programming - SQL
Written by Rafael Victoria-Pereira   
Friday, 24 June 2016 00:00

This subseries will cover the main date- and time-related functions SQL has to offer, providing examples of possible applications of this interesting and useful set of scalar functions.

rafael victoria preiraWritten by Rafael Victória-Pereira

I’ll start by showing how to convert other data types to Date, Time, and Timestamp data. Handling dates and times in RPG has always been a pain. It’s true that the new-ish BIFs help a lot, but apparently simple tasks such as determining the day of the week of a given date or finding out when will the next Monday occurs require loads of RPG code to implement. SQL offers a very interesting set of scalar functions that can really help when it comes to handling date-related data.

Add a comment
Last Updated on Friday, 24 June 2016 00:00
Read more...
 
Book Review: Free-Format RPG IV, Third Edition PDF Print E-mail
Programming - RPG
Written by Joe Pluta   
Friday, 24 June 2016 00:00

Jim Martin comes through for us again.

joe plutaReviewed by Joe Pluta

Some time ago, I had the privilege of reviewing Jim Martin’s Functions in Free-Format RPG IV, and I was immediately struck by how Jim can take a complex subject and make it accessible to IBM i programmers. His newest book, Free-Format RPG IV, Third Edition, carries on that tradition wonderfully.

Add a comment
Last Updated on Friday, 24 June 2016 00:00
Read more...
 
RPG IV Free-Format Data Area Data Structures PDF Print E-mail
Programming - RPG
Written by Jim Martin   
Wednesday, 15 June 2016 00:00

Let’s talk about one of the many advantages of free-format coding.

jim martinWritten by Jim Martin

If you’re reading this article you’re likely an RPG IV programmer. Have you been using free-format calculations for a while? My guess is that most of you are. Have you been using the new free-format H-, F-, D-, and P-specs? My guess is not so much. Change is hard, and from my experience you have to give something new a little time, then quit, then give it a little time againlater on. My goal in writing this article for you is to give you a little bit of this new information on a subject that is fairly common.

Add a comment
Last Updated on Wednesday, 15 June 2016 00:00
Read more...
 
Practical RPG: Configuring Your Environment with Library Lists PDF Print E-mail
Programming - RPG
Written by Joe Pluta   
Wednesday, 01 June 2016 00:00

A robust enterprise architecture requires a flexible environment; this article shows you how to configure one.

joe plutaWritten by Joe Pluta

Sometimes the simplest things are the most effective. In my career in information systems, I've found powerful simplicity to be the hallmark of the most sophisticated computer software. The concept of a hardware interrupt is a great example: the voltage on a pin goes high and magic occurs. This simple technique is the basis for nearly every multi-tasking operating system ever written. We midrange developers are lucky to have many such architectural treasures in our favorite operating system, and this article focuses on one of the most powerful: the library list.

Add a comment
Last Updated on Wednesday, 01 June 2016 00:00
Read more...
 
RPG Academy: Write Better Code – Naming Variables Guidelines, Part 1 PDF Print E-mail
Programming - RPG
Written by Rafael Victoria-Pereira   
Wednesday, 01 June 2016 00:00

This subseries of RPG Academy focus on ways to improve your code’s efficiency, readability, and maintainability. In other words, it will help you write better code.

rafael victoria preiraWritten by Rafael Victória-Pereira

While there’s no “magic bullet,” it’s possible to enhance your code with proper naming conventions, organization, and documentation strategies. It’s true that some of these strategies are little more than common sense, but others will require changing a few (I dare say ages-old) habits. One good example is the way we write—or don’t write—documentation. As you’ll see on this and the next TechTips, there are many areas of improvement when the objective is writing clean, crisp code that’s easy on the eyes and easy for you or your successors to maintain.

Add a comment
Last Updated on Wednesday, 01 June 2016 00:00
Read more...
 
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 
<< 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