TechTips / Database


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...
 
TechTip: Simulate One-Part Names for DB2 Web Query Synonyms over Stored Procedures PDF Print E-mail
Tips & Techniques - Database
Written by Anita Corcoran   
Friday, 21 August 2009 01:00

Are you in a quandary because DB2 Web Query can't use *libl to find your stored procedure's synonym? Yes, it can!

anita_corcoranWritten by Anita Corcoran

In a previous Tech Tip, "Use a Stored Procedure as Your Data Source in DB2 Web Query for i," I discussed using a stored procedure as the data source in DB2 Web Query for i. Using a stored procedure as your data source offers many benefits to you as a developer: 

Add a comment
Last Updated on Friday, 21 August 2009 01:00
Read more...
 
User Rating: / 2
PoorBest 
TechTip: Use a Stored Procedure as Your Data Source in DB2 Web Query for i PDF Print E-mail
Tips & Techniques - Database
Written by Anita Corcoran   
Friday, 24 July 2009 01:00

Build queries with optional input parameters using existing business logic.

anita_corcoranWritten by Anita Corcoran

Do you need the ability to build queries with optional input parameters? Do you need your queries to use existing business logic? Did you know you can accomplish both goals by using a stored procedure as your data source in DB2 Web Query?

Add a comment
Last Updated on Thursday, 23 July 2009 12:36
Read more...
 
User Rating: / 12
PoorBest 
TechTip: Minimize DB2 Database Monitor Overhead PDF Print E-mail
Tips & Techniques - Database
Written by Kent Milligan   
Friday, 10 July 2009 01:00

New enhancements from IBM minimize disk activity and disk storage requirements.

kent_milligan_117x117Written by Kent Milligan

As documented in a previous TechTip, the Database Monitor is a great tool for collecting SQL performance data. However, you must apply great care when using this tool because it can cause significant disk activity on your system and quickly consume disk space. Recently, IBM introduced enhancements to minimize the disk activity and disk storage requirements associated with database monitor collections.

Add a comment
Last Updated on Friday, 10 July 2009 01:00
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