TechTips


TechTip: SQL Date and Time Arithmetic PDF Print E-mail
Tips & Techniques - SQL
Written by Jim Cooper   
Friday, 20 February 2015 00:00

Are you looking for a hands-on approach that provides start-to-finish coverage of database design and SQL

Written by James Cooper

Editor's note: This TechTip is an excerpt from Chapter 6, "Single-Table Queries," of Database Design and SQL for DB2 (MC Press, 2013).

 

SQL on IBM i includes expressions and functions for working with date and time values. Externally, date values are character strings containing numbers for the year, month, and day and (in some formats) date separators. When a literal date is entered, the value is coded as a string. The format of the string depends on the values specified for the DATFMT and DATSEP parameters. For example, if *ISO format is specified, the following string represents May 1, 2011:

Add a comment
Last Updated on Thursday, 19 February 2015 11:25
Read more...
 
User Rating: / 1
PoorBest 
TechTip: More on Combining Multiple Row Values into a Single Row with SQL in DB2 for i PDF Print E-mail
Tips & Techniques - SQL
Written by Kent Milligan   
Friday, 13 February 2015 00:00

Leverage recursive table expressions to pivot row values into a single column.

kent milligan 117x117Written by Kent Milligan

After my last article, I had a number of readers express interest in a solution that would work on servers running pre-IBM i 7.1 operating system release levels. Luckily, recursive SQL capabilities were first made available with the DB2 for i V5R4 release, so this article will provide a solution that can run on release levels of V5R4 and newer.

Add a comment
Last Updated on Friday, 13 February 2015 00:00
Read more...
 
TechTip: Trying on a Ruby Ring PDF Print E-mail
Tips & Techniques - Programming
Written by Aaron Bartell   
Friday, 06 February 2015 00:00

Ruby is a great language and is now supported on IBM i, but is it right for you? The best way to find out is to try on this Ruby ring.

aaron bartellWritten by Aaron Bartell

First, I want to thank MC Press Online for having me back writing again. The last article I wrote goes back to 2007; it's been too long, and I am humbled to be writing in the same publication as other great authors.

 

In the fall of 2013, PowerRuby became a formal port of the Ruby language and Rails web framework for IBM i, and in the spring of 2014, David Shirey introduced you to Ruby, giving an overview of history and comparison with other languages. This article will build on that foundation and dive into some tangible things you can try on your IBM i as a means to, as they say, "kick the tires"or maybe better stated: let's try on this Ruby ring and see how it fits.

Add a comment
Last Updated on Friday, 06 February 2015 09:07
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: A Primer on Payment Security PDF Print E-mail
Tips & Techniques - Security
Written by David Shirey   
Friday, 30 January 2015 00:00

If you handle credit card payment data in your company, you're probably familiar with the Payment Card Industry Council. But they're no longer the only game in town. Maybe it's time to look at the broad issues.

david shireyWritten by David Shirey

If you handle credit card payments in your company, you know that PCI compliance has been the gold standard for the last decade. And if you've been paying any attention lately, you know that Apple Pay was announced in October 2014 and is getting a lot of press as being the future of electronic payments.

Add a comment
Last Updated on Friday, 30 January 2015 00:00
Read more...
 
User Rating: / 1
PoorBest 
TechTip: Build Web Apps with the Flip of a LightSwitch PDF Print E-mail
Tips & Techniques - Dev Tools
Written by Michael Sansoterra   
Friday, 16 January 2015 00:00

Microsoft LightSwitch allows developers to quickly create HTML applications with minimal coding.

Written by Michael Sansoterra

In my article on SOA and REST, I explained in general terms how to build applications that can be accessed from virtually any device or platform within your own private network or from the Internet. Further, in IBM i Devs Get Some REST with OData, I discussed the OData protocol (aka "ODBC for the web") and explained how it's used to build a self-describing REST API so that "OData-aware" tools can easily integrate with an OData-based API. In this article, I show how all the pieces of developing a modern app, including using multiple tiers and OData-based REST access, come together using Microsoft's LightSwitch. I'll also reveal a stumbling block for IBM i shops that want to use LightSwitch.

Add a comment
Last Updated on Friday, 16 January 2015 00:00
Read more...
 
User Rating: / 1
PoorBest 
TechTip: Combining Multiple Row Values into a Single Row with SQL in DB2 for i PDF Print E-mail
Tips & Techniques - SQL
Written by Kent Milligan   
Friday, 09 January 2015 00:00

Leverage recursive SQL to pivot row values into a single column.

kent milligan 117x117Written by Kent Milligan

Often, when looking at a report, a user prefers to see similar values grouped together on a single line of output instead of having those values spread across multiple lines of report. An example of that type of report is displayed in the table below. For each automobile make, the report lists all of the models that are currently in inventory in a single row of the report.

Add a comment
Last Updated on Wednesday, 14 January 2015 09:45
Read more...
 
User Rating: / 1
PoorBest 
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 185

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