TechTips / Database


TechTip: Qport Office - A No-Fee Timesaver for IBM Query/400 Users PDF Print E-mail
Tips & Techniques - Database
Written by Bill Langston   
Friday, 29 January 2016 01:00

With this interface to Query/400, users don't need to know how to build queries or write SQL statements. And the accounting department doesn't need to write a check.

bill langstonWritten by Bill Langston

Do you work in a shop where people still use IBM Query/400 (sometimes referred to as STRQRY or WRKQRY)? You aren't alone.

 

Yes, even in 2016, IBM Query/400 remains the first tool thousands of IBM i users turn to when they need a simple report or a custom extract from their DB2 on i database.

Add a comment
Last Updated on Friday, 22 January 2016 13:41
Read more...
 
TechTip: A Word About Multiple-Event Triggers PDF Print E-mail
Tips & Techniques - Database
Written by Mohankumar Saraswatipura   
Friday, 13 November 2015 01:00

Among the uses are generating events and inserting records in tables.

mohan saraswatipuraWritten by Mohankumar Saraswatipura

Editor's note: This article is an excerpt from the book DB2 10.1/10.5 for Linux, UNIX, and Windows Database Administration (Exams 611 and 311): Certification Study Guide.

 

In DB2 10.1, you can create a multiple-event trigger to fire off a trigger action based on one of three possible triggering events—an INSERT, an UPDATE, or a DELETE statement—instead of creating a separate trigger for each event.

 

Multiple-event triggers are supported for both row-level triggers (FOR EACH ROW) and statement-level triggers (FOR EACH STATEMENT), which allows you to transform a complex business rule into sophisticated trigger logic. It also helps you greatly during the database migration process to migrate other database vendor products to DB2.

Add a comment
Last Updated on Friday, 13 November 2015 01:00
Read more...
 
TechTip: How to Use the Multi-Temperature Storage Feature in DB2 PDF Print E-mail
Tips & Techniques - Database
Written by Mohankumar Saraswatipura   
Friday, 25 September 2015 01:00

Is your data hot, warm, or cold?

mohan saraswatipuraWritten by Mohankumar Saraswatipura

Editor's note: This article is an excerpt from the book DB2 10.1/10.5 for Linux, UNIX, and Windows Database Administration (Exams 611 and 311): Certification Study Guide.

 

The amount of data stored in enterprise data warehouse environments is growing at an exponential rate. At the same time, the end-user experience expectations are getting higher and higher. The challenge here is to store enormous amount of data without impacting application query performance and storage costs.

Add a comment
Last Updated on Thursday, 24 September 2015 14:15
Read more...
 
Partner TechTip: Dirty Data: One of the Largest Hidden Costs of Doing Business PDF Print E-mail
Tips & Techniques - Database
Written by Alan Jordan   
Friday, 18 September 2015 01:00

Poor data quality is more common than you thinkand the consequences can be devastating.

alan jordanWritten by Alan Jordan

Organizations today are drowning in data. It's coming from industry groups, your website, and your own employees. But is your data accurate? And if it's not, how much damage could it cause?

Add a comment
Last Updated on Friday, 18 September 2015 01:00
Read more...
 
TechTip: Wizard Analytics on DB2 Web Query, Part 2 PDF Print E-mail
Tips & Techniques - Database
Written by Kathryn Steinbrink   
Friday, 11 September 2015 01:00

Jump-start your BI analytics by generating an automatic suite of dashboards and reportsover your datawith a few clicks of the mouse!

kathy steinbrinkWritten by Kathy Steinbrink

IBM recently delivered a new Wizard Analytics feature within DB2 Web Query. It allows individuals to automatically generate an impressive suite of reports and dashboards against their DB2, spreadsheet, or delimited flat file data in a few minutes and with only a few clicks of the mouse.

Add a comment
Last Updated on Friday, 11 September 2015 01:00
Read more...
 
User Rating: / 1
PoorBest 
TechTip: Work with JSON Arrays in DB2 for i PDF Print E-mail
Tips & Techniques - Database
Written by Michael Sansoterra   
Friday, 17 July 2015 01:00

Learn how to parse DB2 for i JSON using JSON_TABLE and JSON_TABLE_BINARY.

Written by Michael Sansoterra

In my previous JSON tip, I introduced DB2's new ability to store and parse JSON data using SQL in DB2 for i. This tip continues the topic of JSON parsing by discussing the JSON_TABLE and JSON_TABLE_BINARY table functions and their ability to process JSON arrays.

Add a comment
Last Updated on Wednesday, 29 July 2015 12:42
Read more...
 
User Rating: / 1
PoorBest 
TechTip: Store and Parse JSON Data Natively with DB2 for i PDF Print E-mail
Tips & Techniques - Database
Written by Michael Sansoterra   
Friday, 26 June 2015 01:00

Learn how the latest DB2 for i features can reduce development time when interacting with the popular JSON data format.

Written by Michael Sansoterra

In my prior tip about using JSON with DB2 for i, I articulated a method of accessing JSON with SQL by use of Java external user-defined functions (UDFs) that convert JSON to XML and XML to JSON. Starting in IBM i 7.1 TR10 (Database Group PTF Level 34) and IBM i 7.2 TR2 (Database Group PTF Level 5), IBM has added native JSON support to the DB2 for i database engine. Keep in mind that, at this first release, the JSON support is still considered a "technology preview," so be sure to test any JSON implementations carefully before using them in production. Also, based on available documentation, some of these features and JSON functions are not yet advertised by IBM for the IBM i and may be subject to change.

Add a comment
Last Updated on Friday, 26 June 2015 01:00
Read more...
 
User Rating: / 2
PoorBest 
TechTip: Wizard Analytics on DB2 Web Query, Part 1 PDF Print E-mail
Tips & Techniques - Database
Written by Kathryn Steinbrink   
Friday, 26 June 2015 01:00

Business analysts, developers, administrators, and even non-technical individuals can get started generating sophisticated reports and visualizationsover their own datain minutes!

kathy steinbrinkWritten by Kathy Steinbrink

IBM DB2 Web Query for i is an analytics tool for modernizing Query/400 reports and delivering analytics to the web or mobile devices. It's a web-based Business Intelligence (BI) solution for visualizing, analyzing, and sharing critical business data. Available since 2007 on the IBM i platform, DB2 Web Query has delivered through the years a steady heartbeat of new function.

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

Page 2 of 16

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