1 / 15

The OS/400 as a Technical Solution for Medium-Size Enterprises

The OS/400 as a Technical Solution for Medium-Size Enterprises. Student:Arnoldo Herrera Instructor: Dr. Raimund Ege Table of Contents Introduction & Technical Background Operating System Structure AS/400 Security Applications: J.D. Edwards Financial Package

vian
Download Presentation

The OS/400 as a Technical Solution for Medium-Size Enterprises

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. The OS/400 as a Technical Solution for Medium-Size Enterprises Student:Arnoldo Herrera Instructor: Dr. Raimund Ege Table of Contents Introduction & Technical Background Operating System Structure AS/400 Security Applications: J.D. Edwards Financial Package Applications: The AS/400 as a Server Appendix

  2. Introduction & Technical BackgroundThe Application System/400 (AS/400) is the IBM technical solution for the midrange computer market.It is used nationwide and has been one of the dominant players in the computer industry.Introduced in 1988 have more capabilities than the previous models of the System 3X family (i.e., S/3, S/32, S/34, S/36, and S/38).Has very closed architectural similarity with S/38, the predecessor of the AS/400.The basic architectural concept is that the AS/400 is an object-based machine. The operating system that controls all interactions with the AS/400 is the OS/400.

  3. Operating System Structure- Screen Design Aid (SDA)- Source Entry Utility (SEU)- Data File Utility (DFU)- Control Language (CL)- Program Development Manager- Query/400- RPG/400 ILE

  4. AS/400 is an Object Based SystemExamples of AS/400 Objects- Libraries- Message, Job & Data Queues- Output Queues- Query Definitions- Subsystems

  5. Library Containing AS/400 Objects Data Queue Job Queue Files Programs Query definitions Job Description User Profile Message Queue Output Queue

  6. AS/400 SUBSYSTEM DISTRIBUTION Base Pool Machine Pool Batch Jobs Interactive Jobs Operator Jobs

  7. AS/400 SecurityTaxonomy of AS/400 Access Rights System Authority Special Authority Specific Authority All objects Security Administration Object Authority Data Authority Operational Job Control Exclusion Read Management Add Service Update Existence Spool Control Delete

  8. AS/400 Security: User Profiles • Every job has a set of attributes that describes the environment, resources, and capabilites. These attributes come from several sources including the job description or the user profile. • User profiles are AS/400 objects that contain information about users (default message & output queues, job description, special authority, current library etc.) • Job descriptions contain a collection of attributes such as library list, job queue, etc.

  9. Applications: J.D. Edwards Financial Package & OPNQRYFThe Dream Writer stands for Data Record Extraction and Management and is part of all JDE systems. The DREAM Writer invokes and generates all the parameters used by the OPNQRYF command of the OS/400 operating system. The OPNQRYF command can be used to select records, sort a database file in ascending order or descending order, create new fields and summarize data according to the parameters that were specified in the DREAM Writer. Another purpose of the DREAM writer is to generate reports, produce control breaks, or determine the printing order of the data. In addition, the user can specify many versions of the report.

  10. The Dream Writer Cycle (Generates OPNQRYF) Data Sequencing Version Id 6 1 Additional Parameters Data Selection 2 5 Processing Options Printer Overrides 4 3

  11. APPLICATIONS: AS/400 AS A SERVERODBC- Standard way to connect to different RDBMS products - Standard set of error codes- Consistent method of delivering SQL statements- Code can be reusable

  12. Open Database ConnectivityClient/Server Applications PC AS/400 Program Session Database ODBC ODBC Driver Driver ODBC

  13. Appendix

  14. COMMON AS/400 COMMANDSWRKACTJOB WRKSBMJOBWRKJOBQ DSPDTAARA WRKLIB DSPOBJDWRKLIBPDM DSPOBJAUTWRKOBJ CRTJOBQDSPUSRPRF CRTDUPOBJOPNQRYF WRKUSRPRFWRKJOBD DSPJOBD

  15. COMMON AS/400 COMMANDS (Cont’d)CRTDTAQ CRTOUTQDLTDTAQ CLRDTAQCHKOBJ RTVJOBARTVOBJD MVOBJCHGOBJD CRTDTAARA DLTDTAARA DSPPGMMSG CHGCURLIB CHGLIBL

More Related