TechTips / Database

Book Review: The IBM i Programmer's Guide to PHP PDF Print E-mail
Tips & Techniques - Database
Written by Michael Sansoterra   
Friday, 22 May 2009 01:00

Both a primer and a reference, this book is a must-have for anyone who wants to program in PHP.

By Mike Pavlak

After developing Web solutions for the iSeries in Net.Data and then getting a sour taste from Java, I wanted something better. PHP was certainly the right choice, but making it run on an iSeries at the time was no small feat. Then Zend came to the table, and the rest, as they say, is history. There is no way any of us on the ground floor of this amazing union could have anticipated this level of excitement and interest. We continue to see huge numbers being drawn to PHP on IBM i as well as Linux, UNIX, and Windows. And this book comes at just the right time; it's both a primer and a reference.

Add a comment

Last Updated on Friday, 22 May 2009 07:36
Partner TechTip: Solve Your Business Issues with a Best-of-Breed Business Intelligence PDF Print E-mail
Tips & Techniques - Database
Written by Floyd Del Muro   
Thursday, 21 May 2009 11:00

Is your BI solution hard to install and difficult to use?

By Floyd Del Muro 

Is your data out-of-date and your report backlog still a backlog? Is your BI technical department larger than two people, and do they spend most of their time redefining your data to make the solution work? Does your technical team spend hours upon hours installing program fixes? Does your solution work with only one database, and is it too complicated to allow end users to write their own inquiries? Do you have to pay more any time you want to do more? Is your BI solution meeting your needs?

Add a comment

Last Updated on Tuesday, 26 May 2009 09:10
TechTip: Hidden Filters Improve DB2 Database Monitor in V5R4 PDF Print E-mail
Tips & Techniques - Database
Written by Kent Milligan   
Thursday, 12 March 2009 19:00

The overhead that a monitor can place on disk and I/O subsystems is no longer the problem it used to be.

kent_milligan_117x117.jpgBy Kent Milligan

Starting a Database Monitor on your server is quite simple, whether you're using the STRDBMON CL command or the System i Navigator graphical interface. The challenging part of a Database Monitor is minimizing the overhead that a monitor can place on disk and I/O subsystems while it's writing the collected data.

Add a comment

Last Updated on Thursday, 21 May 2009 12:28
User Rating: / 2
TechTip: Creating Local OLAP Cube Data Files with DB2 Data PDF Print E-mail
Tips & Techniques - Database
Written by Michael Sansoterra   
Thursday, 23 October 2008 19:00

Give users offline access to DB2 data in a versatile pivot table format.


In "Crunching AS/400 Data with OLAP Cubes and Excel 2000," I outlined how to use the Pivot Table wizard with Excel 2000 (and higher) to create pivot tables from DB2 data using an ODBC data source. This TechTip will go a step further.

Add a comment
Last Updated on Tuesday, 10 November 2009 13:07
User Rating: / 7
TechTip: MERGE DB2 Data to SQL Server 2008 PDF Print E-mail
Tips & Techniques - Database
Written by Michael Sansoterra   
Thursday, 09 October 2008 19:00

Data replication chores are a snap with the new MERGE T-SQL statement.


Released in August 2008, SQL Server 2008 is the latest incarnation of Microsoft's flagship database platform. While there are some cool new features for developers, there is one for DB2 developers that deserves special mention: the new Transact SQL (T-SQL) MERGE statement. MERGE will be useful to any IBM i (aka AS/400, iSeries, System i) shop that needs to replicate DB2 for i (formerly known as DB2 for i5/OS and DB2/400) data to SQL Server. This includes shops that use SQL Server for reporting, data warehousing. and application data sharing.

Add a comment
Last Updated on Tuesday, 10 November 2009 13:12
User Rating: / 1
User Rating: / 3
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 9 of 15



See What i Can Do With Modern RPG Development

Your applications deserve more than just a new look! Change the perception of the IBM i as “old” with modern development tips from IBM and Profound Logic Software.
Watch as Barbara Morris, Brian May and Alex Roytman dive beneath the GUI surface to show the benefits of:


  • Working with free-format RPG in IBM i TR7
  • Breaking free from “The Cycle” of traditional RPG development
  • Going beyond the 10 character limit in display and database files
  • And more!

You'll also see a live demonstration of these techniques as the presenters create a modern web application before your eyes! 


Watch the Webinar Now!



MS Office Connector for Query/400

NGS' Qport Office enables Windows users to run IBM Query/400 queries to: 

 - Create and update Excel spreadsheets and Access databases

 - Create Word documents

 - Send to Windows screen and PC printers

No query conversion is required. Works with i5/OS V5R1 & above. Installs in minutes!

If you don’t have a budget to replace IBM Query/400, but want your users to have one click enhanced output of their queries.… Request the online license agreement and product download instructions today!

Offer good through December 31, 2013.