Muutke küpsiste eelistusi

Mastering IBM i: The Complete Resource for Today's IBM i System [Pehme köide]

4.00/5 (12 hinnangut Goodreads-ist)
,
  • Formaat: Paperback / softback, 952 pages, kõrgus x laius x paksus: 254x203x38 mm, kaal: 1456 g
  • Ilmumisaeg: 01-May-2011
  • Kirjastus: MC Press, LLC
  • ISBN-10: 1583473564
  • ISBN-13: 9781583473566
Teised raamatud teemal:
Mastering IBM i: The Complete Resource for Today's IBM i SystemSuurem pilt
  • Formaat: Paperback / softback, 952 pages, kõrgus x laius x paksus: 254x203x38 mm, kaal: 1456 g
  • Ilmumisaeg: 01-May-2011
  • Kirjastus: MC Press, LLC
  • ISBN-10: 1583473564
  • ISBN-13: 9781583473566
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9781583473566.html
Märksõnad:
A comprehensive introduction to IBM i—the operating system that runs on IBM's midrange computer systems (System i, iSeries, AS/400)—and its facilities, this in-depth resource uses step-by-step exercises, review questions, and chapter labs to teach new programmers the latest system concepts and tools. Reflecting system changes that have occurred since 2000, topics include Rational Developer for Power (RDP), RDP Screen Designer and Report Designer, IBM i Access for Windows, IBM i Access for Web, IBM DB2 Web Query for i, and Remote System Explorer (RSE).

