TechTips / Database


TechTip: Database Blocking Made Simple PDF Print E-mail
Tips & Techniques - Database
Written by Kent Milligan   
Friday, 01 April 2011 00:00

Take advantage of record block size special values to boost application performance during sequential data processing.

kent_milligan_117x117Written by Kent Milligan

One of the most common recommendations to improve the performance of database-intensive applications is to increase the amount of database blocking. This performance advice especially holds true when the application program is performing sequential data processing.

Add a comment
Last Updated on Wednesday, 30 March 2011 10:38
Read more...
 
User Rating: / 2
PoorBest 
TechTip: IBM OmniFind Yahoo Edition Search Engine Is Free PDF Print E-mail
Tips & Techniques - Database
Written by Max Hetrick   
Friday, 14 January 2011 00:00

IBM's open-source OmniFind search engine easily turns intranets into a searchable format for employees and customers.

max_hetrickWritten by Max Hetrick

One of the biggest problems that I faced recently was trying to come up with a good solution to create an indexed search database across multiple intranet formats. Along with static HTML pages, we use WordPress to host intranet news and some content management, wikis are used to hold frequently changing information that users can edit themselves, and network shares are utilized in some cases. Although each of these technologies often presents a tool to search their own implementation, I wanted something to index all of them with one interface to search from. Otherwise, a user has to know which Web site or format the material is in and then go search using each individual search feature.

Add a comment
Last Updated on Friday, 14 January 2011 00:00
Read more...
 
User Rating: / 1
PoorBest 
TechTip: JD Edwards Reporting Made Easy! PDF Print E-mail
Tips & Techniques - Database
Written by Robert Andrews   
Friday, 17 December 2010 00:00

New functionality in DB2 Web Query version 1.1.2 simplifies JD Edwards reporting.
robert_andrewsWritten by Robert Andrews

In my last TechTip, "How'd You Get Your SQL Server Data in My IBM i DB2 Data!?!," I explained how we could integrate Microsoft SQL Server data into the drag-and-drop world of DB2 Web Query reporting. In this TechTip, I will discuss how to integrate data from Oracle's JD Edwards line of applications. The IBM i has consistently been a strong platform for this application. However, because of the data structure, accessing JD Edwards data outside of its application was difficult.

Add a comment
Last Updated on Thursday, 16 December 2010 11:15
Read more...
 
User Rating: / 3
PoorBest 
TechTip: How'd You Get Your SQL Server Data in My IBM i DB2 Data!?! PDF Print E-mail
Tips & Techniques - Database
Written by Robert Andrews   
Friday, 05 November 2010 00:00

IBM DB2 Web Query integrates with Microsoft SQL Server.

robert_andrewsWritten by Robert Andrews

DB2 Web Query is a great tool for reporting and graphing data on IBM i. It has built-in capabilities that allow DB2 Web Query to access data on any IBM i Power System. This starts to bring the power of a federated database into IBM i. A federated database system is one in which a single system accesses data that resides on multiple database systems. In the past, data was often replicated from one system to another to allow this type of access. However, this leads to issues with data being out of date, out of sync, and out of control. To help extend federated database capabilities, DB2 Web Query introduced the Microsoft SQL Server adapter.

Add a comment
Last Updated on Thursday, 04 November 2010 09:53
Read more...
 
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 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

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