TechTips


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...
 
TechTip: Cascading AJAX Calls with jQuery PDF Print E-mail
Tips & Techniques - Programming
Written by Jan Jorgensen   
Friday, 19 December 2014 00:00

It's no fun when an unbalanced server workload causes problems. So what can you do about it?

jan jorgensenWritten by Jan Jorgensen

Sometimes, you get surprises when you're programming things for different platforms.

 

Normally, I fetch the data I use in my web applications from the IBM i, but some time ago I was trying to get some data from an MS SQL database, and it gave me some challenges that I didn't expect.

Add a comment
Last Updated on Friday, 19 December 2014 11:03
Read more...
 
TechTip: The IBM i Audit Journal Detective PDF Print E-mail
Tips & Techniques - System Administration
Written by Michael Sansoterra   
Friday, 12 December 2014 00:00

Use the audit journal and SQL tools to determine what job is accessing an old program.

Written by Michael Sansoterra

Every whodunnit requires a good detective to solve the case. The IBM i has a built-in detective called security auditing that can be used to help solve many mysteries. Say you're planning to remove a year-old deprecated library from the IBM i when you notice the LAST USED date on a program object (or two) in the library was relatively and unexpectedly recent. At this point, it's time to call in the detective to assist.

Add a comment
Last Updated on Friday, 12 December 2014 15:21
Read more...
 
TechTip: Rapid Fire Is Your IBM i Friend When You Really Need a Friend PDF Print E-mail
Tips & Techniques - System Administration
Written by Frank Hildebrandt   
Friday, 12 December 2014 00:00

Use this open-source product to reduce application downtime when migrating files with huge quantities of records.

frank hildebrandtWritten by Frank Hildebrandt

Do you have files with millions or even billions of records? Imagine you have to change such a filefor example, a new field has to be added. Possibly, you have the time to migrate this file on the weekend. But what if your shop works 24 hours a day and 7 days a week? In this case, it's absolutely necessary to reduce the time needed for the migration to avoid a long shutdown of the application.

Add a comment
Last Updated on Tuesday, 09 December 2014 10:39
Read more...
 
TechTip: Enhanced Debug Experience for SQL Routines in IBM i PDF Print E-mail
Tips & Techniques - SQL
Written by Kent Milligan   
Friday, 05 December 2014 00:00

New enhancements simplify the debug of SQL routines.

kent milligan 117x117Written by Kent Milligan

IBM first improved the debugging of SQL stored procedures, functions, and triggers way back in the V5R2 release when it introduced the *SOURCE debug view. This debug view allowed IBM i developers to debug their original SQL source code instead of having to debug the ugly C code that DB2 for i generates behind the scenes for SQL routines.

Add a comment
Last Updated on Friday, 05 December 2014 00:00
Read more...
 
User Rating: / 1
PoorBest 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 1 of 184

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