SQL


TechTip: Don't Get Stuck on Field Names When Creating File Joins in SQL
Tips & Techniques - SQL
Written by Steven Goetjen   
Friday, 12 June 2009 00:00

Have you been memorizing field names or relying on F4 prompting?

steven_goetjenWritten by Steven Goetjen

When creating file joins using interactive SQL (STRSQL), it's sometimes difficult to remember the field names that you want to join. I typically don't memorize field names and totally rely on the F4 prompting to get the names from the "SELECT fields" line.

Last Updated on Thursday, 11 June 2009 10:49
Read more...
     
TechTip: Speed Up SQL Procedures with Service Program Support
Tips & Techniques - SQL
Written by KENT MILLIGAN   
Thursday, 07 August 2008 18:00

With a recent V6R1 PTF, SQL stored procedures can now benefit from the improved performance offered by IBM i service program objects.

kent_milligan_117x117.jpgBy Kent Milligan

The usage of SQL stored procedures by IBM i applications and programs continues to rise. For quite awhile, applications have had the ability to leverage the performance benefits offered by IBM i service program objects.

 

With a recent V6R1 PTF, SQL stored procedures can now benefit from the improved performance offered by IBM i service program objects. When an SQL stored procedure is created, DB2 for i generates and creates an ILE C program object to implement the business logic specified by the programmer. For example, when the following procedure is created, it will result in DB2 generating an ILE C program object (*PGM) named ADD_PGM in the QGPL library.  Whenever an application invokes the ADD_PGM, DB2 will transparently call the generated C program object. 

Last Updated on Tuesday, 19 May 2009 09:35
Register to read more...
         
<< Start < Prev 1 2 3 4 5 6 7 8 9 Next > End >>

Page 1 of 9

WHITE PAPERS

The following White Papers can be found at the MC White Paper Center

 

 

Special Section: Business Continuity Today

 

___________________________________

 

 

TRIAL SOFTWARE

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

 


   MC-STORE.COM