Charles Guarino presents to NHMUG

Charles Guarino - Wednesday January 14th, 2015

Get With The Program! It's Not Your Gramdma's RPG Anymore!

Based on the community’s requirements IBM continues to evolve the language. This recent modernization iteration brings sweeping changes to the design, syntax and overall look and feel. We will examine the actual enhancements to each of the four changed specifications. Finally we will show a side-by-side comparison of programs written in both styles.

From STRDBG to the RDi Debugger

Making the decision to abandon the green screen development environment takes a lot of patience. Once you make the leap though you’ll be very glad you did. This session examines our old comfort-zone friend STRDBG and shows the similarities, differences and productivity improvements in this new world of application debugging.

Learning Objectives:

  • Grow confidence in using the Rational Developer for i debugger
  • How to run, debug and control programs using the debugging environment and perspective.

Audience:

Programmers who have little or no knowledge using the new RDi debugger.

Introduction to Processing XML in RPG and SQL Too!

XML has quickly become a standard method of encoding data. It can be used for full document transmittals or data provided via a web service. The extraction of this data into useable information is called parsing. RPG provides two different methods for parsing. This session goes step by step through the entire process of receiving an XML document to successfully parsing it to a database file. The XML-INTO and XML-SAX statements will be reviewed. The challenges and requirements of both statements will be discussed. At the end of this session, you will be able to identify which parsing method works best for your particular situation. Included with this session are program listings that you can take back and put to use immediately. Updates to this session include i7.1 TR6’s exciting SQL XML processing.

Learning Objectives:

  • Gain a basic understanding of XML syntax
  • Learn how XML parsing has been implemented into RPG
  • See live examples of the XML parsers at work.

The Business, Science and Uses of ILE Service Programs

Service programs have been around for some time. In fact, quite some time. Perhaps you’ve even bumped into one in your professional travels. You will certainly find them on the road to application modernization. This session focuses on what they are, how to implement them and making them a regularly used asset during your application development. Topics include service programs, program signatures and using binder language source.

Biography

With an IT career spanning over 30 years, Charles Guarino has been a consultant for most of them. Since 1995 he has been founder and President of Central Park Data Systems, Inc., a New York area based IBM midrange consulting and corporate training company. In addition to being a professional speaker, he is a frequent contributor of technical and strategic articles and webcasts for the IT community. He is a proud member of COMMON’s Speaker Excellence Hall of Fame and also Long Island Software and Technology Network’s Twenty Top Techies of 2009. Charles currently serves as a member of COMMON’s Strategic Education Team (SET) and is also Immediate Past President and monthly Q&A host of LISUG, a Long Island IBM i User’s Group www.lisug.org

Charles can be reached at This email address is being protected from spambots. You need JavaScript enabled to view it.

LinkedIn - http://www.linkedin.com/in/guarinocharles

Twitter - @charlieguarino


NHMUG presents Pete Massiello

Pete Massiello presents the iTech Soloutions POWER8 & IBM i 7.2 Roadshow on Thursday December 18, 2014

Antique, vintage, second-hand, and used… Those are words that come to my mind when I hear “Roadshow”. The iTech Solutions POWER8™ & IBM i 7.2 Roadshows are none of those things. These Roadshows are about what is new and exciting with the IBM POWER8 servers and the latest level of the OS. If you are still running any of the vintage Power5 or Power6 servers these Roadshow presentations will have everything you need to know about how the new POWER8 servers can vastly improve your operating environment and reduce costs.

Pete Massiello of iTech Solutions will present multiple sessions at this roadshow location. The first session covers the IBM POWER8 servers and how they can significantly improve your organizations processing capabilities. The second session covers the announcement of enhancements that are available in IBM i 7.2. Join us for the iTech Solutions POWER8 and IBM i 7.2 Roadshow where you can learn all about these exciting new announcements that reinforce IBM’s continued commitment to the Power Systems platform and the IBM i operating system.

