TechTips


TechTip: Installing Git on IBM i PDF Print E-mail
Tips & Techniques - Scripting
Written by Aaron Bartell   
Friday, 31 July 2015 00:00

Git has changed the face of open source collaboration in significant fashion and is easily installable on IBM i.

aaron bartellWritten by Aaron Bartell

In 2012, MC Press author Thomas Snyder produced two pieces (article 1, article 2) on Git describing what it is and how to install it. Instead of digressing into the many advantages of Git, this article will focus on how it can be obtained and installed on IBM i.

Add a comment
Last Updated on Thursday, 30 July 2015 11:40
Read more...
 
TechTip: Building Charts with Highcharts, Part 3 PDF Print E-mail
Tips & Techniques - Scripting
Written by Jan Jorgensen   
Friday, 31 July 2015 00:00

Show off with a gauge chart that's built using RPG.

jan jorgensenWritten by Jan Jorgensen

Hopefully, you've by now read parts 1 and 2 of this series. In this last tip about Highcharts, I'll introduce you to gauge charts. Highcharts offers a range of various gauges that with a minimum of effort can be implemented and used in your daily work.

 

I'll use the one called "Solid gauge," and I'll combine it with an RPG-CGI program that will generate a simple XML output using the CEERAN0 API to generate a random number between 0 and 99.

Add a comment

Last Updated on Thursday, 30 July 2015 11:42
Read more...
 
TechTip: Get Familiar with Wireshark, an Open-Source Packet Analysis Tool PDF Print E-mail
Tips & Techniques - System Administration
Written by Lisa Bock   
Friday, 24 July 2015 00:00

With over 5 million downloads of Wireshark every year, network analysts who have skills in packet analysis set themselves apart. To troubleshoot your network, you should learn, really learn about Wireshark.

lisa bockWritten by Lisa Bock

Packet analysis can analyze network problems, detect network intrusion attempts, perform content monitoring, monitor bandwidth usage per application and process, and verify endpoint security status to see unwanted protocols (such as bogus ARP traffic and Multicast DNS), and gather and report network statistics.

Add a comment
Last Updated on Wednesday, 22 July 2015 14:47
Read more...
 
TechTip: More TR10 and TR2 Enhancements PDF Print E-mail
Tips & Techniques - IBM i (OS/400, i5/OS)
Written by David Shirey   
Friday, 17 July 2015 00:00

In a previous article, we looked at some of the big enhancements that were in the new TR10/TR2 combo for 7.1/7.2. But those celebrities weren't all. This article looks at what's left.

david shireyWritten by David Shirey

To start, if you haven't read the previous article about these enhancements, I suggest you start by doing that. Now, let's move on to the rest of the stuff.

Add a comment
Last Updated on Wednesday, 15 July 2015 10:54
Read more...
 
User Rating: / 1
PoorBest 
TechTip: Work with JSON Arrays in DB2 for i PDF Print E-mail
Tips & Techniques - Database
Written by Michael Sansoterra   
Friday, 17 July 2015 00:00

Learn how to parse DB2 for i JSON using JSON_TABLE and JSON_TABLE_BINARY.

Written by Michael Sansoterra

In my previous JSON tip, I introduced DB2's new ability to store and parse JSON data using SQL in DB2 for i. This tip continues the topic of JSON parsing by discussing the JSON_TABLE and JSON_TABLE_BINARY table functions and their ability to process JSON arrays.

Add a comment
Last Updated on Wednesday, 29 July 2015 11:42
Read more...
 
User Rating: / 1
PoorBest 
TechTip: PHP 7.0 Is Coming, Part 2 PDF Print E-mail
Tips & Techniques - Scripting
Written by David Shirey   
Friday, 10 July 2015 00:00

PHP 7 is coming, but should you run toward it or run for your life? In Part 1 last month, we looked at the history of this release. Now let's get down to the nitty gritty and see what it's got for us.

david shireyWritten by David Shirey

If you have been eagerly awaiting the next big release of PHP, your wait is about over. Scheduled for delivery before the end of the year (tentatively, October 2015), the new release is just about here. Last month, we talked about the biggest enhancement that it bringsnamely, honking big improvements in speedbut there are a ton of other things in there as well, so let's buckle down and take a look at some of them.

Add a comment

Last Updated on Wednesday, 08 July 2015 09:56
Read more...
 
TechTip: Store and Parse JSON Data Natively with DB2 for i PDF Print E-mail
Tips & Techniques - Database
Written by Michael Sansoterra   
Friday, 26 June 2015 00:00

Learn how the latest DB2 for i features can reduce development time when interacting with the popular JSON data format.

Written by Michael Sansoterra

In my prior tip about using JSON with DB2 for i, I articulated a method of accessing JSON with SQL by use of Java external user-defined functions (UDFs) that convert JSON to XML and XML to JSON. Starting in IBM i 7.1 TR10 (Database Group PTF Level 34) and IBM i 7.2 TR2 (Database Group PTF Level 5), IBM has added native JSON support to the DB2 for i database engine. Keep in mind that, at this first release, the JSON support is still considered a "technology preview," so be sure to test any JSON implementations carefully before using them in production. Also, based on available documentation, some of these features and JSON functions are not yet advertised by IBM for the IBM i and may be subject to change.

Add a comment
Last Updated on Friday, 26 June 2015 00:00
Read more...
 
User Rating: / 2
PoorBest 
TechTip: Wizard Analytics on DB2 Web Query, Part 1 PDF Print E-mail
Tips & Techniques - Database
Written by Kathryn Steinbrink   
Friday, 26 June 2015 00:00

Business analysts, developers, administrators, and even non-technical individuals can get started generating sophisticated reports and visualizationsover their own datain minutes!

kathy steinbrinkWritten by Kathy Steinbrink

IBM DB2 Web Query for i is an analytics tool for modernizing Query/400 reports and delivering analytics to the web or mobile devices. It's a web-based Business Intelligence (BI) solution for visualizing, analyzing, and sharing critical business data. Available since 2007 on the IBM i platform, DB2 Web Query has delivered through the years a steady heartbeat of new function.

Add a comment
Last Updated on Friday, 26 June 2015 00:00
Read more...
 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 1 of 189

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