The AS/400 Programmer's Handbook, Volume II More Toolbox Examples for Every AS/400 Programmer

by McCall, Mark

• ISBN13: 9781583470121
• ISBN10: 1583470123
• Edition: CD
• Format: Paperback
• Copyright: 2000-04-22
• Publisher: MC Press

Summary

Now you can stop wasting countless hours wading through IBM's technical manuals, looking for programming examples to show you how a technique really needs to be coded. This book and companion CD contain more than 70 prototypical techniques and coding examples that you can use and adapt for hundreds of applications. From system APIs to SQL, the material presented encompasses the most useful and powerful features of the AS/400. Far more valuable than just code samples, each example is accompanied by a thorough line-by-line explanation of the techniques employed. As a programming tool or as a learning aid, this book is the first place to look for practical, hands-on development assistance.

Table of Contents

Introduction	xvii
Part 1: RPG Programming Examples	1	(226)
Modular Coding Techniques	3	(22)
Common Modular RPG Coding Techniques	4	(1)
Using the/Copy Compiler Directive	4	(2)
What the Example Does	4	(1)
How the Example Works	5	(1)
Using Internal Subroutines	6	(2)
What the Example Does	7	(1)
How the Example Works	8	(1)
Using Dynamic Subprograms	8	(3)
What the Example Does	9	(1)
How the Example Works	10	(1)
Using ILE Subprocedures	11	(5)
What the Example Does	12	(1)
How the Example Works	13	(3)
Using ILE Subprocedures from a Service Program	16	(9)
What the Example Does	17	(1)
How the Example Works	18	(7)
Built-In Functions	25	(48)
Using the %ABS Function	27	(1)
What the Example Does	27	(1)
How the Example Works	27	(1)
Using the %ADDR Function	28	(3)
What the Example Does	28	(1)
How the Example Works	29	(2)
Using the %CHAR Function	31	(1)
What the Example Does	31	(1)
How the Example Works	32	(1)
Using the %DEC and %DECH Functions	32	(2)
What the Example Does	32	(1)
How the Example Works	33	(1)
Using the %DECPOS Function	34	(1)
What the Example Does	34	(1)
How the Example Works	35	(1)
Using the %DIV and %REM Functions	35	(1)
What the Example Does	35	(1)
How the Example Works	36	(1)
Using the %EDITC, %EDITFLT, and %EDITW Functions	36	(3)
What the Example Does	37	(1)
How the Example Works	38	(1)
Using the %ELEM Function	39	(1)
What the Example Does	39	(1)
How the Example Works	40	(1)
Using the %EOF Function	40	(1)
What the Example Does	40	(1)
How the Example Works	41	(1)
Using the %EQUAL Function	41	(2)
What the Example Does	41	(1)
How the Example Works	42	(1)
Using the %ERROR and %STATUS Functions	43	(2)
What the Example Does	43	(1)
How the Example Works	44	(1)
Using the %FOUND Function	45	(2)
What the Example Does	45	(1)
How the Example Works	46	(1)
Using the %INT and %INTH Functions	47	(1)
What the Example Does	47	(1)
How the Example Works	48	(1)
Using the %LEN and %SIZE Functions	48	(6)
What the Example Does	48	(2)
How the Example Works	50	(4)
Using the %OPEN Function	54	(1)
What the Example Does	54	(1)
How the Example Works	54	(1)
Using the %PARMS Function	54	(2)
What the Example Does	55	(1)
How the Example Works	56	(1)
Using the %SCAN and %REPLACE Functions	56	(5)
What the Example Does	57	(1)
How the Example Works	58	(3)
Using the %SUBST Function	61	(1)
What the Example Does	61	(1)
How the Example Works	62	(1)
Using the %TRIM, %TRIML, and %TRIMR Functions	62	(2)
What the Example Does	62	(1)
How the Example Works	63	(1)
Using the %UNS and %UNSH Functions	64	(1)
What the Example Does	64	(1)
How the Example Works	65	(1)
Using the %XFOOT Function	65	(1)
What the Example Does	65	(1)
How the Example Works	66	(1)
Using the %FLOAT Function	66	(1)
What the Example Does	66	(1)
How the Example Works	67	(1)
Using the %PADDR Function	67	(3)
What the Example Does	67	(1)
How the Example Works	68	(2)
Using the %NULLIND Function	70	(3)
What the Example Does	70	(1)
How the Example Works	71	(2)
Exit Programs	73	(36)
What Are User Exit Programs?	73	(1)
The Registration Facility	74	(1)
Common Uses for Exit Programs	74	(2)
Using an Exit Program to Monitor User Profile Creation	76	(5)
What the Example Does	76	(3)
How the Example Works	79	(2)
Using an Exit Program to Monitor User Profile Changes	81	(4)
What the Example Does	81	(3)
How the Example Works	84	(1)
Using an Exit Program to Monitor User Profile Deletion	85	(5)
What the Example Does	86	(2)
How the Example Works	88	(2)
Using an Exit Program to Monitor User Profile Restoration	90	(3)
What the Example Does	90	(2)
How the Example Works	92	(1)
Using an Exit Program to Monitor Database Server Access	93	(4)
What the Example Does	94	(1)
How the Example Works	95	(2)
Using an Exit Program to Log Database Server Requests	97	(4)
What the Example Does	97	(1)
How the Example Works	98	(3)
Using the Job Notification Exit Point	101	(8)
What the Example Does	101	(3)
How the Example Works	104	(5)
Application Programming Interfaces	109	(118)
The Categories of APIs	110	(1)
AS/400 System API Reference Manual	111	(5)
Using the Command Execution API	116	(3)
What the Example Does	116	(1)
How the Example Works	117	(2)
Using the Command Processor API	119	(8)
What the Example Does	119	(2)
How the Example Works	121	(6)
Using the Retrieve Job Status API	127	(6)
What the Example Does	127	(2)
How the Example Works	129	(4)
Using the List Job Schedule Entries API	133	(22)
What the Example Does	134	(3)
How the Example Works	137	(18)
Using the List Job API	155	(29)
What the Example Does	155	(5)
How the Example Works	160	(24)
Using the List Spooled Files API	184	(29)
What the Example Does	184	(7)
How the Example Works	191	(22)
Using the Random Number Generation API	213	(4)
What the Example Does	214	(1)
How the Example Works	214	(3)
Using the ILE Date APIs	217	(10)
What the Example Does	217	(1)
How the Example Works	218	(9)
Part 2: Database Examples	227	(124)
Database Constraints	229	(16)
Check Constraints	230	(1)
Referential Integrity Constraints	230	(1)
General Considerations	230	(2)
Using a Check Constraint to Validate a Single Value	232	(3)
What the Example Does	234	(1)
How the Example Works	234	(1)
Using a Check Constraint to Validate Complex Values	235	(1)
What the Example Does	235	(1)
How the Example Works	235	(1)
Using a Check Constraint with Field-to-Field Validation	236	(2)
What the Example Does	237	(1)
How the Example Works	237	(1)
Using a Check Constraint with an Embedded Function	238	(2)
What the Example Does	239	(1)
How the Example Works	239	(1)
Using a Referential Integrity Constraint	240	(5)
What the Example Does	240	(1)
How the Example Works	241	(4)
Database Triggers	245	(36)
What Can You Do With a Trigger?	246	(1)
Trigger Program Parameters	247	(1)
Adding a Trigger to a File	248	(1)
General Considerations	248	(1)
Using a Trigger to Auto-Generate a Key Value	249	(8)
What the Example Does	252	(1)
How the Example Works	252	(5)
Using a Trigger for Security Monitoring	257	(11)
What the Example Does	261	(1)
How the Example Works	261	(7)
Using a Trigger for Data Validation	268	(13)
What the Example Does	272	(1)
How the Example Works	272	(9)
Using SQL	281	(70)
What Can You Do with SQL?	282	(1)
SQL Terminology	282	(1)
SQL Statements	282	(3)
Ways to Run SQL Statements	285	(1)
Using SQL to Create a Library and Files	285	(5)
What the Example Does	287	(1)
How the Example Works	287	(3)
Using SQL to Create a View to Join Two Files	290	(4)
What the Example Does	292	(1)
How the Example Works	292	(2)
Performing Simple SQL Select Queries	294	(2)
Using SQL to Perform a Simple Select Query Returning all Fields	296	(1)
What the Example Does	296	(1)
How the Example Works	296	(1)
Using SQL to Perform a Simple Select Query Returning Selected Fields	297	(2)
What the Example Does	297	(1)
How the Example Works	298	(1)
Using SQL to Perform a Simple Select Query with Selection Criteria	299	(2)
What the Example Does	299	(1)
How the Example Works	300	(1)
Performing SQL Select Queries That Join Files	301	(3)
Using SQL to Perform a Select Query Joining Two Files	304	(4)
What the Example Does	304	(2)
How the Example Works	306	(2)
Using SQL to Perform a Select Query Joining Three Files	308	(4)
What the Example Does	308	(1)
How the Example Works	309	(3)
Using SQL to Perform a Select and Join Query Calculating an Average	312	(4)
What the Example Does	312	(1)
How the Example Works	313	(3)
Performing SQL Select Queries That Summarize Data	316	(1)
Using SQL to Count the Number of Records in a Group	317	(2)
What the Example Does	317	(1)
How the Example Works	318	(1)
Using SQL to Produce Summary Totals for a Group of Records	319	(3)
What the Example Does	319	(1)
How the Example Works	320	(2)
Inserting Records with SQL	322	(1)
Using SQL to Add a Single Record to a File	323	(1)
What the Example Does	323	(1)
How the Example Works	324	(1)
Using SQL to Add Multiple Records to a File	324	(2)
What the Example Does	324	(1)
How the Example Works	325	(1)
Deleting Records with SQL	326	(1)
Using SQL to Delete Records Based on a Selection	327	(1)
What the Example Does	327	(1)
How the Example Works	328	(1)
Using SQL to Delete All Records in a File	328	(1)
What the Example Does	328	(1)
How the Example Works	328	(1)
Using SQL to Delete Records Based on Query Results	329	(3)
What the Example Does	329	(1)
How the Example Works	329	(3)
Updating Records with SQL	332	(2)
Using SQL to Change All Records in a File to Uppercase	334	(1)
What the Example Does	334	(1)
How the Example Works	334	(1)
Using SQL to Update Records Based on Query Results	335	(3)
What the Example Does	335	(1)
How the Example Works	335	(3)
Embedded SQL	338	(1)
Using Static Embedded SQL to Select and Process Records	339	(4)
What the Example Does	339	(1)
How the Example Works	340	(3)
Using Static SQL to Flexibly Select and Process Records	343	(8)
What the Example Does	343	(2)
How the Example Works	345	(6)
Appendix: Software Loading Instructions	351	(6)
Step-By-Step Instructions	351	(6)
Index	357