MAGAZINES

MC Press Resource Centers
MC Systems Insight
MC Power Technology Manager
MC RPG Developer
MC Power Developer
MC TNT Tips 'n Techniques
MC AIX Expert
MC Linux Expert
MC Mobile on Power

August 8, 2008 | Vol 5 Issue 31

 

In This Issue:

Feature Article - TechTip
 
TechTip: Speed Up SQL Procedures with Service Program Support

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. 


Read More >>


Feature Article - Analysis
 
Let the Games Begin! (But Let's Watch Them on PCs)

The two hallmarks of the 2008 Olympics are that all TV broadcasts will be in high definition and that all events will be streamed live to our computers.

chris_smith.jpgBy Chris Smith

The 2008 Summer Olympic Games begin in Beijing today, and the event marks several technology milestones, not the least of which is that it will be the largest television event in the history of the medium.

 

For the next 17 days, NBC Universal will provide around-the-clock high-definition TV coverage through its affiliates and cable networks. Of interest to technophiles, it also will be streaming thousands of hours of live broadband coverage over the Internet to computer users in the United States using Microsoft's new Silverlight technology. (Adobe has contracted with CCTV.com for Olympics Web coverage of the Games for distribution in China using Flash technology).


Read More >>

Support MC Press - Visit Our Sponsors

 

Forums Sponsor

 

 Popular Forums

POPULAR FORUMS

Forums

 

Search Sponsor
  
 

 Popular Searches

POPULAR SEARCHES

Search


Read More >>
   MC-STORE.COM