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?
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.
SQL(snap) lets you surf every database in your enterprise: DB2/400, DB2, Oracle, Microsoft SQL Server, MySQL, Postgre, and others. Then, with a few mouse clicks you can build intricate SQL queries. With a few more clicks, you can generate reliable, reusable SQL code to be used in your own RPG, Java, and PHP programs. And then you can access all of your databases with RPG, Java, or PHP.
Figure 1: Build intricate SQL queries and generate code with just a few mouse clicks! (Click images to enlarge.)
Question: What do RPG, Java, and PHP have in common?
Answer: The database and SQL.
SQL is the undisputed standard for database access across every modern technology. Knowledge of SQL is vital, even for us RPG types, because in an age of application modernization and Web technologies like Java, PHP, .NET, etc., the one common thread among them all is, of course, SQL. Once you truly understand SQL, you are one large step closer to mastering another technology.
With SQL, it's usually not the complexity that keeps RPG programmers away; it's the tediousness. It is one thing to understand SQL and know how to use SELECT, INSERT, UPDATE, and DELETE from a command line or GUI interface; it's quite another to deal with cursors, prepared statements, and scrollable or updatable result sets. Not to mention host variables, error and status codes, and other insidious details within your programs. And never mind how ugly the IBM precompiler makes embedded code look in debug view. Sheesh!
With Java and PHP, there is no choice: Thou shalt use SQL or surrender thy IDE. Period.
With RPG, however, it can be daunting, especially when compared to the relative simplicity of CHAIN or SETLL and READE. Consider the following snippet that finds all rows for a given customer within a specified state (see Figure 2).
Figure 2: A simple RPG SETLL, READE example.
Seen that once or twice, right? OK, now take a look at the snippet below. This is the equivalent code done with SQLRPGLE (see Figure 3).
Figure 3: A SQLRPGLE prepared statement and cursor example.
It's not rocket science, but it is more complicated, and as they say, the devil's in the details. With Java and PHP, there is an additional step not generally needed in RPG programs. In RPG, if you are connecting to the local database, there is no need to obtain a connection. With Java and PHP, you must obtain and manage a connection throughout the life cycle of the process.
SQL(snap) builds code to manage SELECT, INSERT, UPDATE, and DELETE as well as cursors, prepared statements, host variables, and connection objects where appropriate. SQL(snap) also builds data structures and helps to manage the movement of variables for your SQLRPGLE, Java, and PHP code. All of the generated code is based on the queries you build using SQL(snap). The resulting code will drop into your programs with ease, leaving the tedious aspects of database I/O to the tool and leaving you with a lot more time for other things, like business logic or learning Java or PHP...or lunch.
SQL(snap) will go a long way toward helping you learn Java and PHP as well as the internals of SQLRPGLE and accessing local or remote databases from all three languages.
Over on our Web site, there are several more code comparisons like the one above. There you will find similar snippets comparing CHAIN, READ, READP, READPE, and so forth with their SQL equivalents.
To see SQL(snap) in action and to see the code that gets generated for RPG, Java, and PHP, click over to http://www.pinchhittersolutions.com/. Don't miss the video, the white paper, and your free trial download. You'll be up and running in 10 minutes!
More than ever, there is a demand for IT to deliver innovation. Your IBM i has been an essential part of your business operations for years. However, your organization may struggle to maintain the current system and implement new projects. The thousands of customers we've worked with and surveyed state that expectations regarding the digital footprint and vision of the company are not aligned with the current IT environment.
TRY the one package that solves all your document design and printing challenges on all your platforms. Produce bar code labels, electronic forms, ad hoc reports, and RFID tags – without programming! MarkMagic is the only document design and print solution that combines report writing, WYSIWYG label and forms design, and conditional printing in one integrated product. Make sure your data survives when catastrophe hits. Request your trial now! Request Now.
Forms of ransomware has been around for over 30 years, and with more and more organizations suffering attacks each year, it continues to endure. What has made ransomware such a durable threat and what is the best way to combat it? In order to prevent ransomware, organizations must first understand how it works.
Disaster protection is vital to every business. Yet, it often consists of patched together procedures that are prone to error. From automatic backups to data encryption to media management, Robot automates the routine (yet often complex) tasks of iSeries backup and recovery, saving you time and money and making the process safer and more reliable. Automate your backups with the Robot Backup and Recovery Solution. Key features include:
Business users want new applications now. Market and regulatory pressures require faster application updates and delivery into production. Your IBM i developers may be approaching retirement, and you see no sure way to fill their positions with experienced developers. In addition, you may be caught between maintaining your existing applications and the uncertainty of moving to something new.
IT managers hoping to find new IBM i talent are discovering that the pool of experienced RPG programmers and operators or administrators with intimate knowledge of the operating system and the applications that run on it is small. This begs the question: How will you manage the platform that supports such a big part of your business? This guide offers strategies and software suggestions to help you plan IT staffing and resources and smooth the transition after your AS/400 talent retires. Read on to learn:
LATEST COMMENTS
MC Press Online