TechTips


TechTip: i Illuminate 7.3—Get a Grip PDF Print E-mail
Tips & Techniques - Database
Written by Scott Forstie   
Friday, 17 June 2016 00:00

Use the Gripping Charm to grasp the possibilities that lie ahead. Read how Scott dodges danger and dementors with DB2 for i spells.

Written by Scott Forstie

Good, you’re back. I was beginning to think that you had encountered some ugly business. After all, there is danger at every turn. For myself, I have been keeping a very public profile since we last spoke to one another. With the rollout of IBM i 7.3, everyone wants to know “What’s New in DB2 for i.” As I do my level best to tell them about the DB2 for i enhancements, I notice that frequently people aren’t fully utilizing the capabilities already at their fingertips. As you’ll read in this episode, an established DB2 for i column-level control will rescue me from an untimely demise.

Add a comment
Last Updated on Friday, 17 June 2016 00:00
Read more...
 
TechTip: Debugging PHP in Studio PDF Print E-mail
Tips & Techniques - Scripting
Written by David Shirey   
Friday, 03 June 2016 00:00

We started through Zend Studio debugging a month or so ago. Now it’s time to pick up that thread and continue.

david shireyWritten by David Shirey

You haven’t worked on this (using Zend Studio to debug your scripts) at all in the last two months, have you?

 

No. Don’t try to explain. I’ve heard it all by now: “I was busy.” “I was tired.” “My dog ate my homework.” Yeah, whatever. Let’s just get going.

Add a comment
Last Updated on Friday, 03 June 2016 00:00
Read more...
 
TechTip: C# for RPGers: More C# and RPG Basic Data Types Compared PDF Print E-mail
Tips & Techniques - Programming
Written by Rafael Victoria-Pereira   
Friday, 03 June 2016 00:00

Let’s continue to explore C#’s data types. This time around, I’ll introduce you to Booleans, strings, and a very important concept—methods.

rafael victoria preiraWritten by Rafael Victória-Pereira

This TechTip will start where the previous one left off, so if you haven’t read it, it would be a good idea to do so now. I’ll start by adding a Boolean variable to the program I’ve created:

Add a comment
Last Updated on Friday, 03 June 2016 00:00
Read more...
 
TechTip: Data Warehouse Updates from IBM i Using SSIS PDF Print E-mail
Tips & Techniques - Database
Written by Thomas Snyder   
Friday, 27 May 2016 00:00

Point-and-click your way to repeatable data updates to or from any database from your DB2 database.

tom snyderWritten by Tom Snyder

One common theme I’ve experienced through several RPG developer jobs is to provide data to an external data warehouse from the all-knowing DB2 database. Other common needs may be to supply member information to a website or to some third-party software. Sometimes these would be DB2 databases, and sometimes they wouldn't. I'm going to show you how to quickly set up a SQL Server Integration Services (SSIS) package to take care of this process for you.

Add a comment
Last Updated on Friday, 27 May 2016 00:00
Read more...
 
User Rating: / 1
PoorBest 
TechTip: DB2 for i Optimization Strategies, Part 3 PDF Print E-mail
Tips & Techniques - Database
Written by Michael Sansoterra   
Friday, 27 May 2016 00:00

Learn ways to keep your database code lean and mean, resulting in better performance.

Written by Michael Sansoterra

This third tip in the series continues where Part 1 and Part 2 left off. Presented herein are some general guidelines for how to make your database code purr like a kitten.

Add a comment
Last Updated on Wednesday, 25 May 2016 11:15
Read more...
 
TechTip: DB2 for i Optimization Strategies, Part 2 PDF Print E-mail
Tips & Techniques - SQL
Written by Michael Sansoterra   
Friday, 20 May 2016 00:00

Avoid common SQL programming mistakes that can change your query speed from a cheetah to a tortoise.

Written by Michael Sansoterra

This tip continues the series started in Part 1 that discusses some common SQL coding styles that can be improved. While some examples may seem trivial, under a heavy load, saving CPU cycles and reducing data and journaling I/O can make a considerable impact on overall system performance.

Add a comment
Last Updated on Friday, 20 May 2016 00:00
Read more...
 
TechTip: Shoot for Orion with Your RPG PDF Print E-mail
Tips & Techniques - RPG
Written by Aaron Bartell   
Friday, 13 May 2016 00:00

We're going to disrupt your comfort zone. RPG in the IFS. Browser-based development environments. T-shirts with tags that line the collar.

aaron bartellWritten by Aaron Bartell

The April announcement of V7.3 by IBM was a great time to receive new goodies for IBM i. You can gain a full perspective at Steve Will's blog. In this article, I will be focusing on the Orion addition, which is option 8 of 5733OPS. I will also dive into a little bit of Git, which IBM is also now delivering with 5733OPS.

 

First things first: What is Orion?

Add a comment
Last Updated on Friday, 13 May 2016 00:00
Read more...
 
User Rating: / 1
PoorBest 
TechTip: Additional PHP Tools—BCD Software PDF Print E-mail
Tips & Techniques - Scripting
Written by David Shirey   
Friday, 06 May 2016 00:00

So far, we’ve talked only about Zend and its family of products. But is that all there is? The answer is “no,” and this month we’ll look at what BCD Software has to offer if you’re dabbling in PHP.

david shireyWritten by Dave Shirey  

I know, I know. Last time we talked I promised to continue on with the debug, but by now you know that my attention wanders. To be perfectly honest, I run Zend Studio on a Mac, and there seem to be one or two issues with the most recent update to Studio for that platform. Shouldn’t take long to resolve, but I need to write an article now, so let’s talk about something else until I get clear.

Add a comment
Last Updated on Tuesday, 17 May 2016 14:41
Read more...
 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 1 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