TechTips


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 
TechTip: Custom Sorting with GridX PDF Print E-mail
Tips & Techniques - Programming
Written by Danielle Carmon   
Friday, 05 December 2014 00:00

Learn how to do custom sorting with GridX. GridX is an opensource JavaScript library that makes it easy to create sophisticated interactive tables for the web.

daniell carmonWritten by Danielle Carmon

Why use special sorting?

 

GridX will do sorting for you if you use the sort module, but custom sorting is a subtle tweak to enhance the user's experience. If you're just interested in basic sorting (specifying an initial sort order, etc.), GridX has documentation here. If you don't specify a customized sort method, GridX will use the standard sorting for the data type. However, frequently you will need something more sophisticated than an alphabetical sort for strings. Also, what if your column is displaying data from an object? GridX will have no idea how the objects should be sorted unless you specify a custom sort.

Add a comment
Last Updated on Thursday, 04 December 2014 11:24
Read more...
 
TechTip: 24/7 Notifications from Your IBM i PDF Print E-mail
Tips & Techniques - Collaboration & Messaging
Written by Serge Charbit   
Wednesday, 26 November 2014 00:00

SP4i-Push offers free plug-and-play mobile messaging for up to 10 users.

serge charbitWritten by Serge Charbit

Today, with a smartphone in your pocket, you can get up-to-the-minute information from nearly anywhere—your friends, the news, social media, your email. So why is it so difficult to stay on top of important information from your IBM i applications and systems when you can't log on?

Add a comment
Last Updated on Tuesday, 25 November 2014 10:21
Read more...
 
TechTip: DB2 for i's Sample Database PDF Print E-mail
Tips & Techniques - Database
Written by Kent Milligan   
Friday, 14 November 2014 00:00

The built-in sample database makes self-learning and prototype activities easier.

kent milligan 117x117Written by Kent Milligan

Almost all of the DB2-related TechTips that I have written highlight new DB2 for i functions and features. While it's good to raise awareness of new DB2 capabilities, this does result in existing DB2 features being overlooked. This is especially true of the more ordinary database functions.

Add a comment
Last Updated on Friday, 14 November 2014 00:00
Read more...
 
User Rating: / 1
PoorBest 
TechTip: JSON and XML Conversion in DB2 for i PDF Print E-mail
Tips & Techniques - Programming
Written by Michael Sansoterra   
Friday, 07 November 2014 00:00

Use the java-json library to easily convert between XML and JSON formats.

Written by Michael Sansoterra

As I noted in my article on SOA and REST, JavaScript Object Notation (JSON) is an important data format in today's world of RESTful service offerings. Whether your apps are publishing or consuming data, you may be asked to work with JSON. This tip offers an "el cheapo" technique on how to transform JSON to XML and vice versa, because XML is easy to work with in the RPG ILE and DB2 for i environment.

Add a comment
Last Updated on Friday, 07 November 2014 08:01
Read more...
 
User Rating: / 3
PoorBest 
TechTip: Rational Developer for i (RDi) and iSphere: The Missing Link PDF Print E-mail
Tips & Techniques - Dev Tools
Written by Frank Hildebrandt   
Friday, 07 November 2014 00:00

iSphere is a must-have tool for everyone who is developing with RDi.

frank hildebrandtWritten by Frank Hildebrandt

Rational Developer for i (RDi) becomes more and more popular in the IBM i community. In particular, the graphical editors provide significant improvements over the old green-screen editors, making things much easier for the developers writing programs and designing screens and reports. But there are still some gaps, some features we are painfully missing that force us to switch to a green-screen session from time to time. This is the point where iSphere comes in.

Add a comment
Last Updated on Thursday, 06 November 2014 12:10
Read more...
 
User Rating: / 3
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