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
TechTip: Know the Drill! PDF Print E-mail
Tips & Techniques - Database
Written by Gene Cobb   
Thursday, 13 December 2007 18:00

Enhance your DB2 Web Query reports by using drill-down capabilities.

By Gene Cobb


Hopefully, by now you've had a chance to install and use the new DB2 Web Query for System i tool. Hailed as the successor to the popular Query/400 product as the strategic System i query and reporting tool, DB2 Web Query can do things that Query/400 could only dream of. One of these advanced features is drill-down: the ability to select a column in a high-level (summary) report and click through (drill down) to show the next level of detail in another report.


Two types of drill-down capabilities can be implemented with DB2 Web Query:


·        Programmatic drill down—This requires developing at least two reports: a high-level summary report (also called the parent) and a detail report to link to (the child). The parent report contains the information necessary to link to the child report. The child report could in turn drill down to another linked report to reveal the next level of detail. Each new level of drill-down requires the creation or existence of another linked report. Add a comment
Last Updated on Friday, 12 February 2010 10:03
User Rating: / 10
<< 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.