Programming


The CL Corner: Enhancing WRKQRY Reports the Easy Way PDF Print E-mail
Programming - CL
Written by Bruce Vining   
Friday, 30 January 2015 00:00

Let's look more uses of the RUNSQL CL command.

bruce viningWritten by Bruce Vining

I recently received a note asking if there was a way to add the day of week to query reports generated by the IBM Query for i (5770-QU1) product. That is, take a current report containing dates as shown below:

Add a comment
Last Updated on Friday, 30 January 2015 00:00
Read more...
 
What Happened to the "RPG Academy" Column? PDF Print E-mail
Programming - RPG
Written by Victoria Mack   
Friday, 23 January 2015 00:00

It's missing! Find out where it went.

 

Have you been feeling lost without the very-popular "RPG Academy" column that used to be here in MC TNT Tips 'n Techniques? Don't worry! It's not gone. It just changed locations.

Add a comment
Last Updated on Friday, 23 January 2015 10:44
Read more...
 
User Rating: / 2
PoorBest 
Debunking Those Change-Control Myths PDF Print E-mail
Programming - Change Management
Written by David Shirey   
Wednesday, 21 January 2015 00:00

Every IT shop has some sort of change-management system. And it's often more a burden than a help. Why? Because of a number of change management myths that we hold near and dear.

david shireyWritten by David Shirey

The single most unheeded dictum, which seems to come from every successful entrepreneur-turned-billionaire, is to not be afraid of making mistakes. In fact, many people proudly declare that mistakes are the only way you make progress, and they attribute much of their success to their ability to make mistakes. Interestingly enough, this never seems to have worked out for me, but they're the rich ones, so they must know.

Add a comment
Last Updated on Wednesday, 21 January 2015 00:00
Read more...
 
User Rating: / 2
PoorBest 
The API Corner: More on Counting Active Jobs PDF Print E-mail
Programming - APIs
Written by Bruce Vining   
Wednesday, 21 January 2015 00:00

Let's continue our discussion about using the List Job API.

bruce viningWritten by Bruce Vining

Last month, in the API Corner article "Counting Active Jobs by Subsystem and/or User," we saw how to use the List Job (QUSLJOB) API in order to count the number of active jobs on the system by various combinations of subsystem and initial user. We also saw that there were (at least) three areas of improvement that could be made to the program:

Add a comment
Last Updated on Wednesday, 21 January 2015 00:00
Read more...
 
RPG Academy: BIF Up Your Code! Get Rid of Those File-Related Indicators PDF Print E-mail
Programming - RPG
Written by Rafael Victoria-Pereira   
Wednesday, 07 January 2015 00:00

Throughout this series, I've mentioned BIFs several times. It's time to explain a few of them in detail, starting with a couple of almost-magical BIFs that rid your code of those pesky file-related indicators. Interested? Keep reading.

rafael victoria preiraWritten by Rafael Victória-Pereira

We all use a built-in function (BIF) or two in our code, even if we don't quite understand how they work. Here and in upcoming TechTips, I'll discuss an assortment of BIFs that will, hopefully, help you to BIF upsorry, I mean beef upyour code: you'll improve readability, avoid "reinventing the wheel" by writing code that emulates the functionality of a BIF, and make yourself (and your code) more efficient.

Add a comment
Last Updated on Wednesday, 07 January 2015 00:00
Read more...
 
User Rating: / 2
PoorBest 
Practical SQL: DB2 at Home, Part 1, the Environment PDF Print E-mail
Programming - SQL
Written by Joe Pluta   
Wednesday, 07 January 2015 00:00

DB2 is IBM's universal database, and that means you can learn about it at home without an IBM i!

joe plutaWritten by Joe Pluta

One of the great features of the IBM midrange platform is its integrated database. For the longest time, we midrange programmers didn't even have a name for the database; we just knew how to access it with RPG and later with SQL. But as IBM targeted other platforms, they put everything under the umbrella name of DB2, the name of the mainframe DBMS. Today you can get DB2 on your home computer so that you can test the latest and greatest features at your leisure. It does, however, take some thought as to how you want to set it up, and this article gives you some input into that decision-making process.

Add a comment

Last Updated on Tuesday, 20 January 2015 16:04
Read more...
 
User Rating: / 1
PoorBest 
In Praise of the Many PDF Print E-mail
Programming - General
Written by David Shirey   
Wednesday, 17 December 2014 00:00

Your true worth to your company and your true level of professionalism has nothing to do with what may seem so important today.

david shireyWritten by David Shirey

Sometimes it's easy to lose your perspective. Sometimes feeling good about your job isn't easy. Particularly in a world that likes to celebrate those who are on the bleeding edge.

Add a comment
Last Updated on Friday, 12 December 2014 12:53
Read more...
 
The API Corner: Counting Active Jobs by Subsystem and/or User PDF Print E-mail
Programming - APIs
Written by Bruce Vining   
Wednesday, 17 December 2014 00:00

You can do it by using the List Job API.
bruce viningWritten by Bruce Vining

I recently received a note from Brian M. that included this:

 

"…can a program be written to determine the number of active jobs attached to a specified subsystem?...I have been asked to figure out the number of active jobs under a specified subsystem like QINTER or QSERVER and be able to either say ALL users or a specified user like XYZ.… I know the command WRKSBSJOB can let me specify a subsystem and a user but it will not give a total so I have to manually count them…"

Add a comment
Last Updated on Tuesday, 16 December 2014 15:53
Read more...
 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 1 of 214

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