Re: AS/400 Programmer's Handbook -- RPG400-L



Hi Folks,   Mark McCall is coming out with a new book with some ILE concepts.  I
am forwarding his email reply to you.

Personally, I can't wait to get his new book!
Darlene
----- Forwarded by Darlene H Bryant/Banpharm on 04/07/2000 07:19 AM -----
|--------+--------------------------->
|        |          "Mark McCall"    |
|        |          <markmccall@sprin|
|        |          tmail.com>       |
|        |                           |
|        |          04/06/2000 07:11 |
|        |          PM               |
|        |                           |
|--------+--------------------------->
  >--------------------------------------------------------|
  |                                                        |
  |       To:     Darlene H Bryant/Banpharm@Banpharm       |
  |       cc:                                              |
  |       Subject:     Re: AS/400 Programmer's Handbook    |
  >--------------------------------------------------------|






Hi Darlene,
I really appreciate your recommendation of my book.  I have not seen a need
to re-write the book yet, since an ILE version is already given for each
example.  The first book does not cover important ILE concepts such as
sub-procedures and service programs.  Rather than drastically changing the
contents of the first book, I decided to write a second book.  My new book
"The AS/400 Programmer's Handbook Volume 2" is being printed now.  The RPG
examples are written completely in ILE.  Here is the table of contents for
the new book:

Part 1 RPG Programming Examples
Chapter 1 Modular Coding Techniques
5 modular coding technique examples, including /Copy compiler directives,
subroutines, dynamic subprograms, subprocedures, and service programs

Chapter 2 Built-In Function Examples
24 examples of RPG's most useful built-in functions

Chapter 3 Exit Program Examples
7 exit program examples, including user profile monitoring, data transfer
security, and job notification

Chapter 4 Application Programming Interface Examples
8 system API examples, including command execution and processing, retrieval
APIs, list APIs, user space APIs, and ILE CEE APIs


Part 2 Database Examples
Chapter 5 Database Constraint Examples
5 database constraint examples, including check constraints, unique and
primary key constraints, and referential integrity constraints

Chapter 6 Database Trigger Program Examples
3 database trigger program examples

Chapter 7 SQL Examples
19 SQL examples, including logical views, selects, joins, summaries, and
embedded SQL

Thanks again Darlene.  It is always a pleasure to hear from you.

Mark

----- Original Message -----
From: <dbryant@banpharm.com>
To: <MARKMCCALL@sprintmail.com>
Cc: <"<rob%dekko.com> wendy_wrp%wrpworld.com%Internet"@banpharm.com>
Sent: Thursday, April 06, 2000 12:51 PM
Subject: Re: AS/400 Programmer's Handbook


