Embedding SQL in RPG IV–Episode I

August 10, 2005 Joel Cochran

I must admit that I’ve been a Star Wars geek since I was 7. The premier theater in Des Moines, Iowa, at the time was a three-screen stand-alone job that easily lent itself to the term “blockbuster.” The line literally wrapped around the building, and we waited hours to get in and see the first installment of the space epic long before the movie-going public called it “A New Hope” or “Episode IV.” Every kid I knew wanted to be Luke Skywalker or Han Solo. Almost 30 years later, I’m still entranced by the story, and I was more excited

Editing Numbers in CL

August 10, 2005 Cletus the Codeslinger

Think about some of the PC-based software you use. You’ve never seen the source code. You don’t know what interesting and esoteric techniques the programmer(s) used. All you know is what you see, which is how the program performs. You’re happy when it works effectively and annoyed (or worse) when it doesn’t. In other words, you’re an end user.

Now think about the end users that use your code. They have no emotional attachments to your clever use of subfiles. They couldn’t care less that you used that obfuscated API that no one else in your shop could figure out.

Five Ways to Access IFS Data from a Windows PC without FTP

August 10, 2005 Hey, Joe

I’ve been asked to investigate a way to transmit files from an AS/400 to a CREST messaging system using an Infrastructure for Financial Markets (IFM) gateway. The problem is that I have been asked not to use FTP to transmit these files between the two systems. Apart from FTP, what other options can I use to copy files from the IFS to my PC?

–Brooks

The beautiful thing about the OS/400 and i5/OS operating system is that it’s probably the most well-connected system in existence. If you can’t move data between an AS/400, iSeries, or i5 machine and the outside