TechTips


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: 24/7 Notifications from Your IBM i PDF Print E-mail
Tips & Techniques - Collaboration & Messaging
Written by Serge Charbit   
Friday, 14 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 Friday, 07 November 2014 11:02
Read more...
 
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: / 2
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 
A Halloween TechTip PDF Print E-mail
Tips & Techniques - Programming
Written by David Shirey   
Friday, 31 October 2014 00:00

RPG and Web programmers. Like apples and ear muffs. Different and separate. One of these things is not like the other; one of these things is a little bit strange. Does it have to be that way?

david shireyWritten by David Shirey

They were exhausted and out of breath when they reached the top of the ridge. Her blouse was torn, but he hardly noticed, glancing over his shoulder at the line of torches following them from the valley below.

Add a comment
Last Updated on Friday, 31 October 2014 00:00
Read more...
 
User Rating: / 2
PoorBest 
Partner TechTip: How Do I Know When I Need a Data Warehouse? PDF Print E-mail
Tips & Techniques - Database
Written by Alan Jordan   
Friday, 31 October 2014 00:00

Combining information from different sources often creates challenges that can't be solved within the reporting tool. A data warehouse can get you back on track.

alan jordanWritten by Alan Jordan

Obtaining a query and reporting tool is a common way organizations get started with business intelligence (BI). Creating reports, dashboards, and portals directly from the data seems like a natural progression.

 

This approach works well in many implementations and meets the organization's needs for years. But some operational data can be pretty hard to work with. Some databases simply were not designed for reporting use and many lack the documentation that could make them easier to use. Cryptic column names, complex relationships, inconsistencies, legacy dates, huge data volumes, and many other issues may need to be overcome to achieve the results you need from your BI investment.

Add a comment
Last Updated on Friday, 31 October 2014 00:00
Read more...
 
Partner TechTip: File Monitoring and Other Features of Robot SCHEDULE 12 PDF Print E-mail
Tips & Techniques - System Administration
Written by Chuck Losinski   
Friday, 17 October 2014 00:00

Let's say you have a bank transmission or FTP process that occurs randomly throughout the day. How do you monitor that activity? OPAL? CLP scripts? Not anymore!

ChuckLosinski 116x116Written by Chuck Losinski

Version 12 of Robot SCHEDULE contains some helpful new features that will improve your processes and add value for your business. Perhaps the most important of these features are the new event monitors that can be set up to monitor file activity, allowing Robot SCHEDULE to react to file and directory events happening on IBM i.

Add a comment
Last Updated on Friday, 17 October 2014 00:00
Read more...
 
TechTip: RACF Exits PDF Print E-mail
Tips & Techniques - Security
Written by Dinesh Dattani   
Friday, 10 October 2014 00:00

It's best to avoid RACF exits, but if you must have them, mitigate their risk.

dinesh dattaniWritten by Dinesh Dattani

Editor's note: This article is an excerpt from Chapter 16 of IBM Mainframe Security.

 

A RACF exit is an optional facility provided in RACF to perform special RACF processing, above and beyond what is offered in standard RACF. RACF exits can overrule decisions made by standard RACF processing. They provide a means for an installation to tailor RACF processing to suit its own unique needs.

Add a comment
Last Updated on Thursday, 09 October 2014 13:02
Read more...
 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 1 of 183

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