TechTips / Database


Partner TechTip: Three Target Areas for Successful KPI Rollout PDF Print E-mail
Tips & Techniques - Database
Written by Mike Stegeman   
Friday, 19 April 2013 00:00

More companies, across all industries, are gathering data in huge quantities. They have determined that data is the key to their business and are using it to guide their organizations.

mike stegemanWritten by Mike Stegeman

What is a Key Performance Indicator? Every task can have a KPI, but which information is measured should be unique to your organization. Sales goals, net income targets, production efficiency, and downtime are just a few of the possible areas ready for a KPI. You need to start with an overall organizational KPI or goal for every other measurable KPI to adhere to.

Add a comment
Last Updated on Friday, 19 April 2013 00:00
Read more...
 
Partner TechTip: Your Whole Team Needs Access to Your Enterprise Data PDF Print E-mail
Tips & Techniques - Database
Written by Mike Stegeman   
Friday, 15 March 2013 00:00

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

mike_stegemanWritten by Mike Stegeman

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? Do your developers need to move or modify data from one database to another?

Add a comment
Last Updated on Thursday, 14 March 2013 12:13
Read more...
 
User Rating: / 1
PoorBest 
TechTip: Simplify Stored Procedure Upgrades with Parameter Defaults PDF Print E-mail
Tips & Techniques - Database
Written by Kent Milligan   
Wednesday, 12 December 2012 00:00

A new PTF makes it all so easy.

kent milligan 117x117Written by Kent Milligan

The use of DB2 for i stored procedures by IBM i developers is on the rise. With stored procedures entrenched in application environments, developers are quickly learning that an upgraded version of a stored procedure featuring new input parameters requires a number of coding changes to be made. All of the programs that invoke the stored procedure need to be modified to pass values for the new parameters.

Add a comment
Last Updated on Friday, 04 January 2013 09:35
Read more...
 
User Rating: / 1
PoorBest 
TechTip: Free Database Modernization Diagnostic Utility PDF Print E-mail
Tips & Techniques - Database
Written by Resolution Software Ltd.   
Friday, 12 October 2012 00:00

Save days of analysis by using this free utility to help gauge the scope and effort involved in migrating your DDS-generated files to SQL DDL.

Written by Resolution Software

By now, almost everyone knows that SQL is the strategic database interface for IBM i. Nearly every DB2 for i enhancement made since V5R1 has been SQL-only, including XML and ROWID data types, automatic key generation with identity columns, OLAP capabilities, column-level and instead-of triggers, autonomic indexes, and self-learning query optimizations.

Add a comment
Last Updated on Friday, 12 October 2012 00:00
Read more...
 
Tech Tip: Create Excel Spreadsheets with IBM i Data PDF Print E-mail
Tips & Techniques - Database
Written by PlanetJ Corporation   
Friday, 17 August 2012 00:00

With this free app, you'll be generating reports in minutes.

Written by PlanetJ Corporation

MS Excel is used in the business world for an unlimited number of reasons—basic accounting, product sales tracking, executive financials, and customer data to name a few. Having a good system to access the data— providing appropriate filters—allows users to limit data returned to what's applicable for any particular report.

Add a comment
Last Updated on Thursday, 16 August 2012 10:42
Read more...
 
TechTip: Easier DB2 for i Data Transfers with New Technology Refresh PDF Print E-mail
Tips & Techniques - Database
Written by Kent Milligan   
Friday, 13 July 2012 00:00

Using three-part names, Insert statements can now reference objects from more than one IBM i system.

kent milligan 117x117Written by Kent Milligan

The GA version of the DB2 for i 7.1 release simplified access to DB2 objects on remote systems by eliminating the need for explicit remote connections with the new three-part name support. Instead of developers having to use an extra CONNECT or SET CONNECTION statement to explicitly connect statement, they can now simply run an SQL statement like the following to retrieve data from a table on a different system or partition.

Add a comment
Last Updated on Friday, 13 July 2012 00:00
Read more...
 
User Rating: / 1
PoorBest 
TechTip: DB2's CONNECT BY Simplifies Recursive Processing PDF Print E-mail
Tips & Techniques - Database
Written by Kent Milligan   
Friday, 13 April 2012 00:00

At first glance, recursion appears to be a computer science method that's relevant only in the world of academia.

kent_milligan_117x117Written by Kent Milligan

Recursion is a great for traversing linked lists or generating the numbers of a Fibonacci sequence, but recursion can't be applied to business problems…or can it? 


In reality, there are several industries where data elements have inherent relationships with other elements, and the best way to connect these data elements is with recursive (or hierarchical) processing. The classic example is the generation of a bill of materials explosion in the manufacturing industry. A bill of materials explosion breaks apart each assembly or sub-assembly into its component parts.

Add a comment
Last Updated on Friday, 13 April 2012 00:00
Read more...
 
User Rating: / 1
PoorBest 
Partner TechTip: Make Better Business Decisions Using SEQUEL Executive Dashboards PDF Print E-mail
Tips & Techniques - Database
Written by Mike Stegeman   
Friday, 17 February 2012 00:00

Can your decision-makers get the data they need quickly and easily?

mike_stegemanWritten by Mike Stegeman

Do you store your data on different servers throughout your enterprise? Do you use different tools to extract, cleanse, and present the data? Can your decision-makers quickly get the data they need to do their jobs?

 

As the processes of data access, extraction, and presentation become more complex and costly, you need a solution that lets you access multiple data sources and get answers fast.

Add a comment
Last Updated on Friday, 17 February 2012 00:00
Read more...
 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

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