>
>
> Hi Mark,
>
> I have recommended your wonder book (The AS/400 Programmer's Handbook) to
> another RPG programmer, and a question has come up about ILE RPG?  Any
comments?
>
> Thanks,
> Darlene Bryant
> Banner Pharmacaps
>
> ----- Forwarded by Darlene H Bryant/Banpharm on 04/06/2000 03:39 PM -----
> |--------+----------------------->
> |        |          Rob Berendt  |
> |        |          <rob@dekko.co|
> |        |          m>           |
> |        |                       |
> |        |          04/06/2000   |
> |        |          01:49 PM     |
> |        |          Please       |
> |        |          respond to   |
> |        |          RPG400-L     |
> |        |                       |
> |--------+----------------------->
>   >--------------------------------------------------------|
>   |                                                        |
>   |       To:     RPG400-L@midrange.com                    |
>   |       cc:     (bcc: Darlene H Bryant/Banpharm)         |
>   |       Subject:     Re: AS/400 Programmer's Handbook    |
>   >--------------------------------------------------------|
>
>
>
>
>
>
> Is this being rewritten for ILE RPG?
>
>
>
>
> eric.lehti@fike.com on 04/06/2000 12:33:50 PM
> Please respond to RPG400-L@midrange.com@Internet
> To:  RPG400-L@midrange.com@Internet, dbryant@banpharm.com@Internet,
> wendy_wrp@wrpworld.com@Internet
> cc:
> Fax to:
> Subject:  AS/400 Programmer's Handbook
>
> I recommend the AS/400 Programmer's Handbook also.
> The author supplies RPG III and RPG IV code examples (listed below) that
you
> can upload to your AS/400.
> Eric Lehti
> ==============  examples noted below =================
> CL EXAMPLE - ERROR HANDLING
> CL EXAMPLE - MESSAGE PROMPTING
> CL EXAMPLE - PHYSICAL FILE I/O
> CL EXAMPLE - STRING MANIPULATION WITH %SST
> CL EXAMPLE - STRING CONCATENATION
> CL EXAMPLE - STRING SCANNING WITH API QCLSCAN
> CL EXAMPLE - OPNQRYF SIMPLE SORT
> CL EXAMPLE - OPNQRYF SIMPLE SELECTION
> CL EXAMPLE - OPNQRYF using Date Built In Functions
> CL EXAMPLE - OPNQRYF using string Built In Functns
> CL EXAMPLE - OPNQRYF using Joins
> CMD to WRKCFGSTS on a device
> CCP - WRKCFGSTS *DEV
> CMD to CHGUSRPRF STATUS(*ENABLED)
> CCP - CHGUSRPRF *ENABLED
> CMD - CRTMLTDUP Command
> PNL - PANEL GROUP HELP TEXT DISPLAY FILE
> PNL - PANEL GROUP HELP TEXT
> PNL - PANEL GROUP EXAMPLE RPG
> PNL - PANEL GROUP HELP TEXT FOR EU COMMAND
> RPG - LOADING A COMPILE-TIME TABLE
> RPG III - LOADING A COMPILE TIME TABLE
> RPG - LOADING A PRE-RUN TIME TABLE
> RPG III - LOADING A PRE-RUN TIME TABLE
> RPG - COMPILE-TIME ARRAY WITH XFOOT TOTALS
> RPG III - COMPILE TIME ARRAY WITH XFOOT TOTALS
> RPG - PRE-RUN TIME ARRAY WITH XFOOT & UPDATE
> RPG III - PRE-RUN TIME ARRAY WITH XFOOT & UPDATE
> RPG - SORTING OVERLAYING RUN-TIME ARRAYS
> RPG - DATA STRUCTURE FIELD PARSING
> RPG III - USING DATA STRUCTURES
> RPG - MULTIPLE OCCURANCE DATA STRUCTURE
> RPG III - MULTIPLE OCCURENCE DATA STRUCTURE
> RPG - ADDING DURATIONS TO DATES
> RPG - SUBTRACTING DURATIONS FROM DATES
> RPG - DETERMINING SPAN BETWEEN TWO DATES
> RPG - EXTRACTING PORTIONS OF DATES
> RPG - TESTING FOR DATE VALIDITY
> RPG - SIMPLE WINDOW DISPLAY
> RPG - SIMPLE WINDOW DISPLAY
> RPG - ENHANCED DISPLAY BOXES & BUTTONS
> RPG - ENHANCED DISPLAY BOXES & BUTTONS
> RPG - ENHANCED DISPLAY MENU BAR
> RPG - ENHANCED DISPLAY MENU BAR
> RPG - MASTER/DETAIL PRINT, RPG CYCLE, INT PRTF
> RPG - MASTER/DETAIL PRINT, NO CYCLE, INT PRTF
> RPG - PASSING PARAMETERS
> RPG - RECEIVING PARAMETERS
> RPG - PASSING PARAMETERS WITH EXTERNAL DEFINITION
> RPG - RECEIVING PARAMETERS WITH EXT DEFINITION
> RPG - UPDATING A NAMED DATA AREA
> RPG - UPDATING THE LOCAL DATA AREA
> RPG - CLEAR AND SEND ENTRY TO DATA QUEUE
> RPG - RECEIVE ENTRY FROM DATA QUEUE
> RPG - Module using Import/Export calls RPG033R
> RPG - Module using Import/Export called by RPG032R
> RPG - SIMPLE PARAMETER PASSING IN RPG/400
> RPG - SIMPLE PARAMETER RECEIVING IN RPG/400
> RPG - PASS PARAMETERS EXT DEFINED IN RPG/400
> RPG - RCV PARAMETERS EXT DEFINED IN RPG/400
> RPG - UPDATE A NAMED DATA AREA IN RPG/400
> RPG - UPDATE THE LOCAL DATA AREA IN RPG/400
> RPG - CLEAR & SEND ENTRY TO DATA QUEUE IN RPG400
> RPG - RECEIVE ENTRY FROM DATA QUEUE IN RPG400
> RPG - MASTER/DETAIL REPORT USING CYCLE NON_ILE
> SIMPLE LOAD ALL SUBFILE DISPLAY FILE
> SIMPLE LOAD ALL SUBFILE
> LOAD FORWARD SUBFILE DISPLAY FILE
> LOAD FORWARD SUBFILE
> SINGLE PAGE SUBFILE DISPLAY FILE
> PAGE-AT-A-TIME SUBFILE EXAMPLE
> LOAD ALL SUBFILE WITH SELECTION DISPLAY FILE
> LOAD ALL SUBFILE WITH SELECTION
> LOAD ALL SUBFILE WITH INPUT/UPDATE DISPLAY FILE
> LOAD ALL SUBFILE WITH INPUT/UPDATE/DELETE
> SIMPLE LOAD ALL SUBFILE - NON-ILE
> LOAD FORWARD SUBFILE - NON-ILE
> PAGE-AT-A-TIME SUBFILE NON-ILE
> LOAD ALL SUBFILE WITH SELECTION - NON-ILE
> LOAD ALL SUBFILE INPUT/UPDATE/DELETE  NON-ILE
>
> -----Original Message-----
> From: dbryant@banpharm.com [mailto:dbryant@banpharm.com]
> Sent: Thursday, April 06, 2000 7:56 AM
> To: RPG400-L@midrange.com
> Subject: Re: Printer Control Codes
>
> I don't know about "on-line", but we purchased a book written by Mark
McCall
> named "The AS/400 Programmer's Handbook" (A Toolbox of Examples for Every
> AS/400
> Programmer).  It is wonderful!!  You can purchase it from Midrange
> Computing. By
> the way, Mark's email address is in the back of this book. I have emailed
> him on
> several occasions and he has always responded by the next day. He is so
nice
> and
> very helpful.  I can't say enough good things about him or his book...
>
> Darlene Bryant
>
> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to RPG400-L@midrange.com.
> | To subscribe to this list send email to RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---
>
>
> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to RPG400-L@midrange.com.
> | To subscribe to this list send email to RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---
>
>
>



+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---