TechTips / Database


TechTip: Simplify Your Development with DB2 Automatic Timestamp Support PDF Print E-mail
Tips & Techniques - Database
Written by Kent Milligan   
Friday, 03 September 2010 00:00

Minimize your application development costs by moving your timestamp logic into the DB2 for i database engine.

kent_milligan_117x117Written by Kent Milligan

Many applications have logic to capture and record a timestamp that indicates when certain business events occurred, such as when an order was placed or changed. While this application logic is fairly simple, there is still a cost to coding, testing, and maintaining this code. You can reduce these application development costs by instead moving this timestamp logic into your DB2 table definitions and relying on DB2's "automatic" timestamp support.

Add a comment
Last Updated on Thursday, 02 September 2010 13:06
Read more...
 
User Rating: / 5
PoorBest 
Partner TechTip: You Need to Consolidate IBM i DB2 Data with Other Databases PDF Print E-mail
Tips & Techniques - Database
Written by Floyd Del Muro   
Friday, 20 August 2010 00:00

Access Oracle, MySQL, SQL Server, and other databases from your IBM i queries.

floyd_delmuroWritten by Floyd Del Muro

Where is your business data? Is it all in IBM i DB2, or do you have data in MySQL, Microsoft SQL Server, or Oracle databases? Do you need to consolidate this data across DB2 partitions? Does your current reporting and data access solution consolidate and provide instant access to this remote data?

Add a comment
Last Updated on Wednesday, 18 August 2010 11:46
Read more...
 
TechTip: Tracking DB2 QSQSRVR Job Usage Just Got a Lot Easier PDF Print E-mail
Tips & Techniques - Database
Written by Kent Milligan   
Friday, 06 August 2010 00:00

A new enhancement allows you to track and identify the QSQSRVR jobs that are being used by an application or a job.

kent_milligan_117x117Written by Kent Milligan

The DB2 for i database has long been known as a relational database that is simple to manage and administer. This design goal is one of the reasons that IBM has improved the management of DB2 QSQSRVR jobs through recent enhancements. One of these enhancements is documented in the "Grab Control of DB2 QSQSRVR Jobs" TechTip. That management enhancement provides users the ability to change which subsystem the QSQSRVR jobs run in.

Add a comment
Last Updated on Monday, 02 August 2010 15:32
Read more...
 
User Rating: / 3
PoorBest 
TechTip: Do You Understand the DB2 for i Environment Settings? PDF Print E-mail
Tips & Techniques - Database
Written by Michael Sansoterra   
Friday, 04 June 2010 00:00

Learn how to configure a DB2 for i SQL session, and discover the essential differences between DB2 for i and other relational databases.

Written by Michael Sansoterra

There are many non-IBM i developers out there who have opportunities to develop applications that interact with the i and its DB2 data store (aka AS/400, iSeries, i5, System i). These developers are many and varied and can include .NET and Java developers, Visual Basic and VBA developers, and Web and SQL developers of many stripes. Generally, these folks already have some level of experience with SQL. Basic SQL is generally portable among databases, but because of the unique nature of DB2 for i, developers need to understand some introductory concepts before tackling a DB2 for i project. This TechTip introduces a few important concepts essential for the i SQL environment.

Add a comment
Last Updated on Friday, 04 June 2010 00:00
Read more...
 
User Rating: / 5
PoorBest 
TechTip: Grab Control of the DB2 QSQSRVR Jobs PDF Print E-mail
Tips & Techniques - Database
Written by Kent Milligan   
Thursday, 01 April 2010 23:00

Apply subsystem work management techniques to the QSQSRVR jobs used by DB2.

kent_milligan_117x117Written by Kent Milligan

Assigning jobs to a specific subsystem is a common IBM i work management technique to allocate memory and provide a degree of isolation to jobs with similar processing characteristics or response time requirements. Until some recent PTFs were delivered, DB2 for i's usage of QSQSRVR jobs for processing SQL statements didn't fit well with the methodology of using subsystems to isolate and control jobs.

Add a comment
Last Updated on Thursday, 01 April 2010 23:00
Read more...
 
User Rating: / 1
PoorBest 
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...
 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 6 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