SQL is a very powerful and flexible language. This article introduces the interactive SQL command line tool to run SQL statements on your IBM i.

By Tom Snyder

In this TechTip, we'll explore the functionality of the interactive SQL tool.

Coding SQL within RPG or Java is time-consuming and tedious, but what if you could automatically generate SQL for RPG or Java in seconds?

By Scott Salisbury

As System i programmers, we are being nudged, prodded, and goaded to use embedded SQL in our programs.

Do you realize how much simpler your life can be with SQL triggers?

By Kent Milligan

SQL triggers have been available on DB2 for i since V5R1. The SQL trigger support provides a fast and easy way to create triggers without the extra steps of compiling a program object. In addition, the SQL trigger syntax insulates programmers from having to navigate the trigger buffer associated with external (i.e., non-SQL) triggers.

Do you think writing embedded SQL code for RPG is more complex and time-consuming than it should be? You're not alone!

By Scott Salisbury

Have you ever started down the path to creating an SQLRPGLE program only to turn back and do it the old-fashioned way? If you said yes, I'll bet it's because RPG CHAIN, SETLL, READE, etc. are easier and less hassle than trying to unscramble the proper use of statements, prepared statements, host variables, return codes, and all the rest.

Coding SQL within RPG can be tedious, but what if you could automatically generate SQL for RPG, SQL for Java, and SQL for PHP in a just few clicks?

by Scott Salisbury

Have you ever avoided using SQL in your RPG programs because embedded SQL is a hassle and it's just easier to do it the old-fashioned way? Have you ever wished your RPG programs could access data from Microsoft SQL Server or Oracle? Do you work with multiple databases and multiple SQL client tools? What about Java and PHP? Both use embedded SQL. Are you using them yet?

SQL(snap) simplifies SQL tasks and turns hours into a few clicks.