Programming


SQL 101: Date-Related Functions, Part 2—Time-Saving Functions PDF Print E-mail
Programming - SQL
Written by Rafael Victoria-Pereira   
Wednesday, 20 July 2016 00:00

The functions discussed in this article won’t save time in the literal sense; mankind has yet to invent a time machine. However, these functions will surely cut down on the time it takes an RPG programmer to perform complicated “date math.”

rafael victoria preiraWritten by Rafael Victória-Pereira

As I mentioned in the previous article, there’s no BIF to return the day of the week, for instance. SQL provides several simple-to-use scalar functions that do that and more, as you’ll see later in this article.

 

Before getting to that, let me take a moment to address some readers’ remarks regarding the functions I presented in the previous article.

Add a comment
Last Updated on Wednesday, 20 July 2016 00:00
Read more...
 
Practical RPG: Processing an IFS Directory PDF Print E-mail
Programming - RPG
Written by Joe Pluta   
Wednesday, 06 July 2016 00:00

The IFS is an integral part of the today's modern IT infrastructure; this article shows you how to use it as a powerful data input device.

joe plutaWritten by Joe Pluta

When the IFS was first introduced, it seemed to be almost an afterthought designed primarily to support UNIX and Java development. Sure, you could map drives to it, but the support wasn't exactly robust and you were actually better off using FTP if you wanted to drop something into an IFS folder. Fast-forward to today's IBM i, and the IFS can be easily accessed from just about anywhere, Windows to Linux, making it a simple way for people to communicate with the system using something other than a green-screen.

Add a comment
Last Updated on Wednesday, 06 July 2016 00:00
Read more...
 
RPG Academy: Write Better Code—A Few More Naming Variables Guidelines PDF Print E-mail
Programming - RPG
Written by Rafael Victoria-Pereira   
Wednesday, 06 July 2016 00:00

It’s time to discuss a few more variable prefixes and a technique you can resort to when you’re forced by the circumstances to use indicators, namely when you manipulate display and printer files.

rafael victoria preiraWritten by Rafael Victória-Pereira

The last installment of this series covered parameter and work variable prefixes, which are arguably the most-used variables in a typical RPG program. However, I recommend taking a few more steps and using separate variables for key fields and constants as well. Keep reading to find out why.

Add a comment
Last Updated on Wednesday, 06 July 2016 00:00
Read more...
 
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...
 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 1 of 225

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