IBM POWER8tm

This session will review the current IBM POWER8 announcements and how they will improve the processing environment and enhance your investment in the platform. The session will cover the POWER8 processor architecture, new disks and controllers, and the models of the POWER8 scale out servers currently available and what is coming in future announcements. If you are still running any of the vintage Power5 or Power6 servers this presentations will have everything you need to know about the new POWER8 servers and how they can benefit your organization.

IBM i 7.2

This session will review the announcement of availability of IBM i 7.2. That announcement covers enhancements to Security with RCAC(row and column access control), RPG and Applications Development, SQL Performance, Mobile Access, Java, Navigator for i, Websphere, Zend, IBM i Access and BRMS. This session will also cover what previous levels of Power Systems will support this new OS level and which one will not.

Biography

Pete Massiello has been working with the AS/400, iSeries, i5, IBM i since 1989, focusing on system management and technical support. He has held numerous technical positions through out his career. He is the President of iTech Solutions Group, an IBM Premier Business Partner delivering solutions and services to IBM i shops throughout the US. He is a member of IBM's certification test writing team, and IBM Certified Systems Expert with certifications in iSeries Design, Administration, Implementation, LPAR, and HMC management. Pete has a BS in Computer Science from Hofstra University, and an MBA from the University of New Haven. He is current President of COMMON, a COMMON Silver medal winner, and a frequent speaker at user groups all over the world. Pete was one of the initial IBM Champions for Power Systems.


Bryan Meyers presents Embedded SQL topics to NHMUG

Bryan Meyers presented to the NHMUG user group on Thursday November 20, 2014

Introduction to Embedded SQL

In this session we’ll introduce the basic elements behind embedding SQL statements into an RPG IV program. The session will cover the syntax requirements, and discuss when embedded SQL is appropriate. You’ll understand the differences between static and dynamic SQL statements. We’ll cover how to interact between SQL host variables and RPG variables, as well as indicator variables, host structures, and indicator structures. Regardless of what IBM i release you have installed, we’ll talk about the best way to integrated SQL statements with free format RPG code, and how embedded SQL works with RPG subprocedures and local variables.

Using Cursors and Fetch

So you think a serial cursor is someone who habitually uses foul language? And fetch only applies when you’re playing Frisbee with your dog? This session will disabuse you of those notions. We’ll discuss the differences between serial and scrollable cursors, and how to use them to have your RPG program read and update database records. There will be coding examples of fetching and inserting multiple records using SQL.

Handling Errors, Dynamic SQL

We know your code would never cause an error, but just in case something slipped past the programmer who wrote the code, it’s good to know how to catch any problems that might crop up while the program is running. This session will cover return codes, communications areas, and provide some simple error handling code that you can include in all your programs. This session will also cover in detail the differences between static SQL and dynamic SQL, and point out the advantages and restrictions of each.

SQL Tips and Tricks

The session title says it all: coding tips, style guidelines, procedures, ILE issues, tricks to make SQL and RPG play better together – this session will wrap up a number of miscellaneous useful topics that will help you get started with embedded SQL, or improve your existing code. Bring your own tips, as well, to share with the group.

Biography

Bryan Meyers is well known to IBM i technicians as the author of a number of popular books and frequent magazine articles. His programming, management and consulting career has spanned most of the IBM midrange history, from the System/360 through the AS/400, iSeries, and IBM i. For much of that time, Bryan was the IT director for an international hospitality franchisor. He has also managed computer operations for municipal government, international construction, and broadcasting media industries. Currently, Bryan offers on-site corporate training classes in IBM i technical topics, as well as online programs. Bryan’s most popular books include RPG IV Jump Start, Programming in RPG IV, and Control Language Programming for IBM i, all recognized as benchmark references in the IBM i community.

Phone +1 (406) 860-4944

Email This email address is being protected from spambots. You need JavaScript enabled to view it.

Web www.bmeyers.net


