TechTips


TechTip: More on Studio PHP Scripts PDF Print E-mail
Tips & Techniques - Scripting
Written by David Shirey   
Friday, 01 April 2016 01:00

Last month, we got into Zend Studio and created a script and ran it in Studio. We’re going to review that a bit this month and start talking about debuggers. Come on, it will be fun.

david shireyWritten by David Shirey  

OK, a month has gone by. You have probably forgotten everything we touched on previously, so let’s get started slowly. We will start by introducing a bug into our PHP script.

Add a comment
Last Updated on Friday, 01 April 2016 01:00
Read more...
 
TechTip: DB2 for i Optimization Strategies, Part 1 PDF Print E-mail
Tips & Techniques - Database
Written by Michael Sansoterra   
Friday, 01 April 2016 01:00

Avoid common SQL programming mistakes that can drag application performance.

Written by Mike Sansoterra

As databases grow larger over time, users and administrators often witness a decrease in performance. A query that once performed well when it was first written eventually becomes lethargic. In this series of tips, I will discuss some common goofs that can take the wind out of your database sails.

Add a comment
Last Updated on Friday, 01 April 2016 01:00
Read more...
 
User Rating: / 1
PoorBest 
TechTip: C# for RPGers – Anatomy of a C# Program PDF Print E-mail
Tips & Techniques - Programming
Written by Rafael Victoria-Pereira   
Friday, 25 March 2016 01:00

Now that you know a bit more about Visual Studio and created your first C# program, it's time to see how a C# program compares to an ILE Program.

rafael victoria preiraWritten by Rafael Victória-Pereira

The previous two TechTips of this series (1 and 2) explained the basics of Visual Studio and helped you create a simple "Hello World" program. Before advancing to more complex stuff, I need to explain the way things are organized in a C# program. Just like an ILE program is composed of procedures and functions stored in programs or service programs, a C# program also follows a hierarchical structure.

Add a comment
Last Updated on Friday, 25 March 2016 01:00
Read more...
 
TechTip: IBM's Support Assistant Helps You Diagnose Software Problems PDF Print E-mail
Tips & Techniques - System Administration
Written by John Ghrist   
Friday, 25 March 2016 01:00

If you're running WebSphere, AIX, Linux, or Windows 2008 Server on your IBM i, Support Assistant Team Server can help you troubleshoot Java and other application problems.

john gristWritten by John Ghrist

IBM's Support Assistant Team Server (currently in release 5.0.2.1) is a set of diagnostic tools IBM offers at no charge that helps improve productivity by investigating root causes of software problems. The latest version runs under AIX, Linux, and Windows 2008 Server and can also be installed as an Enterprise Archive (EAR) file on servers running WebSphere.

Add a comment
Last Updated on Thursday, 24 March 2016 11:50
Read more...
 
TechTip: Implementing JSON in DB2 Made Easy PDF Print E-mail
Tips & Techniques - Database
Written by Mohankumar Saraswatipura   
Friday, 18 March 2016 01:00

DB2 JSON is simple to implement and maintain.

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.

 

IBM DB2 10.5 FP1 introduced JSON support. DB2 JSON provides a complete storage/persistence solution for JSON documents. The solution combines application server-side components with JSON enhancements and functions in the DB2 engine.

Add a comment
Last Updated on Friday, 18 March 2016 01:00
Read more...
 
TechTip: Riding the Rails, Part 3 PDF Print E-mail
Tips & Techniques - Scripting
Written by Aaron Bartell   
Friday, 11 March 2016 01:00

Ruby's database access is simple and elegant, something I thought I'd never say about another language after using RPG for over a decade.

aaron bartellWritten by Aaron Bartell

In the January 2016 article "Riding the Rails, Part 1," I introduced you to how a Rails project is created. In the February 2016 article "Riding the Rails, Part 2," we generated a Create, Read, Update, Delete (CRUD) application. In this article, we'll dive further into the database aspect of that CRUD app by describing a technology named "ActiveRecord."

Add a comment
Last Updated on Friday, 11 March 2016 01:00
Read more...
 
SQL 101: String-Related Functions, Part 3 - Pulling Strings Around with REPLACE and INSERT PDF Print E-mail
Tips & Techniques - SQL
Written by Rafael Victoria-Pereira   
Friday, 11 March 2016 01:00

RPG's %XLATE BIF converts characters to uppercase or lowercase. The previous article of this series showed a few SQL functions that provide this type of functionality. But %XLATE can also replace characters in a string; that's what this article is about.

rafael victoria preiraWritten by Rafael Victória-Pereira

Let me start with a very quick recap: the previous article explained a few functions that cover part of %XLATE's functionality. But LOWER and UPPER can't be used to replace characters in a string; I've shown that you can use TRANSLATE to do that. However, depending on the situation, the input-by-output-character-replacement feature of TRANSLATE can be a blessing or a curse. For instance, if you want to replace a single character with an expression, say three characters long, TRANSLATE won't do. But there's another function that can help: REPLACE.

Add a comment
Last Updated on Friday, 11 March 2016 01:00
Read more...
 
TechTip: Running PHP Scripts - Zend Studio PDF Print E-mail
Tips & Techniques - Scripting
Written by David Shirey   
Friday, 04 March 2016 01:00

Last month, we talked about Zend Server. This month, the other brother Darryl, Zend Studio, is on tap. Let's see what's up about that.

david shireyWritten by David Shirey  

I want to continue my ode to Zend products by taking a look at Zend Studio, the IDE that complements but is separate from Zend Server.

 

That is, all MAMP and Zend Server provide is the web server part of the equation. We need that web server, because PHP is a server-side language. It doesn't run on your PC in the browser the way HTML or JavaScript does. It needs an actual web server environment to run in.

Add a comment
Last Updated on Thursday, 03 March 2016 13:24
Read more...
 
User Rating: / 1
PoorBest 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 5 of 198

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