TechTips


TechTip: Drivers, Start Your Nginx! PDF Print E-mail
Tips & Techniques - Linux / Open Source
Written by Aaron Bartell   
Friday, 20 November 2015 01:00

Nginx (pronounced Engine-X) is a very popular web server, second only to Apache in the open-source world. Did you know it runs on IBM i?

aaron bartellWritten by Aaron Bartell

"Put on your big-boy pants!" is what they told me. "Dig deeper and figure stuff out for yourself!" they said. Based on the feedback I was getting from online forums, I realized I needed to step up my game in my first open-source ventures. Those were some tough days for my RPG programmer brain, but I stuck with it. Now I see the advantages of going through many mud puddles.

Add a comment

Last Updated on Friday, 20 November 2015 09:56
Read more...
 
TechTip: A Word About Multiple-Event Triggers PDF Print E-mail
Tips & Techniques - Database
Written by Mohankumar Saraswatipura   
Friday, 13 November 2015 01:00

Among the uses are generating events and inserting records in tables.

mohan saraswatipuraWritten by Mohankumar Saraswatipura

Editor's note: This article is an excerpt from the book DB2 10.1/10.5 for Linux, UNIX, and Windows Database Administration (Exams 611 and 311): Certification Study Guide.

 

In DB2 10.1, you can create a multiple-event trigger to fire off a trigger action based on one of three possible triggering events—an INSERT, an UPDATE, or a DELETE statement—instead of creating a separate trigger for each event.

 

Multiple-event triggers are supported for both row-level triggers (FOR EACH ROW) and statement-level triggers (FOR EACH STATEMENT), which allows you to transform a complex business rule into sophisticated trigger logic. It also helps you greatly during the database migration process to migrate other database vendor products to DB2.

Add a comment
Last Updated on Friday, 13 November 2015 01:00
Read more...
 
SQL 101: Aggregate Functions: Discovering SQL's Hidden Gems PDF Print E-mail
Tips & Techniques - SQL
Written by Rafael Victoria-Pereira   
Friday, 13 November 2015 01:00

SQL's ability to make sense of large sets of data by using simple functions that allow you to aggregate data is a major tool that every programmer should master. Learn how to make the most of SQL's aggregate functions.

rafael victoria preiraWritten by Rafael Victória-Pereira

How do you calculate a total amount based on detail records in RPG? You probably read each record, add the respective amount to a work variable, and move on to the next record, until the file (or subset of records) ends. Well, in SQL you can do the same with a single instruction. Let's explore the awesome power and flexibility of SQL's aggregate functions, making use of what I explained before about the Select SQL instruction. In that article, I introduced an Inventory Master Table, which I have been using in most examples. This table's name is InvMst, and its description is presented in the table below:

Add a comment
Last Updated on Friday, 13 November 2015 01:00
Read more...
 
TechTip: PHP Classes: The Final Chapter PDF Print E-mail
Tips & Techniques - Scripting
Written by David Shirey   
Friday, 06 November 2015 01:00

No more Mr. Nice Guy. We're going to finish talking about setting up classes, and we're going to use full OO type notation. Don't worry, it ain't that hard. But it looks way weird, so don't freak.

david shireyWritten by Dave Shirey

Last month, we went thru a PHP script that allowed us to instantiate an object in a class. But we did a very simple example, one that was not completely OO. Still, it let you see a couple of important things.

 

But now we want to move forward and take that simple definition and make it just a hair more complex, and by extension, more OO pure and powerful. Well, powerful is a relative term. It can't be used as a weapon or anything like that.

Add a comment
Last Updated on Friday, 06 November 2015 01:00
Read more...
 
User Rating: / 2
PoorBest 
TechTip: Which Server Job Is Mine? PDF Print E-mail
Tips & Techniques - System Administration
Written by Sam Lennon   
Friday, 06 November 2015 01:00

A client application sometimes "freezes" or begins responding very slowly. You may need to look at the IBM i side of the application. But can you can find it? This tip helps you track down the IBM i server job.

sam lennonWritten by Sam Lennon

For the purposes of this discussion, a client application is a "program" that isn't running on the IBM i host, but is connecting to it using JDBC, or ODBC, or JT/400, or FTP, or TCP/IP, or some other communications technique. A client application might be the Rational Developer for i (RDi) IDE. It might be one of the free SQL clients like SQuirreL or SQL Workbench/J. It might be an FTP client. It might be a .NET application. Or something else entirely.

Add a comment
Last Updated on Friday, 06 November 2015 01:00
Read more...
 
TechTip: Embrace Auto-Updating IBM i Performance Stats in Real Time PDF Print E-mail
Tips & Techniques - Scripting
Written by Aaron Bartell   
Friday, 30 October 2015 01:00

Deliver real-time WRKACTJOB stats to the browser using Node.js, DB2 for i Services, and WebSockets.

aaron bartellWritten by Aaron Bartell

I am continually intrigued by the capabilities HTML5's WebSockets afford us on IBM i. In the article Node.js Is Genius with Web Sockets, I walked through the creation of a simple chat application that used WebSockets to communicate messages from the server to each browser currently participating in the chat. That was fun but not as immediately relevant to IBM i as it could have been. In this article, we will implement WebSockets into the IBM i Dash open-source project by adding an auto-updating page that conveys information equivalent to the WRKACTJOB command.

Add a comment
Last Updated on Friday, 30 October 2015 01:00
Read more...
 
Partner TechTip: VIOS Is Set and Forget. Isn't It? PDF Print E-mail
Tips & Techniques - System Administration
Written by Ashley Giddings   
Friday, 16 October 2015 01:00

It's good practice to build redundancy into your VIOS configuration so that client LPARs can use multiple VIOS, but how would you know if one—or both—had failed?

ashley giddingsWritten by Ash Giddings

There's a popular misconception in the industry that Virtual I/O Server (VIOS) is just a slimmed down version of AIX. If you come from an AIX background, you will find the command line interface (CLI) to be much more familiar than an IBM i administrator would, for example, but the similarities stop there.

Add a comment
Last Updated on Friday, 16 October 2015 01:00
Read more...
 
TechTip: SQLing to the Cloud in Seven Steps PDF Print E-mail
Tips & Techniques - SQL
Written by Steven Goetjen   
Friday, 09 October 2015 01:00

There are many different methods of identifying changes to a database using SQL. Here's one.

steven goetjenWritten by Steven Goetjen

With the advent of "cloud" computing or Software as a Service (SaaS), many companies will find new and exciting requirements to push data out into the world. With this challenge comes the need to make sure that the data residing on the cloud application is synchronized with the data residing on the source home application. Since the cloud application is not directly connected to the source system, there's no ability to directly reconcile the data.

Add a comment

Last Updated on Monday, 12 October 2015 11:28
Read more...
 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 5 of 196

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