This training manual starts you off by explaining how to download, install and configure the CGIDEV2 toolkit on your AS/400. It then takes you through each of the subprocedures included in the toolkit. 
Each section clearly explains how and when to use each subprocedure as well as any input and output parameters that are required. Understanding what you are doing is just as important as actually doing it. And these chapters will really open your eyes to the fantastic power and functionality of the CGIDEV2 toolkit 
The chapters that follow show you how to use each of the subprocedures in a real programming environment. Even if you're a beginner, the first example will get you started quickly and easily with the "Hello World" application. The training manual goes on to explain and give examples of outputting dynamic content using CGIDEV2's trademark, the HTML template. 
Media: Self-paced manual with source code CD. Estimated completion time: 16 hours.

Stone on CGIDEV2

Computers & Technology

Stone, Bradley V.

Operating Systems

Rochester Initiative

With TurboQuery/400 you will supercharge your queries, saving time and processor resources. Upon completion you will: Automate, document, and organize your queries. Reduce the impact on your system resources from Query/400 queries. Run a group of queries with one command and no modification to any of the queries even if they check for date ranges! Open query reports directly in MS Excel. Stop re-keying into Excel from paper printouts. Put all the information you want on a report. Go way past the 132 columns. Schedule running of one or a series of queries at your choice of date and time. Receive an email notification when queries are complete! Don't have time to take the training? Simply Load, Compile and Go using the easy-to-follow instructions! Bonus Utility Included! The included DataFinder utility allows you to search file and field text descriptions using the key words you specify. You’ll quickly find precisely the data you need to query. For Example, your boss wants a report on rebate totals in one hour, but you didn’t even know rebates existed! No problem. Just call up the DataFinder and type "rebate" into the field text search. DataFinder will quickly display all the fields containing the word "rebate." Next, you’ll verify that the files have current data by reviewing when they were last used. Then, write your query, keep the boss happy, and quickly return to your other critical projects. It Works! You can now run a group of queries with one program selection and only enter the date range once for all the queries in that group. You can still see which date range was last used, the last time the group of queries ran, who ran the group, and when it ran. This will increase the accuracy of your querying and reduce the impact on your system resources by submitting all the queries, rather than running them interactively. You can even receive an e-mail when a query completes.You get all this plus the bonus DataFinder utility with source code! The big illustrated manual comes with easy to follow instructions, complete with screen shots and source code. You also get 12 Labs with all the RPG, DDS and CL source code included on a CD. This practical training, developed in a real working environment, is guaranteed to save you time and make your job easier.

Turbo Query/400: Automating & Enhancing Turbo Query/400

G. Wayne Hawks

Software

JDBC and Record Level Access with IBM AS/400 Toolbox for Java This fast-paced 20-hour training course, by Joe Pluta, takes you step-by-step through many labs which allow you to compare and contrast both JDBC and RLA. Using short, easy to understand labs, you'll create Java classes to read files sequentially and by key. You'll learn how to create complete CRUD classes (Create, Read, Update, Delete) using both RLA and JDBC. 
Note: This course uses VisualAge for Java version 3.5 or 4.0, provided with the IBM WebSphere Development Tools for iSeries. 
The course is an ideal follow-on to Practical Java Programming for WebSphere (see below). Some experience with Java is assumed. When should you use JDBC? When should you use RLA? With this training you'll always make the right choice to maximize Java Database performance and make your job easier. Media: Self-paced manual with source code CD. Estimated completion time: 20 hours.

JDBC and Record Level Access with IBM AS/400 Toolbox for Java

Pluta, Joe

iSeries Navigator is now one of the most powerful tools available to iSeries Programmers. With a mastery of iSeries Navigator, you can shorten your learning curve for acquiring new skills, like working with the Integrated File System and SQL. iSeries Navigator for Programmers was developed by Paul Touhy, specifically for iSeries programmers. The training is self-paced and comes with a CD containing all code used. This training is also a useful desktop reference you'll turn to time and again. Most importantly, you’ll learn to do things you simply can’t do on Green Screens. HERE IS WHAT YOU WILL LEARN: ·How to get a graphical view of your database with Database Navigator ·How to manage Triggers ·How to manage and work with SQL constraints ·How to perform the GUI equivalent of WRKSPLF, DSPMSG, WRKUSRJOB, etc. When to use the GUI interface and when green screen is still best ·How to access the IFS from Windows ·How to manage the IFS with iSeries Navigator ·How to get the equivalent of Network Neighborhood on green screen ·How to use iSeries Navigator to manage the database without becoming an expert in SQL ·When to use SQL and when to use DDS ·How to use GUI interfaces to create tables, indexes, and views ·How to create User Defined Functions, the most powerful features available through the databaseEasy ways to get started with SQL

iSeries Navigator for Programmers

Tuohy, Paul

Quickly and easily modernize iSeries reporting with Microsoft Excel with the iSeries. 
This is practical training developed in a real working environment and used on a daily basis. Learn to get any file into an Excel spreadsheet, to use Query/400 to "filter" what records to put into Excel, to use the AS/400 IFS to copy information into Excel, to call programs on the iSeries on your PC using RMTCMD, and to click a button in Excel and open other PC programs, other spreadsheets, even web-sites. 
This course comes with an illustrated manual and a CD containing all the exercise source code, a complete Excel workbook with buttons to run queries and a sample user request workbook for creating clearly defined user requests that will make your job easier. 
Media: Self-paced manual with source code CD. Estimated completion time: 12 hours.

