TechTips / Database


Partner TechTip: Add Visual Impact to Your Reports and Show Off Your Data in Style PDF Print E-mail
Tips & Techniques - Database
Written by Floyd Del Muro   
Thursday, 01 April 2010 23:00

Even non-technical users can build powerful, good-looking reports.

floyd_delmuroWritten by Floyd Del Muro

Are you still generating reports, lists, and statements from your System i data in the same spooled-output format? What do they look like? They're probably looking a little dated and old. Could they use a little color? What about a font other than Courier or maybe some lines, boxes, graphics, or barcodes? Wouldn't any one of these elements make your reports look fresh and add impact to the data? What if you could have them all?

Add a comment
Last Updated on Thursday, 01 April 2010 23:00
Read more...
 
TechTip: Members Only? No Problem with DB2 Web Query PDF Print E-mail
Tips & Techniques - Database
Written by Gene Cobb   
Friday, 12 March 2010 00:00

Access your multi-member files, let your users dynamically select the member they want to query at run time, and create a report that uses the latest and greatest database engine technology.

gene_cobbWritten by Gene Cobb

Over the last several years, I have written several articles about DB2 for i and DB2 Web Query, some of which emphasized the importance of employing techniques to ensure that your queries are using the SQL Query Engine (SQE), the strategic database engine for DB2 for i. One of the requirements for SQE processing is that the database access method must be SQL. However, one of the very few drawbacks with SQL access on our beloved system is that it does not natively support the concept of physical file members.

Add a comment
Last Updated on Wednesday, 10 March 2010 13:29
Read more...
 
User Rating: / 1
PoorBest 
TechTip: Build Floating Reports in DB2 Web Query Dashboards PDF Print E-mail
Tips & Techniques - Database
Written by Robert Andrews   
Friday, 08 January 2010 00:00

Use this simple method to manage the display size of your reports.

robert_andrewsWritten by Robert Andrews

When you create a dashboard in DB2 Web Query, it often contains a combination of graphs, reports, and, optionally, selection criteria. Because of changing criteria or business loads, the size required to display these reports changes. By default, Web Query uses fixed locations, which means that you need to plan for the largest size to avoid overlap. However, when you have smaller reports, this leads to large sections of undesired white space. In this TechTip, I will explain how to avoid this problem by using floating reports.

Add a comment
Last Updated on Friday, 08 January 2010 00:00
Read more...
 
TechTip: MySQL and PostgreSQL GUI Tools Make Life Easier PDF Print E-mail
Tips & Techniques - Database
Written by Max Hetrick   
Friday, 11 December 2009 00:00

Simplify database administration tasks by using graphical administration tools for PostgreSQL and MySQL databases.

max_hetrickWritten by Max Hetrick

I'm not a database guru, so for me, getting into and working with the guts of databases isn't always easy. For the limited amount of time I have to work with databases, I like using GUI tools to help me complete my tasks. Also, when you use administration tools, there's often no need to worry about the various SQL command-line differences between databases—or at least not as much. Although diehard SQL administrators and DBAs will probably disagree with me, graphical database tools can and will make your experience with databases a little less complex and cumbersome.

Add a comment
Last Updated on Friday, 11 December 2009 09:06
Read more...
 
Partner TechTip: Deliver Critical Enterprise-wide Data to Your Users Quickly and Easily PDF Print E-mail
Tips & Techniques - Database
Written by Floyd Del Muro   
Friday, 13 November 2009 00:00

Empower users so that they can get the data they want to see.

floyd_delmuroWritten by Floyd Del Muro

How do you deliver the information your users need to do their jobs? Can they answer business questions quickly and correctly? Are they empowered with the tools and the knowledge they need to find and access the data spread out across your enterprise?

 

Sadly, for many, the answers are "we don't," "not really," and "no." Add a comment

Last Updated on Friday, 13 November 2009 00:00
Read more...
 
Partner TechTip: Users Want DB2 i5/OS Data in a Modern View PDF Print E-mail
Tips & Techniques - Database
Written by Floyd Del Muro   
Friday, 18 September 2009 00:00

i5/OS Query is outdated, and Enterprise BI tools require more licenses, consulting, and money.

floyd_delmuroWritten by Floyd Del Muro

Are users begging you for a modern look and feel when it comes to System i data? Are they telling you that green-screen reports are unacceptable? Is your backlog of text-based reports getting you down? Is your DB2 data warehouse project over budget, past due, and not satisfying user requests? Are you confused about what tools to use for accessing business data, how many tools you need, and what skill sets are required?

Add a comment
Last Updated on Thursday, 17 September 2009 11:24
Read more...
 
TechTip: Improve Performance When Writing to DB2 for i Tables, Part II PDF Print E-mail
Tips & Techniques - Database
Written by Fernando Echeveste   
Friday, 11 September 2009 00:00

Check out the lab tests on the new OVRDBF feature that lets you override the REUSEDLT(*YES) attribute of a physical file or table and effectively use the behavior of REUSEDLT(*NO).

fernando_echevesteWritten by Fernando Echeveste

In a previous TechTip, I introduced a new Override with Database File (OVRDBF) command option that allows an application that requires high velocity inserts to temporarily override the REUSEDLT(*YES) attribute of a physical file or table and effectively use the behavior of REUSEDLT(*NO). In this second part, I will explain the results of lab-testing this new feature and some of the performance considerations when inserting rows into a table. I will also explain how you can obtain this new feature and start benefiting from it in your shop.

Add a comment
Last Updated on Friday, 11 September 2009 00:00
Read more...
 
User Rating: / 3
PoorBest 
TechTip: Improve Performance When Writing to DB2 for i Tables, Part I PDF Print E-mail
Tips & Techniques - Database
Written by Fernando Echeveste   
Friday, 04 September 2009 00:00

With a new OVRDBF feature, you can override the REUSEDLT(*YES) attribute of a physical file or table and effectively use the behavior of REUSEDLT(*NO).

fernando_echevesteWritten by Fernando Echeveste

If your application inserts a large volume of rows into DB2 for i tables, the following features found on IBM i can influence the performance of your application:

Add a comment
Last Updated on Monday, 31 August 2009 11:09
Read more...
 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 7 of 14

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