TechTips / Database


TechTip: Work with JSON Arrays in DB2 for i PDF Print E-mail
Tips & Techniques - Database
Written by Michael Sansoterra   
Friday, 17 July 2015 00: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, 15 July 2015 10:08
Read more...
 
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 00: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 00: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 00: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 00:00
Read more...
 
Partner TechTip: Data Visualization: Three Keys to Enhancing Business Insight with SEQUEL PDF Print E-mail
Tips & Techniques - Database
Written by Mike Stegeman   
Friday, 22 May 2015 00:00

Giving users data in a modern, usable format helps them work more efficiently, and SEQUEL makes this happen without even leaving IBM i.

mike stegemanWritten by Mike Stegeman

IBM i costs 45 percent less than running Linux servers and 54 percent less than Windows servers, according to a 2014 study by ITG. These calculations are based on the average cost of hardware, licenses, support, personnel, and facilities over a three-year period.

 

While the DB2 database on IBM i is proven to be the most cost-effective platform, some companies are still moving to or adding others. Ease of use is a major factor. Organizations need their members to work effectively, and seeing data in modern, straightforward formats improves productivity.

Add a comment
Last Updated on Thursday, 21 May 2015 11:42
Read more...
 
TechTip: Routing Away Your QZDASOINIT Troubles PDF Print E-mail
Tips & Techniques - Database
Written by Kent Milligan   
Friday, 08 May 2015 00:00

Utilize a new procedure to better manage host server job performance.

kent milligan 117x117Written by Kent Milligan

The good news in the IBM i world is that more and more applications and tools are using modern, industry-standard interfaces such as ODBC, ADO.NET, and JDBC to access DB2 for i databases. The bad news from a systems management perspective is that all of those interfaces by default run in the same subsystem (QUSRWRK) on your IBM i servers. Analysts utilizing an ODBC-based reporting tool are competing for the same resources as those users who are using a JDBC-based OLTP application. Both sets of users have workloads running in QZDASOINIT jobs in the same subsystem.

Add a comment

Last Updated on Thursday, 07 May 2015 14:21
Read more...
 
User Rating: / 1
PoorBest 
TechTip: Secure Sensitive IBM i Data in DB2 for i Monitor Collections PDF Print E-mail
Tips & Techniques - Database
Written by Kent Milligan   
Friday, 10 April 2015 00:00

Leverage new support to protect sensitive data values.

kent milligan 117x117Written by Kent Milligan

Data breaches are unfortunately becoming a regular item in news reports these days. As a result, IT teams everywhere are scrambling to making sure they're using every available security control to protect the sensitive data they own.

Add a comment

Last Updated on Thursday, 09 April 2015 12:05
Read more...
 
Partner TechTip: Flexible Data Access and Deployment Are Just Clicks Away PDF Print E-mail
Tips & Techniques - Database
Written by Mike Stegeman   
Friday, 06 February 2015 00:00

In today's IBM i shops, IT professionals must provide easily accessible information in the formats business users prefer.

mike stegemanWritten by Mike Stegeman

Flexibility is vital in today's IBM i shops, where IT is expected to secure data, write new applications, and keep business users happy. IT professionals also contend with executives needing detailed information at their fingertips. The data can be presented in many formats, but it must be easily accessible.

Add a comment
Last Updated on Friday, 06 February 2015 09:02
Read more...
 
TechTip: The Need to Modernize IBM i Databases: Why and How? PDF Print E-mail
Tips & Techniques - Database
Written by Elie Muyal   
Friday, 09 January 2015 00:00

You can modernize IBM i databases without "breaking" what already works.

elie muyalWritten by Elie Muyal

When speaking about the modernization of the IBM i, usually the first thing that comes to mind is the modernization of the user interface, since it's the visible part of the application. Although it's clear that the benefits of revamping the green-screen user interface are considerable, it's important to remember that the user interface is only a means to access and update the database. The database holds the information, which is the most important asset of any organization.

Add a comment

Last Updated on Friday, 09 January 2015 09:57
Read more...
 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 1 of 15

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