TechTips / Database


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...
 
TechTip: Simplify Tracking of DB2 Table Metrics PDF Print E-mail
Tips & Techniques - Database
Written by Kent Milligan   
Friday, 20 January 2012 00:00

Managing and tracking DB2 tables just got a lot easier, with metrics such as table size and number of rows at your fingertips.

kent_milligan_117x117Written by Kent Milligan

On other database servers, database administrators have to keep a close watch on the size and number of rows in a table to make sure that enough disk space has been allocated for the table object. While DB2 for i automates the storage allocation administrative task, it's helpful for IBM i users to know the size of a table to estimate how long a query or copy operation might take. Typically, the more rows a table contains, the longer it takes perform operations against the table.

Add a comment
Last Updated on Friday, 20 January 2012 00:00
Read more...
 
User Rating: / 3
PoorBest 
TechTip: Achieve Memory-Making SQL Performance with DB2 In-Memory Support PDF Print E-mail
Tips & Techniques - Database
Written by Kent Milligan   
Friday, 28 October 2011 00:00

Faster, faster, faster! Use large memory pools to boost your SQL performance.

kent_milligan_117x117Written by Kent Milligan

More companies are creating and running queries to help their business leaders make better decisions, ones that are based on data facts instead of educated guesses. As users see the business value provided by these reports, it's only a matter of time before they'll ask for the reports to run faster.

Add a comment
Last Updated on Friday, 28 October 2011 00:00
Read more...
 
User Rating: / 2
PoorBest 
TechTip: Secure Your Reports in a New Way with DB2 Web Query DBA PDF Print E-mail
Tips & Techniques - Database
Written by Gene Cobb   
Friday, 14 October 2011 00:00

Learn how a recent enhancement to DB2 Web Query provides a way to customize a granular yet secure reporting environment.

gene_cobbWritten by Gene Cobb

V1R1M2 of IBM DB2 Web Query for i was a significant version, one that offered new features such as the InfoAssist development tool as well as the Oracle JD Edwards Application Adapter. One feature that has flown a bit under the radar is a security enhancement named DBA (short for Database Administrator). This new feature is found in the synonym editor in DB2 Web Query Developer Workbench. It provides a way to configure a secure reporting environment that is both granular and flexible.

Add a comment
Last Updated on Wednesday, 12 October 2011 14:53
Read more...
 
User Rating: / 3
PoorBest 
TechTip: Cast Binary Data to Built-in Data Types PDF Print E-mail
Tips & Techniques - Database
Written by Michael Sansoterra   
Friday, 22 July 2011 00:00

Give DB2 new functionality with the ability to CAST from binary data.

Written by Michael Sansoterra

Whether it be a hash value, raw data from another system, or something else, every once in a while, I find myself manipulating binary data within an application. However, in SQL, it's a royal pain to convert binary data to another built-in data type.

Add a comment
Last Updated on Friday, 22 July 2011 00:00
Read more...
 
User Rating: / 1
PoorBest 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

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