Submitted by TSnyder on Wed, 03/16/2011 - 11:41am
|
Feature Article - Developer Article
|
|
Any OS, any programming language, any database—SQuirreL is a perfect fit for almost any situation involving SQL!
In a previous article, I showed you how to install the SQuirreL SQL client to run interactive SQL on your IBM i. With all the new stuff to learn about and all the options that are out there, sometimes a little introduction to the basics will be all it takes to get rolling. In this article, I'll cover some of my favorite features that come with it.
Read More >> |
Submitted by TSnyder on Wed, 02/16/2011 - 10:04am
|
Feature Article - Developer Article
|
|
Install SQuirreL SQL client to run interactive SQL on your IBM i.
As you start using embedded SQL more frequently within your RPG code, you'll soon find that your SQL statements are becoming larger and larger and the interactive SQL tool on the green-screen starts becoming quite cumbersome. In this article, I will introduce Squirrel SQL, which is an open-source SQL client that gives you not only a better interface to your DB2 database, but also access to numerous other databases.
Read More >> |
Submitted by TSnyder on Wed, 01/19/2011 - 8:41am
|
Feature Article - Developer Article
|
|
With Oracle announcing end of life for IBM i distributions of MySQL, I'll discuss the potential for alternatives of MySQL on the i.
Oracle has decided to no longer support MySQL on the IBM i, and I for one am very disappointed in this recent announcement. When I first heard that you could run MySQL on the IBM i, I initially thought to myself, "Why would I want to use the MySQL database when I have DB2?" In this article, I intend to tell you why you would want to and why it's such a loss that Oracle will no longer be providing IBM i binaries. I'll also explain some of the options that we have without it.
Read More >> |
Submitted by TSnyder on Wed, 12/15/2010 - 8:48am
|
Feature Article - Developer Article
|
|
Do you know the best way to use optional parameters with procedures?
When you're using procedures, you have to ability to support optional parameters by using the special keywords *NOPASS and *OMIT. This article discusses the difference between the two and the appropriate times to use them.
Read More >> |
Submitted by TSnyder on Sat, 12/04/2010 - 2:52pm
 |
Access the Internet from your computer though your Android smart phone. This is a process called Tethering.
This is very useful when you need access to the Internet and there is no WiFi available.
|
For this setup we will be using AziLink. I have chosen AziLink for the following reasons:
- It is open source, which means that it is free forever
- You do not need to pay for the Verizon Tethering Plan (No Additional Cost).
This is assuming that you have the unlimited data plan.
- It is available from Google
- You do not need to root your Android Phone
- It Works!
Submitted by TSnyder on Thu, 11/18/2010 - 3:47pm
|
Feature Article - Developer Article
|
|
Let's explore the nuts and bolts of using embedded SQL: file type, syntax, and compiling.
In a previous article, "Why Use Embedded SQL Within RPG?", I talked about why you would use embedded SQL in RPG. In this article, I will talk about how you could use embedded SQL within RPG. We'll start with an existing RPG program that is written with CHAIN and READ, and then we'll convert it to use embedded SQL.
Read More >> |
Submitted by TSnyder on Wed, 11/03/2010 - 8:38am
|
Feature Article - TechTip
|
|
When you try to use new techniques and technologies, do you get resistance from your own staff?
Are you an RPG programmer who is dealing with resistance to updating your RPG skills from people in your staff or even management within your staff? Well, you're not alone.
I felt compelled to write this article because I have received several emails from people who are interested in updating their RPG skills, but the environment that they work in discourages skill advancement. Recently, I received a message from someone who is literally on the other side of the planet and is experiencing this kind of oppression in his shop and other shops that he's worked in.
Read More >> |
Submitted by TSnyder on Wed, 10/20/2010 - 8:48am
|
Feature Article - Developer Article
|
|
Let's evaluate the reasons you might want to take this approach.
You've heard about embedded SQL and maybe you've tried embedded SQL, but you may be asking yourself, "Why would I use embedded SQL?" That's the course that I have taken. Of course, when a new capability comes out, I am usually eager to start digging into it and figuring out how it works. And I have done that with SQL, but I couldn't easily find a reason to justify its use until recently.
Read More >> |
Submitted by TSnyder on Fri, 08/20/2010 - 6:27pm
|
Feature Article - Developer Article
|
|
Create a PDF "Hello World" program with RPG.
I hope you enjoyed my Video Tour presented on July 21 in which I discussed the possibilities of using Java with RPG to send email and to create Excel spreadsheets and PDFs. This article contains condensed excerpts from my book that will show you how to install the iText open-source project, which can be used to create PDFs right from within RPG.
Read More >> |
Submitted by TSnyder on Wed, 07/21/2010 - 2:58pm
|
Feature Article - Developer Article
|
|
Turn conceptual Java properties into definitive, concrete attributes.
When working with RPG in different environments, such as production and test, you will most likely be working with different library lists and using different versions of programs and files. To provide a sanity check for yourself, you will want to ensure that you're using the correct programs and files by validating the objects that are being used by the job. This article shows you some methods that I use to verify similar Java attributes when using Java with RPG, such as the currently running version of JVM and the class path that is being used.
Read More >> |
Pages
