Résumé
This newest edition is fully updated for V4R3 of OS/400 and
moves you directly into programming languages, database
management, and system operations courses. The book
emphasizes comprehensive understanding and skills in the
areas of system/user interface, member-object-library
relationship, use of CL commands, basic database concepts,
and program development utilities.
Contents
Lesson 1 -- Communicating with the System
| Lesson Overview Objectives The System Types of Jobs OS/400 Control Language System Values Licensed Programs User Profile Sign-On User Interface Menu Screens Entry/Command Prompt Screens Using Help Field or Context-Sensitive Help Extended Help InfoSeeker InfoSeeker Tour Information Assistant Search Index List or Work-With Screens Key Terms Lab 1 In Summary |
|
| Lesson 2 -- Using CL | |
| Lesson Overview Objectives CL Commands CL Syntax Command Names Keyword Notation Positional Notation Menus of Commands The GO Command Library Lists System Library List Product Library Current Library User Library List Objects Within Libraries Key Terms Lab 2 In Summary |
|
| Lesson 3 -- Objects | |
| Lesson Overview Objectives The AS/400 Object-Based Architecture Types of AS/400 Objects Requesting an Object Qualified Names Library List Commands The DSPLIBL Command The CHGCURLIB Command The ADDLIBLE Command The CHGLIBL Command The EDTLIBL Command Locating an Object Storing Objects Objects That Help Manage Work Flow, or the Concept of Spooling Printer Spooling Key Terms Lab 3 In Summary |
|
| Lesson 4 -- Handling Spooled Files | |
| Lesson Overview Objectives Printer Files Printer Writer Changing Writers Changing Spooled Files Working with Output Queues Working with Spooled Files Changing Spooled File Attributes Assistance Levels Key Terms Lab 4 In Summary |
|
| Lesson 5 -- Describing a Database File | |
| Lesson Overview Objectives File Varieties Program-Described Files Externally Described Files Creating an Externally Described Database File Methods of Describing Database Files at the Field Level IDDU SQL DDS Introduction to PDM The STRPDM Command Work with Libraries Using PDM Work with Objects Using PDM Work with Members Using PDM Creating a Member via SEU SEU Help SEU Line Commands DDS Record Format Entry Field-Level Entries Name Length Data Type Decimal Positions Exiting SEU Key Terms Lab 5 In Summary |
|
| Lesson 6 -- Creating and Using an Externally Described Database File | |
| Lesson Overview Objectives More About SEU Starting SEU Accessing SEU via PDM SEU Line Commands Target Designator Compiling the File Description Create (CRT) Commands The PDM Compile Option Displaying an Object?s Description Displaying a File Description DFU Using a Temporary DFU Program Starting DFU on an Empty File Exiting DFU Key Terms Lab 6 In Summary |
|
| Lesson 7 -- Introduction to Query/400 | |
| Lesson Overview Objectives What Query/400 Does Getting into Query/400 Working with Queries Defining the Query Selecting Files Previewing a Query Layout Formatting Report Columns Editing Options Editing Numeric Date and Time Fields Selecting Sort Fields Defining Report Breaks Selecting and Sequencing Fields More Report Column Formatting Report Summary Functions Defining Result Fields Finishing the Report Exiting Query A Conceptual Foundation for Joining Files Creating a Join Query Matched Records Matched Records with Primary File Unmatched Records with Primary File Specifying the Join Relationship Key Terms Lab 7 In Summary |
|
| Lesson 8 -- Using Logical Files | |
| Lesson Overview Objectives Physical Files and Access Paths Access Paths Keyed-Sequence Access Paths Specifying Key Fields Logical Files Describing a Simple Logical File Alternate Access Path Select Omit: The Inverse of Select Projection Creating a Logical File Specifying Access Path Maintenance Using DFU on Logical Files Creating Join Logical Files Projection, Selection, and Access Path with Join Logical Files Using Query/400 with a Join Logical File Joining More Than Two Files Multiple-Format Logical Files Key Terms Lab 8 In Summary |
|
| Lesson 9 -- Additional Database Facilities | |
| Lesson Overview Objectives Creating a File (Review) Changing the Source DDS Preserving the Existing Data Renaming the File The Copy File Command Record Format Field Mapping Verifying the Copy Operation Recompiling Programs and Queries That Use a Changed Physical File Dealing with Based-On Logical Files Using CHGPF to Modify a Physical File Database File-Level Security Authorization Lists Group Profiles Key Terms Lab 9 In Summary |
|
| Lesson 10 -- Using DFU and SQL | |
| Lesson Overview Objectives Why DFU? Accessing DFU Creating a DFU Program Defining General Information Defining Audit Control and Choosing Record Formats Selecting and Sequencing Fields Specifying Extended Field Definitions Exiting DFU A Brief Introduction to SQL SELECT field-list FROM file-list Where conditional-expression Some Additional SQL Capabilities File Maintenance Using SQL The Insert Statement The Update Statement The Delete Statement Key Terms Lab 10 In Summary |
|
| Lesson 11 -- Using SDA | |
| Lesson Overview Objectives What SDA Does Getting Started with SDA Menus Designing the Menu Specifying Attributes Setting Field Attributes Using Attribute Commands Defining Menu Commands Exiting SDA Menus Display Files Creating a Nonmenu Display Screen Using the Design Image Work Screen Useful Function Keys Manipulating Constants and Fields Adding Input/Output Data Fields Using Indicators A Brief Review Saving the Display File Testing the Display File Viewing the Members Created Key Terms Lab 11 In Summary |
|
| Lesson 12 -- Getting Started with CL Programming | |
| Lesson Overview Objectives CL Review CL Programs? Uses Advantages of CL Programs Entering CL Source CL Program Structure Designing the Start-Up Program Entering the Program Declaring a File Declaring Variables Changing the Value of a Variable Selection and Iteration File I/O in CL Programs SNDF RCVF SNDRCVF Sending Messages Using Concatenation Finishing the Start-Up Program Creating a CL Program Key Terms Lab 12 In Summary |
|
| Appendix -- CL Command Cross-Reference Glossary |
|
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | 29th Street Press |
| Auteur(s) | Jerry Fottral |
| Parution | 01/12/2000 |
| Édition | 3eme édition |
| Nb. de pages | 553 |
| Format | 21,3 x 25,3 |
| Couverture | Broché |
| Poids | 1180g |
| Intérieur | Noir et Blanc |
| EAN13 | 9781583040706 |
Avantages Eyrolles.com
Livraison à partir de 0,01 € en France métropolitaine
Paiement en ligne SÉCURISÉ
Livraison dans le monde
Retour sous 15 jours
+ d'un million et demi de livres disponibles
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
