TechTips


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 
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: / 2
PoorBest 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 5 of 188

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