TechTips


TechTip: IBM i Access Client Solutions Update PDF Print E-mail
Tips & Techniques - System Administration
Written by Steve Pitcher   
Friday, 22 July 2016 00:00

Integrated File System support leads the way with this important new update.

steve pitcherWritten by Steve Pitcher

As of today, there’s a new version of the highly popular IBM i Access Client Solutions (ACS) product. If you’ve already downloaded the April version of ACS, you can easily upgrade using the new Check for Updates feature underneath the Help option in the title bar. Otherwise, click here and download the latest version. If you want all the ODBC features, those are included in two separate Application Package downloads (one for Windows, one for Linux) found on the IBM ESS website.

Add a comment
Last Updated on Monday, 25 July 2016 10:08
Read more...
 
TechTip: How to Prepare for the DB2 10.5 DBA for LUW Upgrade from DB2 10.1 Certification Exam PDF Print E-mail
Tips & Techniques - Database
Written by Roger Sanders   
Friday, 22 July 2016 00:00

One of the best ways to prepare for any DB2 certification exam is by answering practice questions that are similar to, and that are presented in the same format as, the questions you are likely to encounter when you take the actual exam.

roger sandersWritten by Roger E. Sanders

Editor’s note: This article is adapted from DB2 10.5 DBA for LUW Upgrade from DB2 10.1: Certification Study Notes (Exam 311) by Roger E. Sanders.

 

 A few months after the “IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1” certification exam (Exam 311) was announced, I spent several weeks developing training material that I could use to help individuals prepare for the 311 certification exam. I used the same technique to develop material for that course that I have used to develop my other DB2 certification exam preparation courses and study guides: I carefully reviewed notes I had taken during the exam development process, as well as the questions I wrote for that particular test, and I made sure I covered, in detail, all the objectives that had been defined for that certification exam.

Add a comment
Last Updated on Thursday, 21 July 2016 12:59
Read more...
 
TechTip: DB2 for i Optimization Strategies, Part 4 PDF Print E-mail
Tips & Techniques - Database
Written by Michael Sansoterra   
Friday, 15 July 2016 00:00

Continue to explore the many ways to improve application queries to reduce the amount of work DB2 for i has to do to process them.

Written by Michael Sansoterra

In the prior tips of this series (1, 2, and 3), there were some general SQL coding guidelines given to avoid giving DB2 for i unnecessary work while doing its job to complete a process or query. This tip continues with more advice from real-world coding encounters.

Add a comment
Last Updated on Thursday, 14 July 2016 19:46
Read more...
 
TechTip: Open Source, Dipping Toes PDF Print E-mail
Tips & Techniques - Programming
Written by Aaron Bartell   
Friday, 08 July 2016 00:00

If you're anything like me, you want to participate in the open-source community but don't want to screw things up. I invite you to participate in a safer side of open source.

aaron bartellWritten by Aaron Bartell

I ended my previous open-source article with the following open-ended question:

 

"At the end of the day, open source means community. It means IT professionals coming together and sharing information, ideas, and code. Will you participate?"

 

Sometimes, knowing what to do first is the hardest part of engaging in the open-source community. It's for that reason I am going to use this article to document the entire storyline of me engaging in an open-source scenario.

Add a comment
Last Updated on Thursday, 07 July 2016 13:10
Read more...
 
TechTip: Setting Up PHP Scripts on the IBM i PDF Print E-mail
Tips & Techniques - Scripting
Written by David Shirey   
Friday, 01 July 2016 00:00

So far, we have sort of assumed that our scripts are all kept on your PC, and that was all well and good. But we live in the i world, so it’s reasonable to expect that’s where we’ll keep our scripts.

david shireyWritten by David Shirey  

Up to this point, all of the scripts that we have written and debugged and otherwise fooled around with have been kept on your PC in a folder that your browser could access, and that depended on your operating system.

Add a comment
Last Updated on Friday, 24 June 2016 13:02
Read more...
 
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...
 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 1 of 197

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