TechTips / Database

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
TechTip: Simplify Report Development with DB2 Web Query Business Views PDF Print E-mail
Tips & Techniques - Database
Written by Gene Cobb   
Thursday, 21 August 2008 19:00

Get rid of those long lists of fields!

gene_cobb.jpgBy Gene Cobb

If you have been using DB2 Web Query for report and graph development, you may have discovered that the database field list in the development tools (Report Assistant, Graph Assistant, and Power Painter) can be quite lengthy when you have one or both of the following:


  • A synonym based on a file with many fields
  • Multiple joins defined in the synonym or development tool

Add a comment

Last Updated on Thursday, 21 May 2009 12:29
User Rating: / 6
User Rating: / 19
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 10 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.