TechTips / Database


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
Read more...
 
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
Read more...
 
User Rating: / 2
PoorBest 
 
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
Read more...
 
User Rating: / 7
PoorBest 
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
Read more...
 
User Rating: / 1
PoorBest 
   
User Rating: / 3
PoorBest 
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
Read more...
 
User Rating: / 6
PoorBest 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 7 of 13

WEBCAST

MC Webcast CenterFEATURED WEBCAST

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!

 

TRIAL SOFTWARE

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.


   MC-STORE.COM