RPG & DB2 Summit: March 21-23, 2017, in Orlando

In just two weeks I’ll have the pleasure of joining some of the top IBM i development experts in Orlando for the RPG & DB2 Summit. Run by Susan Gantner, Jon Paris and Paul Tuohy, this conference is full of big personalities who create a warm, friendly environment that’s perfect for learning.

I enjoy the community feeling and how excited everyone is to solve development problems and share tips and techniques.

The RPG & DB2 Summit is one of the few training events that focuses exclusively on topics of interest to IBM i developers. That includes PHP and SQL, of course!

Check out the session grid and pay special attention to the Hands-on PHP Workshop on Monday, March 20, followed by several PHP and open source sessions given by yours truly and Zend’s Mike Pavlak, plus a whole array of SQL sessions. And maybe a few on RPG.

I think they should change the name of the conference to the RPG, PHP, SQL & DB2 Summit, don’t you?

Come join us!

WMCPA 2017: A Glimpse into the Future of IBM i

Every year I look forward to WMPCA’s Spring Technical Conference. And it’s not just because this active IBM i user group does a great job of bringing experts to beautiful Wisconsin (in March!) to teach a broad range of IBM i topics.

I also love meeting the next generation of IBM i talent, always represented by Jim Buck’s RPG students at Gateway Technical College.

And, of course, there are many PHP and open source sessions to choose from, including these from me:

  • Make Your IBM i Sizzle with WordPress
  • Apache Web Server Magic on IBM i
  • Using DB2 and SQL with Open Source Languages on IBM i
  • PHP Tricks for the RPG Programmer: Graphics, Excel, PDFs, E-Mail and More

Also check out these sessions from our good friend Mike Pavlak:

  • PHP Web Security in an Insecure World
  • Web Services with PHP on IBM i

I could go on and on with recommendations, but I’m sure you’ll find plenty to love on your own.

Join us at the WMCPA Spring Technical Conference on March 14-16, 2017, at the Lake Lawn Resort on the shores of Delavan Lake!

 

WMCPA IBM i conference: March 15-17, 2016

Join me and 27 other speakers at the Wisconsin Midrange Computer Professional Association (WMCPA) spring technical conference, March 15-17, 2016, at the Lake Lawn Resort on the shores of Delavan Lake.

Featured speakers: Alison Butterill, Tim Rowe. Speakers: Robert Andrews, Jim Bainbridge, Aaron Bartell, Stacy Benfield, Larry Bolhuis, David Brault, Chris Bremer, Jim Buck, Tom Cremieux, Gus Delgado, Richard Dolewski, Von Enselman, Byron Franz, Charles Guarino, Scott Klement, Richard Milone, Floyd Del Muro, Greg Patterson, Mike Pavlak, Trevor Perry, Jim Ritchhart, Richard Schoen, Alan Seiden, Grant Smith, Matt Staddler, Paul Tuohy

Details: https://www.wmcpa.org/index.php/conference2016

Slides from today’s talk on leveraging RPG with the PHP Toolkit and XMLSERVICE

I’ve posted the updated slides from a talk I just presented about the PHP for IBM i Toolkit. The talk was given at a free virtual conference presented by the COMMON user group and was sponsored by BCD.

The slides are available on my “past presentations” page.

I’d like to hear how you are using the toolkit. Post comments here.

Determining the proper procedure name in toolkit calls

Exact name is required when calling a service program’s procedure

Some developers make a common mistake when calling a procedure in a service program using the PHP Toolkit for IBM i or any toolkit based on XMLSERVICE. It’s easy to supply the wrong procedure name, or the right name in the wrong case (upper/lower/mixed). Using this example of calling a procedure using the toolkit, we find the following (correct) program/procedure call:

$result = $conn->PgmCall('MYPGM', 'MYLIB', $params, $retParam, 
                         array('func'=>'myproc'));

The procedure name ‘myproc’ must be given exactly as it is, not ‘MYPROC’ or ‘MyProc’, because under some circumstances the name may be case-sensitive.

How to determine the correct procedure name

Run the DSPSRVPGM command, using your desired library and program names as parameters:

DSPSRVPGM SRVPGM(MYLIB/MYPGM) DETAIL(*PROCEXP)

The above command will return service program information, including the names of all procedure exports. For example:

        Display Service Program Information                       
                                                    
Service program  . . . . . . . . . . . . :   MYPGM                           
  Library  . . . . . . . . . . . . . . . :     MYLIB                          
Owner  . . . . . . . . . . . . . . . . . :   PROGRAMMER                        
Service program attribute  . . . . . . . :   RPGLE                             
Detail . . . . . . . . . . . . . . . . . :   *PROCEXP                          
                                                                               
                              Procedure Exports:                               
                                                                               
Procedure Name                                       ARGOPT 
myproc                                               *NO    
orderHeader                                          *NO

This service program contains two procedures: ‘myproc’ and ‘orderHeader’. Thus, to call the former, we’d supply array(‘func’=>’myproc’) in the PgmCall method. If we wanted to call the second procedure, we’d use array(‘func’=>’orderHeader’), observing case sensitivity, which often matters (a topic for another day).

Vote for a Mac edition of RDi

Rational Developer for i (RDi), the modern editor for IBM i RPG, COBOL and other languages, runs on Windows and Linux, but not Mac.

IBM has shown some willingness to port the product to Mac. They have posted a poll to allow users to vote for this enhancement or to comment on the proposal: https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=13454

Those wishing to vote will find a “vote” link near the bottom of the poll page.

Video promo for WMCPA IBM i conference: March 10-12, 2015

Join me and 20 other speakers at the Wisconsin Midrange Computer Professional Association (WMCPA) spring technical conference, March 10-12, 2015, at the Lake Lawn Resort on the shores of Delavan Lake.

Speakers: Aaron Bartell, Rob Bestgen, Larry Bolhuis, Tom Cremieux, Floyd Del Muro, Raymond Everhart, Margaret Fenlon, Susan Gantner, Charles Guarino, Scott Klement, Chris Koppe, Jon Paris, Mike Pavlak, Jim Ritchhart, Debbie Saugen, Alan Seiden, Dr. Frank Soltis, Robert Swanson, Robin Tatam, Jeff Tickner, Steve Will

Details: http://wmcpa.org/index.php/conference-2015/ibmi-conference-2015