A comprehensive introduction to IBM i—the operating system that runs on IBM's midrange computer systems (System i, iSeries, AS/400)—and its facilities, this in-depth resource uses step-by-step exercises, review questions, and chapter labs to teach new programmers the latest system concepts and tools. Reflecting system changes that have occurred since 2000, topics include Rational Developer for Power (RDP), RDP Screen Designer and Report Designer, IBM i Access for Windows, IBM i Access for Web, IBM DB2 Web Query for i, and Remote System Explorer (RSE).
Acknowledgments iv
Introduction xiii
1 Communicating with the System
1(42)
The System
2(1)
IBM i Objects
2(1)
Subsystems
3(1)
Types of Jobs
3(1)
Control Language (CL)
4(1)
System Values
5(1)
Licensed Programs
6(1)
User Profile
7(3)
Sign-On
8(2)
User Interface
10(1)
Menu Screens
11(3)
Prompt Entry/Command Prompt Screens
14(3)
Using Help
17(5)
Field or Context-Sensitive Help
17(1)
Extended Help
18(1)
Information Assistant
19(3)
List or Work-With Screens
22(2)
In Summary
24(1)
Key Terms
25(1)
Review Questions
26(1)
Lab 1
27(16)
2 Using CL
43(38)
CL Commands
44(1)
Control Language Syntax
44(10)
Command Names
44(3)
Keyword Notation
47(5)
Positional Notation
52(2)
Menus of Commands
54(3)
The GO Command
57(3)
Library Lists
60(4)
System Library List
60(2)
Product Library
62(1)
Current Library
63(1)
User Library List
63(1)
Objects Within Libraries
63(1)
In Summary
64(1)
Key Terms
65(1)
Review Questions
65(1)
Lab 2
66(15)
3 Objects
81(46)
The IBM i Object-Based Architecture
82(2)
Types of IBM i Objects
84(2)
Requesting an Object
86(1)
Qualified Names
87(1)
Library-List Commands
88(8)
The DSPLIBL Command
88(1)
The CHGCURLIB Command
89(2)
The ADDLIBLE Command
91(1)
The CHGLIBL Command
92(2)
The EDTLIBL Command
94(2)
Locating an Object
96(2)
Storing Objects
98(2)
Simplified Batch Work Management
100(5)
Printer Spooling
101(4)
In Summary
105(1)
Key Terms
105(1)
Review Questions
106(1)
Lab 3
107(20)
4 Handling Spooled Files
127(38)
Printer Files
127(3)
Printer Writer
130(1)
Changing Writers
131(1)
Changing Spooled Files
132(14)
Working with Output Queues
133(6)
Working with Spooled Files
139(2)
Changing Spooled File Attributes
141(5)
Clear Output Queue
146(1)
Assistance Levels
146(4)
In Summary
150(1)
Key Terms
151(1)
Review Questions
151(1)
Lab 4
152(13)
5 Describing a Database File
165(48)
File Varieties
166(1)
Program-Described Files
167(1)
Externally Described Files
167(35)
Creating an Externally Described Database File
170(32)
In Summary
202(1)
Key Terms
203(1)
Review Questions
204(1)
Lab 5
204(9)
6 Creating and Using an Externally Described Database File
213(36)
More About SEU
213(7)
Starting SEU
214(2)
Using PDM to Access SEU
216(1)
SEU Line Commands
217(3)
Compiling the File Description
220(4)
Create (CRT) Commands
221(1)
The PDM Compile Option
221(3)
Displaying an Object's Description
224(5)
Displaying a File Description
226(1)
Displaying Record-Format Information
227(2)
Data File Utility
229(7)
Using a Temporary DFU Program
231(1)
Starting DFU on an Empty File
232(2)
DFU Change Mode
234(1)
Exiting DFU
235(1)
In Summary
236(1)
Key Terms
236(1)
Review Questions
237(1)
Lab 6
237(12)
7 Introduction to Query
249(78)
What Query for i5/OS Does
249(2)
Starting Query for i5/OS
251(1)
Working with Queries
252(2)
Defining a Query
254(16)
Selecting Files
255(3)
Previewing a Query Layout
258(2)
Formatting Report Columns
260(10)
Refining Your Query
270(21)
Selecting Sort Fields
272(2)
Defining Report Breaks
274(3)
Selecting and Sequencing Fields
277(3)
More Report Column Formatting
280(3)
Report Summary Functions
283(1)
Defining Result Fields
284(3)
Finishing the Report
287(2)
Exiting Query
289(2)
A Conceptual Foundation for Joining Files
291(3)
Creating a Join Query
294(6)
1 Matched Records
298(1)
2 Matched Records with Primary File
299(1)
3 Unmatched Records with Primary File
299(1)
Specifying the Join Relationship
300(5)
In Summary
305(1)
Key Terms
306(1)
Review Questions
306(1)
Lab 7
307(20)
8 Using Logical Files
327(86)
Physical Files and Access Paths
328(5)
Arrival-Sequence Access Paths
328(1)
Keyed-Sequence Access Paths
329(4)
Logical Files
333(18)
Describing a Simple Logical File
334(17)
Creating a Logical File
351(6)
Specifying Access Path Maintenance
354(1)
Using DFU on Logical Files
355(2)
Creating Join Logical Files
357(25)
Projection, Selection, and Access Path with Join Logical Files
361(2)
Using Query for i5/OS with a Join Logical File
363(19)
Multiple-Format Logical Files
382(8)
In Summary
390(1)
Key Terms
391(1)
Review Questions
392(1)
Lab 8
392(21)
9 Additional Database Facilities
413(66)
Creating a File (Review)
414(2)
Changing the Source DDS
416(18)
Preserving the Existing Data
418(16)
Recompiling Programs and Queries That Use a Changed Physical File
434(1)
Dealing with Based-On Logical Files
434(3)
Using CHGPF to Modify a Physical File
437(3)
Database File-Level Security
440(14)
Authorization Lists
447(3)
Group Profiles
450(4)
In Summary
454(1)
Key Terms
455(1)
Review Questions
456(1)
Lab 9
456(23)
Additional Lab Exercise
473(6)
10 Using IBM i Navigator
479(66)
Introduction to IBM i Access
480(3)
Accessing Help
483(1)
Creating a Connection to the System
484(6)
Basic Operations
490(22)
Messages
490(7)
Printer Output
497(4)
Printers
501(7)
Jobs
508(4)
Work Management
512(10)
Active Jobs
513(5)
Job Queues
518(2)
Output Queues
520(1)
Subsystems
521(1)
Databases
522(3)
File Systems
525(5)
In Summary
530(1)
Key Terms
531(1)
Review Questions
532(1)
Lab 10
533(12)
11 Using Remote System Explorer
545(58)
History
546(2)
IBM and Eclipse
546(1)
The IBM Rational Toolset
546(2)
Getting Started
548(40)
Creating a Connection
551(5)
Library List: Add, Change, Remove Libraries
556(4)
Creating a Source Physical File
560(1)
Copying a Member
561(2)
Opening and Editing a Member
563(3)
Editing and Saving
566(5)
Compiling
571(3)
Debugging Overview
574(2)
Debugging a Program
576(10)
Running a Program
586(2)
In Summary
588(1)
Key Terms
588(1)
Review Questions
589(1)
Lab 11
590(13)
12 Using Screen Designer and Report Designer
603(48)
History
604(1)
Getting Started
604(9)
Modifying a Print File
606(2)
Adding Records to a Print File
608(2)
Adding Fields and Modifying Properties
610(3)
Creating a Display Screen
613(17)
Create the Display Screen Source Member
613(2)
Add a Record
615(2)
Add Keywords to a File or Record
617(4)
Add Fields to the Record
621(3)
Add Database Fields to a Record
624(4)
Compile the Display
628(2)
In Summary
630(1)
Key Terms
631(1)
Review Questions
631(1)
Lab 12
632(19)
13 Introduction to SQL
651(66)
A Short History of SQL
652(1)
Introduction to SQL Terms
652(1)
Introduction to SQL
652(1)
Interfaces Used to Enter SQL Commands
653(3)
Starting the Run SQL Scripts Interface
656(3)
SQL Syntax
659(27)
Select field-list
660(2)
From file-list
662(6)
Where conditional-expression
668(4)
Some Additional SQL Capabilities
672(14)
File Maintenance Using SQL
686(8)
The Insert Statement
686(2)
The Update Statement
688(4)
The Delete Statement
692(2)
Using SQL Assist/Prompt
694(10)
In Summary
704(1)
Key Terms
705(1)
Review Questions
706(1)
Lab 13
706(11)
14 Using IBM i Access for Web
717(66)
Introduction to IBM i Access for Web
718(31)
5250 User Interface
720(7)
Database Function
727(18)
Print
745(1)
Messages
746(1)
Jobs
747(1)
Other
748(1)
In Summary
749(1)
Key Terms
749(1)
Review Questions
749(1)
Lab 14
750(33)
15 Introduction to DB2 Web Query for i
783(80)
DB2 Web Query for i
784(1)
Query for i5/OS Limitations
785(1)
DB2 Web Query Features
786(2)
Domains
787(1)
Users
787(1)
Metadata
787(1)
Getting Started with DB2 Web Query
788(5)
DB2 Web Query Help
789(4)
Introducing InfoAssist
793(10)
Getting Started with InfoAssist
794(2)
InfoAssist Application Window Features
796(7)
Creating the Profit Margin Inventory Report
803(9)
Creating a Profit Margin Chart
812(10)
Enhancing Charts
817(5)
Creating a Compound Document
822(10)
Summary
832(1)
Key Terms
833(1)
Review Questions
833(1)
Lab 15
834(29)
16 Getting Started with CL Programming
863(60)
CL Review
864(2)
CL Program Uses
866(1)
Advantages of CL Programs
866(1)
Creating CL Programs
867(1)
Using RDP to Enter CL Source
868(2)
CL Program Structure
870(2)
Designing the Start-Up Program
872(2)
Entering the Program
874(24)
Declaring a File
875(1)
Declaring Variables
876(2)
Changing the Value of a Variable
878(2)
Control Structures
880(4)
Iteration Structures
884(4)
File I/O in CL Programs
888(2)
Sending Messages
890(6)
Using Concatenation
896(2)
Finishing the Start-Up Program
898(6)
Creating a CL Program
904(1)
In Summary
904(2)
Key Terms
906(1)
Review Questions
906(1)
Lab 16
907(12)
Lab 16 Source Listings
919(4)
STRUPPGM Source Code
919(2)
MARKTIME Source Code
921(2)
Index 923
Jim Buck is a programmer with over 25 years of experience, an analyst instructor at Gateway Technical College, and the president of the Wisconsin Midrange Computer Professional Association. He lives in Kenosha, Wisconsin. Bryan Meyers is the author of numerous books.