Microsoft Excel with the iSeries

Talk about smiling managers and happy users! Now you can create better looking, easier to read and understand RPG report printouts with graphics, fonts, underlines, and bolding using Microsoft Word with the iSeries! Create Microsoft Word templates that contain graphics, fonts, bold text, and underlined text that can be saved to the Integrated File System (IFS) on your iSeries and copied directly into OS/400 Database files. Create and use RPG programs to modify the contents of those physical files, merge information from other files into the appropriate documents (based on your organization's rules), and then store them in appropriate folders on your IFS. Create better looking, easier to read and understand RPG report printouts with fonts, underlines, bolding, and graphics and a lot more. Media: Self-paced manual with source code CD. Estimated completion time: 4 hours.

Microsoft Word with the iSeries

Brad Stone's RPG Skills Accelerator covers 11 advanced RPG programming subjects, each with one or more labs. This dynamic, hands-on 25-hour training course comes with an easy-to-follow manual, and a CD with all the training exercise source code. You'll learn new RPG skills at your own pace by writing and testing code. You'll immediately use what you've learned to create better RPG programs. Learn how to create and work with sub-procedures, modules, service programs, binder language and binding directories. Subjects covered include: The SQL Alternative – With these labs, you'll learn how to use embedded SQL using static and dynamic statements. With triggers you can split commonly used database operations out of your application programs. RPG Techniques - Fast-paced labs will show you how to work with recursion, data queues, user spaces, sockets, and send email from RPG programs. Techniques include: Sending Email with RPG Programs, Introduction to Recursion, Data Queues and RPG, Working with User Spaces, RPG and Sockets. System Programming with RPG – Topics include: Batch File Transfer with FTP, an RPG Exit Program for FTP, the IFS and RPG. Take your RPG programming skills to the next level with Brad Stone's RPG Skills Accelerator. Media: Self-paced manual with source code CD. Estimated completion time: 25 hours.

RPG Skills Accelerator

Networking & Cloud Computing

Your RPG code can now be simpler to write, easier to maintain, readily reused in new applications, and truly modular with RPG Subprocedures Workshop. Our new training makes using powerful ILE RPG subprocedures easy. Nothing trendy, just solid RPG training you'll use everyday! RPG Subprocedures Workshop gives you hands-on labs that show you how to write practical ILE RPG subprocedures that you'll use every day. The course includes a CD with all of the source code for all of the programs, modules and service programs you'll create. There is also source code for CL programs, commands, and other objects used. The course manual includes step-by-step instructions, illustrations and easy-to-understand explanations of important techniques you'll use over and over as you create your own subprocedures. Media: Self-paced manual with source code CD. Estimated completion time: 20 hours.

RPG Subprocedures Workshop

Pelkie, Craig

This new dynamic self-paced training from Brad Stone allows you to leverage your existing RPG skills to bring your iSeries applications to the web.      By using the core RPG skill you already have, you will avoid resource intensive solutions with a long learning curve.      RPG Web Skills Accelerator features 8 hands-on labs and comes complete with an exercise source code CD.  You get step by step instructions that will show you how to easily get iSeries applications on the web.      Here's what you will learn to do:  Experience the speed and low-resource processing that native RPG has to offer when creating web applications, learn how to use the FREE APIs that are available to you right now on your iSeries for creating dynamic web applications, learn the basics of HTML including tables, forms, images and hyperlinks, hain important knowledge and experience with web technologies such as JavaScript, Cookies, Stylesheets and Server Side Includes, learn how to create, start, stop and configure web servers on your iSeries using either the IBM web interface or the green screen, easily walk through configuring either the Classic or Powered By Apache web server for serving static and dynamic content from your iSeries, learn what goes on behind the scenes with CGI programs and how they interact with your web server, eliminate the need for bulky and resource intensive products such as WebSphere and use native and FREE APIs already on your iSeries, eliminate the need for intensive and time-consuming training for other web application programming languages, and impress your manager, co-workers and customers by creating web applications leveraging your existing RPG skills!      Media:  Self-paced manual with source code CD.  Estimated completion time:  20 hours.

RPG Web Skills Accelerator

WebFacing Now! takes you step-by-step through the installation and configuration process. It covers converting DDS screens into WebFacing code in the WebSphere Test Environment or Tomcat Test Environment on your PC. You'll then see how to configure, start and test on your iSeries and bring up your new web apps served from your iSeries in your PC browser. Upon completion you'll be able to: Work with WDSCi on your PC to create WebFacing applications, (WAS-Express Edition): Configure and work with WebSphere Application Server-Express on your iSeries, Create WebFacing applications using your programs and DDS display files, Work with WDSCi and the IFS to export your WebFacing applications from the PC to your iSeries. Run your programs as WebFacing applications in your PC browser. What you need on your iSeries: OS/400 V5R1M0 or OS/400 V5R2M0 and WebSphere Application Server-Express version 5.0 or 5.1 (Licensed Program Product 5722-IWE v5.0 or 5722-E51 v5.1). Media: Self-paced manual with source code CD. Estimated completion time: 8 hours.

Web Facing Now! WAS-Express Edition

Web Development & Design

See the best price to sell, buy or rent books by the Rochester Initiative publisher. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Rochester Initiative