|
|
Tips & Techniques -
SQL
|
|
Written by Scott Salisbury
|
|
Sunday, 11 May 2008 19:00 |
|
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. |
|
Last Updated on Tuesday, 14 April 2009 04:56 |
|
Read more...
|
|
Tips & Techniques -
SQL
|
|
Written by Scott Salisbury
|
|
Thursday, 01 May 2008 19:00 |
|
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. |
|
Last Updated on Tuesday, 14 April 2009 04:57 |
|
Read more...
|
|
Tips & Techniques -
SQL
|
|
Written by Sam Lennon
|
|
Thursday, 06 September 2007 10:16 |
|
Ignoring SQL return codes your program didn't expect can be hazardous. Here's an easy way to handle them. |
|
Last Updated on Thursday, 31 January 2008 03:05 |
|
Read more...
|
|
Tips & Techniques -
SQL
|
|
Written by Sam Lennon
|
|
Thursday, 16 August 2007 18:00 |
|
Treating SQLCOD as a simple on/off indicator can be risky, but robust checking using SQLSTT instead is easy. |
|
Last Updated on Thursday, 16 August 2007 18:00 |
|
Read more...
|
|
Tips & Techniques -
SQL
|
|
Written by Sam Lennon
|
|
Thursday, 02 August 2007 18:00 |
|
SQLCOD doesn't always work like an on/off EOF indicator. Might your code be at risk? |
|
Last Updated on Thursday, 02 August 2007 18:00 |
|
Read more...
|
|
Tips & Techniques -
SQL
|
|
Written by Kevin Forsythe
|
|
Thursday, 05 July 2007 18:00 |
|
Take advantage of SQL's Materialized Queries to build quick and easy work files. |
|
Last Updated on Thursday, 05 July 2007 18:00 |
|
Read more...
|
|
Tips & Techniques -
SQL
|
|
Written by Kevin Forsythe
|
|
Thursday, 07 June 2007 18:00 |
|
Get more feedback on your SQL statements by using the SQL Communications Area. |
|
Last Updated on Thursday, 07 June 2007 18:00 |
|
Read more...
|
|
Tips & Techniques -
SQL
|
|
Written by Kevin Forsythe
|
|
Thursday, 10 May 2007 18:00 |
|
Learn how to test returning parameters and result sets from stored procedures. |
|
Last Updated on Thursday, 10 May 2007 18:00 |
|
Read more...
|
|
|
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>
|
|
Page 2 of 10 |