TechTips / Database


TechTip: Even More Nifty New Features in V2R1 DB2 Web Query PDF Print E-mail
Tips & Techniques - Database
Written by Gene Cobb   
Friday, 28 March 2014 00:00

Recent DB2 Web Query group PTF levels 4 through 7 include a host of valuable new enhancements. Learn more about what are sure to be this product's most popular new features.

gene cobbWritten by Gene Cobb

In my last TechTip, I introduced you to several new features that have been delivered in DB2 Web Query version 2.1 group PTFs over the last year and a half. In this TechTip, you'll learn about three more major improvements to the product: REST Web Services, an application extension named WQRAX, and the new map-charting feature.  

Add a comment
Last Updated on Thursday, 27 March 2014 17:24
Read more...
 
User Rating: / 2
PoorBest 
TechTip: Some Nifty New Features in V2R1 DB2 Web Query PDF Print E-mail
Tips & Techniques - Database
Written by Gene Cobb   
Friday, 07 March 2014 00:00

Recent DB2 Web Query group PTF levels 4 through 7 include a host of valuable new enhancements. Learn more about what are sure to be the most popular new features in this product.

gene cobbWritten by Gene Cobb

Version 2.1 of DB2 Web Query for IBM i was released in June of 2012 and included a major overhaul of product ordering and packaging as well as many new enhancements. Since that time, IBM has released seven group PTFs, each one containing both fixes and exciting new features. In this two-part article, I cover some of the most significant new enhancements made to the product over the last 18 months.

Add a comment
Last Updated on Thursday, 06 March 2014 14:09
Read more...
 
Partner TechTip: Convert Queries for Increased Performance and Modern Results PDF Print E-mail
Tips & Techniques - Database
Written by Heath Kath   
Friday, 28 February 2014 00:00

Don't let a library of useful but outdated queries stop you from modernizing how you deliver your data.

heath kathWritten by Heath Kath

Are you still running IBM i green-screen queries? How many queries are you dealing with? Are you finding it hard to manage all those queries? Are your users tired of waiting for a slow-running query that can use only the Classic Query Engine (CQE)? Would your users prefer a modern, graphical interface with more distribution options?

Add a comment
Last Updated on Friday, 21 February 2014 14:17
Read more...
 
User Rating: / 1
PoorBest 
TechTip: Add Lock Detection to Your DB2 for i Arsenal PDF Print E-mail
Tips & Techniques - Database
Written by Michael Sansoterra   
Friday, 13 December 2013 00:00

Use the table function equivalents of Display Record Lock (DSPRCDLCK) and Work with Object Locks (WRKOBJLCK) in your SQL code.

Written by Michael Sansoterra

If you've ever wanted to yell at users and tell them to exit a specific screen (or wanted to just happily end their job automatically) because they're locking a record, then this tip is for you. Best of all, you'll be able to use this functionality right from the comfort of your SQL code.

Add a comment
Last Updated on Friday, 13 December 2013 00:00
Read more...
 
User Rating: / 1
PoorBest 
TechTip: Get a Grip on Your IBM i Databases with IBM Data Studio PDF Print E-mail
Tips & Techniques - Database
Written by Kent Milligan   
Friday, 11 October 2013 00:00

Increase your database understanding with this free IBM tool.

kent milligan 117x117Written by Kent Milligan

Your physical database implementation plays a key role in the performance and extensibility of your application. Because the AS/400's integrated relational database was so easy to use, many programmers created physical files and logical files without giving much thought to the database model. This approach has resulted in many unwieldy physical databases that are hard to understand.

Add a comment

Last Updated on Friday, 11 October 2013 00:00
Read more...
 
Partner TechTip: Master Your Big Data with SEQUEL PDF Print E-mail
Tips & Techniques - Database
Written by Heath Kath   
Friday, 20 September 2013 00:00

Wouldn't it be nice if big data access was fast and easy with minimal setup time or struggle?

heath kathWritten by Heath Kath

Big data: This term covers a lot of ground. With no definitive dividing line based on file size, data type, number of records, or job requirements, how do you know if you're doing big data? Ask yourself, has the size or speed requirements of new analytic initiatives put serious strain on existing IT infrastructure? Most organizations could say yes because big data is everywhere.

Add a comment
Last Updated on Friday, 20 September 2013 00:00
Read more...
 
TechTip: Keep DB2 Routines in Synch Across Systems PDF Print E-mail
Tips & Techniques - Database
Written by Kent Milligan   
Friday, 13 September 2013 00:00

A new assessment utility makes it easy to keep stored procedures and functions synchronized!

kent milligan 117x117Written by Kent Milligan

As more IBM i applications utilize stored procedures and user-defined functions, processes must be put in place to manage these routines just like traditional IBM i program objects. You need to make sure the stored procedures and functions are moved from your development system to production system to ensure that that the application is able to run. Likewise, if you have a backup system that's used for disaster recovery, the routines also need to be propagated to the backup system.

Add a comment
Last Updated on Thursday, 12 September 2013 11:25
Read more...
 
TechTip: Compress Large Object (LOB) Data in DB2 for i PDF Print E-mail
Tips & Techniques - Database
Written by Michael Sansoterra   
Friday, 23 August 2013 00:00

Implement these user-defined functions to save space when storing large amounts of data.

Written by Michael Sansoterra

In modern applications, it's typical to store large amounts of text data, including emails, rich text documents, audit logs, and XML. Recording this information in a database table can impose a significant tax on disk space. However, using a compression algorithm can alleviate this tax. In this tip, I'll demonstrate two user-defined functions that implement ZLib compression to deflate and inflate data that is stored or accessed via DB2 as a large object data type (BLOB, CLOB, and XML).

Add a comment
Last Updated on Wednesday, 21 August 2013 11:05
Read more...
 
User Rating: / 2
PoorBest 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

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