SQL
Partner TechTip: Embedding SQL in RPG, Java, and PHP Doesn't Have to Be a Headache
Written by Scott Salisbury   
Monday, 12 May 2008

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

scott_salisbury.jpgBy 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 ( Tuesday, 13 May 2008 )
Read more...
  Discuss...

User Rating: / 1
Partner TechTip: Embedded SQL Is Just Plain Messy. Is There a Better Way?
Written by Scott Salisbury   
Friday, 02 May 2008

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?

scott_salisbury.jpgby 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 ( Tuesday, 06 May 2008 )
Read more...
  Discuss...

User Rating: / 3
TechTip: Handling SQL Return Codes, Part II
Written by Sam Lennon   
Thursday, 06 September 2007
Ignoring SQL return codes your program didn't expect can be hazardous. Here's an easy way to handle them.
Last Updated ( Thursday, 31 January 2008 )
Read more...
  Discuss...

User Rating: / 0
TechTip: Handling SQL Return Codes, Part I
Written by Sam Lennon   
Thursday, 16 August 2007
Treating SQLCOD as a simple on/off indicator can be risky, but robust checking using SQLSTT instead is easy.
Last Updated ( Thursday, 16 August 2007 )
Read more...
  Discuss...

User Rating: / 1
TechTip: SQLCOD End-of-File Gotcha
Written by Sam Lennon   
Thursday, 02 August 2007
SQLCOD doesn't always work like an on/off EOF indicator. Might your code be at risk?
Last Updated ( Thursday, 02 August 2007 )
Read more...
  Discuss...

User Rating: / 0
Partner TechTip: Creating SQL Materialized Queries
Written by Kevin Forsythe   
Thursday, 05 July 2007
Take advantage of SQL's Materialized Queries to build quick and easy work files.
Last Updated ( Thursday, 05 July 2007 )
Read more...
  Discuss...

User Rating: / 0
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Results 1 - 6 of 66

The following trial software can be found at the MC Press Software Center.   



   MC-STORE.COM