Programming


Practical SQL: Partitions and MERGEs PDF Print E-mail
Programming - SQL
Written by Joe Pluta   
Wednesday, 01 July 2015 00:00

Updating one file from another in SQL has been messy in the past, but this technique makes it a lot easier.

joe plutaWritten by Joe Pluta

One of the big advantages of SQL is the fact that you can add columns to a table without worrying about the underlying access; columns that aren't used are simply ignored in the SQL client programs. However, once you have added that column, the next trick is to populate the column correctly.

Add a comment
Last Updated on Tuesday, 30 June 2015 10:15
Read more...
 
RPG Academy: BIF Up Your Code! More Excel-like Functions with %XLATE PDF Print E-mail
Programming - RPG
Written by Rafael Victoria-Pereira   
Wednesday, 01 July 2015 00:00

There's more to string operations than splitting and stitching. Curious? Keep reading.

rafael victoria preiraWritten by Rafael Victória-Pereira

Something as trivial as changing the case (from lowercase to UPPERCASE, for instance) of a string can be a challenge in RPG, because unlike SQL (and MS Excel), RPG doesn't have a change case function. So let's build one, using yet another BIF: %XLATE.

Add a comment

Last Updated on Tuesday, 30 June 2015 11:21
Read more...
 
User Rating: / 1
PoorBest 
RPG Academy: BIF Up Your Code! Building MS Excel-like LEFT and RIGHT Functions Using BIFs PDF Print E-mail
Programming - RPG
Written by Rafael Victoria-Pereira   
Wednesday, 17 June 2015 00:00

It's time to have a little fun! Let's build MS Excel-like LEFT and RIGHT functions using BIFs.

rafael victoria preiraWritten by Rafael Victória-Pereira

My guess is that you, dear reader, use MS Excel (or some sort of spreadsheet similar to it) to some extent. Even if you don't use it every day, it's possible that you've come across the LEFT, MID, and RIGHT functions. If you haven't, this article provides a nice overview. These are simple yet powerful text-handling functions. LEFT and RIGHT don't have a parallel in RPG. However, the MID function does: it's the %SUBST BIF that I presented two TechTips ago.

Add a comment
Last Updated on Wednesday, 17 June 2015 00:00
Read more...
 
User Rating: / 2
PoorBest 
The API Corner: How Do You Want That Date and Time? PDF Print E-mail
Programming - APIs
Written by Bruce Vining   
Wednesday, 17 June 2015 00:00

Have it the way you want it by using the Convert Date and Time Format API.

bruce viningWritten by Bruce Vining

Last month, in What's the Status of My Data Queue?, we used the Convert Date and Time Format (QWCCVTDT) API to format a date and time value stored in an internal format to a YYYYMMDDHHMMSS format much friendlier to work with, but we really didn't discuss how the API is used. This month, we'll look at some of the uses of QWCCVTDT.

 

The Convert Date and Time Format API converts date and time values from one format to another. For example, using the API you can:

Add a comment
Last Updated on Tuesday, 16 June 2015 12:37
Read more...
 
Continuous Delivery: What Is This Devilry from the Web Side? PDF Print E-mail
Programming - General
Written by David Shirey   
Wednesday, 10 June 2015 00:00

Everyone knows it takes forever to get something through the process and into production. Who are these CD folks trying to fool?

david shireyWritten by David Shirey

Let's start by asking ourselves one very important question: What is Continuous Delivery?

Thousands of years from now, when mankind has destroyed the Earth and reaped extinction as the reward, and birds, whose ancestors were the dinosaurs, have at last gained mastery over our world, they will determine that humans derived most of their information from two sources: Wikipedia and Entertainment Tonight.

Add a comment

Last Updated on Wednesday, 10 June 2015 08:12
Read more...
 
Practical RPG: Embedded SQL and Subfiles PDF Print E-mail
Programming - RPG
Written by Joe Pluta   
Wednesday, 03 June 2015 00:00

I try to use SQL wherever it makes my programs better, and here's a great example of using it to enhance your inquiries.

joe plutaWritten by Joe Pluta

By this time, nearly everyone who programs in RPG has at least heard of embedded SQL. No matter what version of RPG you're using, you have an opportunity to take advantage of this fantastic tool that extends the RPG language in a way that most other languages just don't get. The embedded SQL support for RPG allows me to write SQL statements that interact directly and seamlessly with host variables, something I wish could do in my Java programming. This close cooperation lets you easily take advantage of the capabilities of SQL in your everyday RPG programs. Let me show you how SQL can enhance your subfile inquiries.

Add a comment
Last Updated on Wednesday, 03 June 2015 00:00
Read more...
 
ILE RPG Goes Free and Mobile! PDF Print E-mail
Programming - RPG
Written by Roger Pence   
Wednesday, 03 June 2015 00:00

A tip of the programmer's beanie to IBM for providing a powerful, expressive RPG syntax.

roger penceWritten by Roger Pence

Back in my early days of the IBM midrange platforms, RPG was known as primarily being a Report Program Generator (although the "Generator" part was a little over-optimistic!). This was back when writing interactive programs with RPG was a black art of shoehorning the RPG cycle into something into which it clearly did not fit.

Add a comment
Last Updated on Wednesday, 03 June 2015 00:00
Read more...
 
What's Wrong with the RPG World? PDF Print E-mail
Programming - RPG
Written by David Shirey   
Wednesday, 20 May 2015 00:00

Do you ever kind of get sick of the way RPG is kicked around? I do too, but I guess in this article I'll do some of the kicking because, in some ways, it's our own fault.

david shireyWritten by David Shirey

Maybe it's the weather. It's really hot today, hot and muggy, and last week it was so cold I was back to wearing sweatshirts. So I'm not prepared for this hot weather, and it always takes me a bit of time to adjust. And what do I do when I'm in the slow process of adjusting? I get cranky.

Add a comment
Last Updated on Wednesday, 20 May 2015 00:00
Read more...
 
User Rating: / 1
PoorBest 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 1 of 218

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