TechTips / Database


TechTip: i Illuminate 7.3 – Time-Turner PDF Print E-mail
Tips & Techniques - Database
Written by Scott Forstie   
Friday, 22 April 2016 00:00

Traveling back in time is easy and can answer important questions. Take the next step with Scott on this journey through the castle.

Written by Scott Forstie

Glad you could join me for episode two of this series. When I last talked to you, I had just learned what house the Sorting Hat had chosen for me. In an unexpected turn of events, I am bound for the house of Slytherin. Unlike some before me, I don’t resist the decision, bowing to the wisdom of the enchanted hat. Perhaps I’m comforted by the knowledge that my path will be influenced by future decisions that I can control.

 

My housemates welcome me with open arms and wary looks. After some time has passed, I have settled into a routine of training and competition. I am intrigued by the possibilities that lie before me. Much like my life here in the castle, DB2 for i on IBM i 7.3 provides similar opportunities for new adventures.

Add a comment
Last Updated on Friday, 22 April 2016 00:00
Read more...
 
User Rating: / 1
PoorBest 
TechTip: SSIS Data Sources for IBM i DB2 and Microsoft SQL Databases PDF Print E-mail
Tips & Techniques - Database
Written by Thomas Snyder   
Friday, 08 April 2016 01:00

Here’s a reusable reference for connecting your SSIS to your IBM and Microsoft databases.

tom snyderWritten by Tom Snyder

I’ve been introducing the Microsoft SSIS technologies to the IBM community, who is showing interest, and I would like to continue providing more. Modular programming is always a good thing, so I’m going to try to reduce the initial data source configuration overhead in my articles by creating this reusable, modular article that is the starting point for any SSIS packages using databases.

Add a comment
Last Updated on Wednesday, 06 April 2016 10:43
Read more...
 
User Rating: / 1
PoorBest 
TechTip: DB2 for i Optimization Strategies, Part 1 PDF Print E-mail
Tips & Techniques - Database
Written by Michael Sansoterra   
Friday, 01 April 2016 01:00

Avoid common SQL programming mistakes that can drag application performance.

Written by Mike Sansoterra

As databases grow larger over time, users and administrators often witness a decrease in performance. A query that once performed well when it was first written eventually becomes lethargic. In this series of tips, I will discuss some common goofs that can take the wind out of your database sails.

Add a comment
Last Updated on Friday, 01 April 2016 01:00
Read more...
 
TechTip: Implementing JSON in DB2 Made Easy PDF Print E-mail
Tips & Techniques - Database
Written by Mohankumar Saraswatipura   
Friday, 18 March 2016 01:00

DB2 JSON is simple to implement and maintain.

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.

 

IBM DB2 10.5 FP1 introduced JSON support. DB2 JSON provides a complete storage/persistence solution for JSON documents. The solution combines application server-side components with JSON enhancements and functions in the DB2 engine.

Add a comment
Last Updated on Friday, 18 March 2016 01:00
Read more...
 
TechTip: How to Change a Database Code Set PDF Print E-mail
Tips & Techniques - Database
Written by Mohankumar Saraswatipura   
Friday, 12 February 2016 01:00

Learn how to migrate data from a non-Unicode database to a Unicode database.

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.

 

 Both BLU and pureScale require databases to be Unicode, so you should create all new databases as Unicode. Chances are good that the requirement to convert data to a Unicode code set will happen. Because a database cannot be altered to a different code set, this will mean you must unload and load the data.

 

 In the past, string units of character data have been stored in a relational database in bytes. So for a single-byte character set (SBCS), each character represents one byte. The string unit of the column data type is a byte, sometimes referred to as an octet.

Add a comment
Last Updated on Thursday, 11 February 2016 13:42
Read more...
 
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...
 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

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