Craig Pelkie presents .net, mobile, and more

Craig Pelkie at NHMUG user group on Thursday March 20, 2014

Getting started with .NET for IBM i developers

Even though you use the IBM i as your server platform, your shop may be using or considering application development with Microsoft .NET. Before getting started with .NET development, it is helpful to understand some of the basics of .NET, including the .NET Framework, the programming languages that are most widely used (Visual Basic and C#), the Visual Studio development environment, the ASP.NET deployment environment, and perhaps most importantly, how you can connect to your IBM i from .NET

In this session, we will look at the major features of the .NET environment and how it fits in with the IBM i.

Microsoft SQL Server for IBM i Developers

Microsoft SQL Server is a widely used database server that is found in many IBM i shops. Using database drivers provided by IBM, you can connect SQL Server to your IBM i, enabling you to move data between the two systems.

In this session, you'll learn the basics of SQL Server, how the IBM database providers can be used with SQL Server, and how to create and work with a Linked Server. You'll see how you can run SQL statements in SQL Server that access IBM i data for read, insert, update and delete operations. You will learn about SQL Server data transfer packages, and the tools that are available to create and run packages. You'll also learn about other features of SQL Server, including SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS).

Included with the session is a PDF lab handout that shows the steps used to create a Linked Server and run SQL commands using it.

Simple mobile programming for RPG using jQuery Mobile

Many IBM i developers create web applications with RPG or PHP, extending the reach of their company and helping users to be more productive. So if you know how to create IBM i web applications, going mobile should be simple, right? After all, all of the popular mobile devices have web browsers, so you simply bring up the pages. Right?

Unfortunately, a web page or form that looks great in a desktop browser is probably unusable on a mobile device. The phrase "fat finger" really means something when you work with data in a mobile browser.

To create a good looking, usable web form for mobile means that you need to have in-depth knowledge of HTML, JavaScript and CSS. You also need to account for different screen sizes, orientations, browsers and how users interact with mobile web applications. Fortunately, there is a readily available solution that takes into account the limitations and opportunities of mobile devices. The no-charge jQuery Mobile Framework uses an easy to understand syntax, all done using HTML. It takes care of all of the required JavaScript and CSS for you. A web application developed with jQuery Mobile is visually stunning and is readily accepted by users, since it fits in with their expectations of how a mobile web application should work. Best of all, you can easily incorporate jQuery Mobile with IBM i RPG and PHP web programs.

In this session, you will learn how you can use the freely available jQuery Mobile Framework to create easy to use mobile web applications. You'll see "before" and "after" images of web forms that have been enhanced with jQuery Mobile, and you'll see exactly what the code looks like. Once you see that you can leave out most of the hard parts of mobile web development by using jQuery Mobile, you'll be confident that you can deliver mobile applications that your users will really appreciate.

Just Enough Java: What you need to know to run Java applications on the IBM i

As a developer for the IBM i, you may need to provide applications or features that require more than RPG or COBOL. There are many Java solutions that are available and can be used on the IBM i. Your challenge, as an IBM i developer, is to get the Java code working with your RPG or COBOL applications.

In this session, you will learn the basics of getting Java applications installed and running on the IBM i. You'll learn how Java code is packaged in class or JAR files, how those files are installed in the IBM i IFS, how the CLASSPATH is used to provide access to Java code, and how to run Java applications.

You don't need to know the Java language or object-oriented programming to benefit from this session. If you just want to get a Java application installed and running on your IBM i, you need Just Enough Java to get it working!

Biography

Craig has been programming IBM midrange systems for many years, having started as a weekend computer operator on a System/360 model 20. His articles have appeared in Midrange Computing, NEWS/400 and other industry publications. He currently develops and conducts eLearning courses for iProDeveloper, in addition to providing consulting services for IBM i, .NET and Java.

You can contact him at This email address is being protected from spambots. You need JavaScript enabled to view it..