Programming


Practically Rational: Snippets PDF Print E-mail
Programming - RPG
Written by Joe Pluta   
Wednesday, 02 September 2015 00:00

Snippets are the big brother to templates, with a little more functionality for a little more work.

joe plutaWritten by Joe Pluta

In a previous article, I introduced you to templates, an easy way to create simple macros that you can use to populate your code. Templates are fun and easy to use, but you'll run up against their limitations pretty quickly. The fact that the code is inserted as is from the template means that in many circumstances you'll need to modify the code as soon as you enter it. That's where snippets can help: this article will show you how.

Add a comment
Last Updated on Wednesday, 02 September 2015 00:00
Read more...
 
RPG Academy: BIF Up Your Code! Using BIFs to Perform Date Operations PDF Print E-mail
Programming - RPG
Written by Rafael Victoria-Pereira   
Wednesday, 02 September 2015 00:00

RPG's date-related BIFs form a powerful set of tools that will help ease your date-operations-caused pains! Keep reading to learn how to use them properly.

 

rafael victoria preiraWritten by Rafael Victória-Pereira

Date operations, such as calculating a due date or something apparently as simple as retrieving the last day of a given month, are the source of many headaches for RPG programmers everywhere.

 

Everyone has a few homegrown date routines in their applications. Even though they work well most of the time, they become a nightmare when they don't do what we expect. RPG has a well-balanced set of BIFs to handle date, time, and timestamp data types, and you can use them to replace those error-prone, ages-old code, thus making your code clearer, faster, and more reliable. Let's start with the date-related BIFs and leave the time/timestamp BIFs for later.

Add a comment
Last Updated on Wednesday, 02 September 2015 14:11
Read more...
 
Young RPG Talent: It Exists If You Make an Investment PDF Print E-mail
Programming - RPG
Written by Brian May   
Wednesday, 19 August 2015 00:00

The key to growth and innovation in an IT shop is regularly recruiting new talent with fresh ideas, and your IBM i shop can do it too!

brian mayWritten by Brian May

I am extremely excited to start contributing regularly here at MC Press Online! I hope you will enjoy reading my articles as much as I enjoy writing them. In my 14 years in the RPG development space, I have made it a point to learn as much as possible. I have also tried to share the knowledge I have acquired by writing articles and speaking to user groups. RPG, in my opinion, is still the most well-suited language for writing business applications. I love IBM i and RPG, and I look forward to sharing that enthusiasm with you.

Add a comment
Last Updated on Wednesday, 19 August 2015 00:00
Read more...
 
The API Corner: Moving Jobs Within and Across Job Queues PDF Print E-mail
Programming - APIs
Written by Bruce Vining   
Wednesday, 19 August 2015 00:00

Let's look at what we can do with the Move Job API.

bruce viningWritten by Bruce Vining

Earlier this month, over on Midrange-L, Becky B. wrote in with this:

 

During month-end we have a large number of user-submitted jobs that automatically go to the QBATCH job queue and hold up other jobs. Is there a way to automatically redirect jobs to a different subsystem once they hit the job queue?

 

Included was a follow-on note explaining that management was hoping for a silver bullet so that they wouldn't have to change the programs submitting month-end jobs.

Add a comment
Last Updated on Wednesday, 19 August 2015 00:00
Read more...
 
Practically Rational: User-Defined Templates PDF Print E-mail
Programming - RPG
Written by Joe Pluta   
Wednesday, 05 August 2015 00:00

Rational Developer for the IBM i makes programmers more productive, and this technique is one way to make Rational more productive!

joe plutaWritten by Joe Pluta

I use Rational Developer for the IBM i (RDi) a lot. I use it every working day, and I can't imagine trying to program without it. On those occasions when I am forced to rely on SEU, I find my fingers flailing away at key combinations that I use almost without thinking in Rational and muttering a bit under my breath. But even when using Rational, I'm always looking for new shortcuts to make my life easier. I'd like to share one that has begun to really save me time and has great potential for expansion as time goes on.

Add a comment
Last Updated on Wednesday, 05 August 2015 00:00
Read more...
 
RPG Academy: BIF Up Your Code! Building Excel's PROPER Case Function and Testing Chg_Case PDF Print E-mail
Programming - RPG
Written by Rafael Victoria-Pereira   
Wednesday, 05 August 2015 00:00

The previous TechTip focused on two of Excel's text conversion functions, UPPER and LOWER. This time around, I'll cover PROPER, also known as Title Case. Read on!

rafael victoria preiraWritten by Rafael Victória-Pereira

PROPER Case is a bit complex to implement, because it completely modifies the input string, changing the first letter of each word to uppercase and all of the others to lowercase. It's a perfect opportunity to show how a fairly complex problem can be solved in a simple way, using BIFs.

Add a comment
Last Updated on Monday, 03 August 2015 12:08
Read more...
 
The API Corner: What Time Zone Do You Want That Date and Time In? PDF Print E-mail
Programming - APIs
Written by Bruce Vining   
Wednesday, 15 July 2015 00:00

Today, we'll look at more uses for the Convert Date and Time Format API.

bruce viningWritten by Bruce Vining

Last month, in How Do You Want That Date and Time?, we used the first five parameters of the Convert Date and Time Format (QWCCVTDT) API to format a date and time value stored in a *DTS format to a YYYYMMDDHHMMSS format that's much friendlier to work with. This month, we'll look at the two optional parameter groups of the API. But first some background.

Add a comment

Last Updated on Tuesday, 14 July 2015 13:38
Read more...
 
SQL 101: Writing More Complex Queries PDF Print E-mail
Programming - SQL
Written by Rafael Victoria-Pereira   
Friday, 10 July 2015 00:00

One-table queries are OK, but data is usually spread over different tables in the database. To write a query that uses data from more than one table, you need to join the tables. This article shows ways to do that.

rafael victoria preiraWritten by Rafael Victória-Pereira

Using one table in a Select statement won't get you very far: most databases are structured to avoid data repetition and use multiple tables to achieve that goal, which means that you'll probably have to use different tables for the actual data and its human-understandable descriptions.

 

Let me try to explain this with an example:

Add a comment
Last Updated on Friday, 10 July 2015 00:00
Read more...
 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 1 of 219

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