|
COBOL
Register
in the COBOL seminar.
|
SEMINAR CODE:
|
COBOL
|
DESCRIPTION:
|
This seminar is designed for programmers who are new to COBOL
and for those who have "read only" familiarity with COBOL. All
aspects of the basic COBOL language set will be covered.
Structured COBOL constructs, divisional requirements, and syntax
conventions will be mastered. Predefined and dynamic storage
allocations will be coded and deployed. In addition, special
features of COBOL will be covered. File I/O between COBOL and a
variety of file types flat, sequential, partitioned, VSAM, DB2
tables) will be studied. The COBOL SORT facility will be
scrutinized. COBOL programs will be run online and in batch
mode. COBOL table lookups will be written. Laboratory
experiments will present and explore all interactions between
COBOL and data and files and reports. This seminar reveals how
to design, code, analyze, and maintain COBOL application
programs including data access, parameter passing and receiving.
|
OBJECTIVES:
|
Upon completion of this seminar, students will be able to:
|
|
- understand the COBOL syntax conventions and the layout and
the divisions of a COBOL program
- be able to read, code, and maintain structured COBOL
programs
- understand the COBOL SORT statement
- be able compile and linkedit COBOL programs
- execute COBOL programs online or in batch mode
- deploy COBOL builtin functions
- perform table lookups and file processing
- inject a range of SQL statements into DB2 from a COBOL
application program as well as read from and write to VSAM
datasets
|
FORMAT:
|
Lecture, demonstration, boardwork, laboratory experiments,
conversation.
|
AUDIENCE:
|
This seminar is intended for all novice or intermediate COBOL
programmers who would like to learn COBOL or take their
experience to the next level in designing, coding, or
maintaining structured COBOL programs.
|
PREREQUISITES:
|
Experience with the ISPF editor and ISPF utilities is required;
prior JCL programming with job submission and retrieval
experience is useful.
|
DURATION:
|
30 hours.
|
|
ColdFusion
Register in the ColdFusion seminar.
|
SEMINAR CODE: | ColdFusion
|
DESCRIPTION: |
This seminar is designed for web page makers who want to
exchange data between web pages and any database using
ColdFusion. In this seminar the ColdFusion development
environment will be set up. The ColdFusion server and a personal
web server will be installed locally. ColdFusion templates will
manage ODBC SQL requests locally and remotely. ColdFusion Studio
will be installed and mastered. Database data will be displayed,
updated, inserted, and deleted from web pages using ColdFusion
Markup Language CFML tags. ColdFusion program flow controls will
be deployed, as well as dynamic SQL queries incorporating -
where necessary - ColdFusion variables. Server-side validation
will be studied, and JavaScript will be incorporated to perform
client-side validation. This seminar provides web page makers
with the knowledge and hands on practice they need to build and
maintain dynamic and interactive display and drill down web
applications using ColdFusion.
|
OBJECTIVES: | Upon completion of this seminar, students will be able to: |
|
- understand ColdFusion Markup Language CFML syntax andCold Fusion functions syntax
- deploy ColdFusion to interact with any database from a web page
- understand ColdFusion components and architecture
- set up the ColdFusion development environment and install the ColdFusion server and a personal web server
- install and efficiently deploy ColdFusion Studio
- use ColdFusion client-side and server-side validation capabilities
- define Open Database Connectivity ODBC drivers to interact with any database's tables
- use client and session variables within applications
- create database reports using ColdFusion in a variety of formats including ColdFusion trees and ColdFusion graphs
- develop fully interactive, database driven internet and intranet display and drill down web applications
- navigate and manage the ColdFusion Administrator
|
FORMAT: | Lecture, demonstration, boardwork, laboratory experiments, conversation. |
AUDIENCE: |
This introductory seminar is intended for systems analysts,
application programmers, web page makers, project managers, and
database administrators who are new to ColdFusion and who wish
to deploy ColdFusion to create attractive, interactive web pages
that exchange data with any database.
|
PREREQUISITES: |
Familiarity with internet concepts and principles is required.
Familiarity with Netscape Communicator or Internet Explorer is
required. Familiarity with HTML HyperText Markup Language and
web page forms is required. Familiarity with relational database
concepts and the SQL language is advised. Familiarity with the
JavaScript language is useful.
|
DURATION: | 24 hours. |
|
Cross System Product
Register in the Cross System Product seminar.
|
SEMINAR CODE: | CSP
|
DESCRIPTION: |
This seminar is designed to ground it's participants in the
concepts and facilities of CSP. It's promise is to have them
emerge, upon completion, as competent CSP programmers. All
aspects of CSP will be scrutinized, all process options
deployed, all CSP high level language statements and control
variables will be studied. The seminar focuses on laboratory
experiments to create an opportunity for it's participants to
really master the way CSP is used to build efficient, easily
legible, easily maintainable CSP database applications.
|
OBJECTIVES: | Upon completion of this seminar, students will be able to: |
|
- deploy CSP to manipulate data stored in DB2 tables
- interact with a terminal user through CSP maps
- execute CSP applications correctly and efficiently in a TSO/E or zOS MVS batch or CICS pseudoconversational environment
- set up the SQLEXEC interface to incorporate SQL statements coded outside CSP
- cause one CSP application to interact with another via DXFR
|
FORMAT: | Lecture, demonstration, boardwork, laboratory experiments, conversation. |
AUDIENCE: |
This seminar is intended for all programmers interested in
mastering the features of CSP.
|
PREREQUISITES: |
Familiarity with Structured Query Language (SQL) and procedural programming fundamentals. Understanding large system data concepts such as concurrency control
(locking) and data integrity (logical units of work, dynamic backout, update commitment) is recommended but not required. Familiarity with DB2 concepts and
facilities is recommended but not required.
|
DURATION: | 30 hours. |
|
DB2 Concepts and Facilities
Register in the DB2 Concepts and Facilities seminar.
|
SEMINAR CODE: | DB2CaF
|
DESCRIPTION: |
This seminar is designed to provide participants with the basic
concepts and languaging of DB2. Participants will be introduced
to the layout (the "Big Picture") and facilities DB2. SQL will
be introduced, as well as authority levels, DB2 resources, and
various programming options.
|
OBJECTIVES: | Upon completion of this seminar, students will be able to: |
|
- grasp relational database concepts
- name DB2 objects
- manage DB2 resources
- read the DB2 catalog
- understand DB2 directory
- manage DB2 data types
- allow for referential integrity and normalization
- code SQL data manipulation: SELECT/UPDATE/DELETE/INSERT
- code SQL data definition: CREATE/DROP/ALTER
- code SQL data control: GRANT/REVOKE
- develop DB2 application programs: compile, precompile, link-edit, and bind
|
FORMAT: | Lecture, demonstration, boardwork, laboratory experiments, conversation. |
AUDIENCE: |
This seminar is intended for all first time DB2 programmers.
|
PREREQUISITES: |
Familiarity with the z/OS MVS environment would be beneficial
but is not required.
|
DURATION: | 6 hours. |
|
DB2 Application Programming
Register in the DB2 Application Programming seminar.
|
SEMINAR CODE: | DB2AP
|
DESCRIPTION: |
This seminar is designed to provide the tools to understand and
use SQL statements to access, manipulate, and manage DB2 objects
and resources using DB2I, SPUFI, and high level language
application programs. Efficiencies of DB2 coding and management
will be discussed. Extensive laboratory experiments will be
undertaken with the trainer providing one-on-one coaching at a
terminal for every participant.
|
OBJECTIVES: | Upon completion of this seminar, students will be able to: |
|
- navigate and use DB2I and SPUFI
- code efficient SQL statements SELECT, UPDATE, DELETE, INSERT, COMMIT, ROLLBACK, GRANT, REVOKE
- access data in joined tables
- code effective selects, subselects, and correlated subselects
- create DB2 tables
- refer to DB2 catalog tables
- imbed SQL in application programs
- understand host variables, null indicator receiver variables, and length indicator receiver variables
- use the DCLGEN utility
- access and get the most out of the SQLCA
- bind, rebind, and free DB2 application plans
- program single and multiple row reads and updates
- manage cursors
- understand and allow for effective locking
- police DB2 security and define authorization
- understand how to use the EXPLAIN utility to interpret efficiency considerations
|
FORMAT: | Lecture, demonstration, boardwork, laboratory experiments, conversation. |
AUDIENCE: |
This seminar is designed for application programmers who work
with DB2 using DB2I, SPUFI, and high level language application
programs.
|
PREREQUISITES: |
Experience in designing and coding application programs in a
high level language such as COBOL or PL/1 is required.
Familiarity with DB2 concepts and facilities is required.
Familiarity with MVS, TSO, and ISPF is required. Experience with
JCL and batch jobs would be useful but is not required.
|
DURATION: | 30 hours. |
|
DB2 Concepts and Facilities and Application Programming Combined
Register in the DB2 Concepts and Facilities and Application Programming Combined seminar.
|
SEMINAR CODE: | DB2CAP
|
DESCRIPTION: |
This seminar is designed to provide participants with the basic
concepts and languaging of DB2. Participants will be introduced
to the layout (the "Big Picture") and facilities of DB2. SQL
will be introduced, as well as authority levels, DB2 resources,
and various programming options. The seminar will provide the
tools to understand and use SQL statements to access,
manipulate, and manage DB2 objects and resources using DB2I,
SPUFI, and high level language application programs.
Efficiencies of DB2 coding and management will be discussed.
Extensive laboratory experiments will be undertaken with the
trainer providing one-on-one coaching at a terminal for every
participant.
|
OBJECTIVES: | Upon completion of this seminar, students will be able to: |
|
- grasp relational database concepts
- name DB2 objects
- manage DB2 resources
- read the DB2 catalog
- understand DB2 directory
- manage DB2 data types
- allow for referential integrity and normalization
- code SQL data manipulation: SELECT/UPDATE/DELETE/INSERT
- code SQL data definition: CREATE/DROP/ALTER
- code SQL data control: GRANT/REVOKE
- develop DB2 application programs: compile, precompile, link-edit, and bind
- navigate and use DB2I and SPUFI
- code efficient SQL statements SELECT, UPDATE, DELETE, INSERT, COMMIT, ROLLBACK, GRANT, REVOKE
- access data in joined tables
- code effective selects, subselects, and correlated subselects
- create DB2 tables
- imbed SQL in application programs
- understand host variables, null indicator receiver variables, and length indicator receiver variables
- use the DCLGEN utility
- access and get the most out of the SQLCA
- bind, rebind, and free DB2 application plans
- program single and multiple row reads and updates
- manage cursors
- understand and allow for effective locking
- police DB2 security and define authorization
- understand how to use the EXPLAIN utility to interpret efficiency considerations
|
FORMAT: | Lecture, demonstration, boardwork, laboratory experiments, conversation. |
AUDIENCE: |
This seminar is intended for all DB2 programmers and application
programmers who work with DB2 using DB2I, SPUFI, and high level
language application programs.
|
PREREQUISITES: |
Familiarity with the z/OS MVS environment would be beneficial
but is not required. Experience in designing and coding
application programs in a high level language such as COBOL or
PL/1 is required. Familiarity with MVS, TSO, and ISPF is
required. Experience with JCL and batch jobs would be useful but
is not required.
|
DURATION: | 30 hours. |
|
DB2 Concepts and Facilities and QMF Combined
Register in the DB2 Concepts and Facilities and QMF Combined seminar.
|
SEMINAR CODE: | DB2CQMF
|
DESCRIPTION: |
This seminar is designed to provide participants with the basic
concepts and languaging of DB2. Participants will be introduced
to the layout (the "Big Picture") and facilities DB2. SQL, QBE,
and prompted queries will be introduced. The seminar will
provide the tools to understand and use SQL statements to
access, manipulate, and manage DB2 objects. Extensive laboratory
experiments will be undertaken with the trainer providing
one-on-one coaching at a terminal for every participant. The
seminar will provide mastery of QMF and to use it to access
relational databases such as DB2. The REXX language will be
introduced as a driver of QMF Procedures. QMF will be run online
and in batch. QMF objects will be imported and exported.
Extensive experience will be gained in the prudent use of the
QMF report writing facility.
|
OBJECTIVES: | Upon completion of this seminar, students will be able to: |
|
- grasp relational database concepts
- name DB2 objects
- manage DB2 resources
- read the DB2 catalog
- understand DB2 directory
- manage DB2 data types
- allow for referential integrity and normalization
- code SQL data manipulation: SELECT/UPDATE/DELETE/INSERT
- code SQL data definition: CREATE/DROP/ALTER
- code SQL data control: GRANT/REVOKE
- understand the basic concepts and facilities of QMF
- build queries with SQL, QBE, and prompted query
- construct sophisticated reports with control columns, summary information, headings etc
- run QMF in the foreground or in batch mode
- navigate all of the QMF forms
- construct sophisticated query calling and report writing drivers using the REXX language in QMF procedures
|
FORMAT: | Lecture, demonstration, boardwork, laboratory experiments, conversation. |
AUDIENCE: |
This seminar is intended for all DB2 programmers and application
programmers who work with DB2 using QMF, and for data processing
and business professionals who want to use QMF to access,
manage, and report on the information in relational databases
such as DB2.
|
PREREQUISITES: |
Familiarity with the z/OS MVS environment would be beneficial
but is not required.
|
DURATION: | 30 hours. |
|
Easytrieve Plus Introduction
Register in the Easytrieve Plus Introduction seminar.
|
SEMINAR CODE: | EZTPI
|
DESCRIPTION: |
This seminar is designed for programmers who are novices with
Easytrieve Plus. All aspects of the basic Easytrieve Plus report
writer facility will be covered. Easytrieve Plus jobs will be
run online. Laboratory experiments will present and explore all
interactions between Easytrieve Plus and files and reports.
|
OBJECTIVES: | Upon completion of this seminar, students will be able to: |
|
- understand the Easytrieve Plus syntax conventions and the layout and the sections of an Easytrieve Plus program
- choose between various Easytrieve Plus report parameters and definition statements
- be able to run Easytrieve Plus programs in interpret mode
- execute Easytrieve Plus jobs in batch mode
|
FORMAT: | Lecture, demonstration, boardwork, laboratory experiments, conversation. |
AUDIENCE: |
This seminar is intended for all novice Easytrieve Plus
programmers who would like to learn the Easytrieve Plus report
writer.
|
PREREQUISITES: |
Experience with the ISPF editor and ISPF utilities is required;
prior JCL programming with job submission and retrieval
experience is useful.
|
DURATION: | 12 hours. |
|
Easytrieve Plus Advanced
Register in the Easytrieve Plus Advanced seminar.
|
SEMINAR CODE: | EZTPA
|
DESCRIPTION: |
This seminar is designed for programmers who are intermediate
with Easytrieve Plus. Special features of Easytrieve Plus will
be covered. File I/O between Easytrieve Plus and a variety of
file types (flat, sequential, partitioned, VSAM, DB2 tables)
will be studied. The macro facility and the external macro
libaray will be scrutinized. Easytrieve Plus jobs will be run
online and in batch. Easytrieve Plus table lookups will be
written. When requested, Easytrieve Plus will be run in
interpret mode as well as compiled and link-edited. The
synchronized file processor will be tested and Easytrieve Plus
will be used to perform various file extracts. Laboratory
experiments will present and explore all interactions between
Easytrieve Plus and files and reports.
|
OBJECTIVES: | Upon completion of this seminar, students will be able to: |
|
- exploit Easytrieve Plus reserved name, reserved call and user defined procedures
- be able to create summary files and summary reports
- understand the virtual file manager and the sort activity
- be able to run Easytrieve Plus programs in interpret mode or compile and linkedit them
- execute Easytrieve Plus jobs online or in batch mode
- perform table lookups and synchronized file processing
- recognize the differences and similarities between instream macros and external macros and the macro library
- inject a range of SQL statements into DB2 from an Easytrieve Plus application program as well as read from and write to VSAM datasets
|
FORMAT: | Lecture, demonstration, boardwork, laboratory experiments, conversation. |
AUDIENCE: |
This seminar is intended for all intermediate Easytrieve Plus
programmers who would like to take their experience with
Easytrieve Plus to the next level.
|
PREREQUISITES: |
Experience with the Easytrieve Plus report writer, and the ISPF
editor and ISPF utilities is required; prior JCL programming
with job submission and retrieval experience is useful.
|
DURATION: | 9 hours. |
|
Easytrieve Plus Introduction and Advanced Combined
Register in the Easytrieve Plus Introduction and Advanced Combined seminar.
|
SEMINAR CODE: | EZTP
|
DESCRIPTION: |
This seminar is designed for programmers who are novices or
intermediate with Easytrieve Plus. All aspects of the basic
Easytrieve Plus report writer facility will be covered. In
addition, special features of Easytrieve Plus will be covered.
File I/O between Easytrieve Plus and a variety of file types
(flat, sequential, partitioned, VSAM, DB2 tables) will be
studied. The macro facility and the external macro libaray will
be scrutinized. Easytrieve Plus jobs will be run online and in
batch. Easytrieve Plus table lookups will be written. When
requested, Easytrieve Plus will be run in interpret mode as well
as compiled and link-edited. The synchronized file processor
will be tested and Easytrieve Plus will be used to perform
various file extracts. Laboratory experiments will present and
explore all interactions between Easytrieve Plus and files and
reports.
|
OBJECTIVES: | Upon completion of this seminar, students will be able to: |
|
- understand the Easytrieve Plus syntax conventions and the layout and the sections of an Easytrieve Plus program
- choose between various Easytrieve Plus report parameters and definition statements
- exploit Easytrieve Plus reserved name, reserved call and user defined procedures
- be able to create summary files and summary reports
- understand the virtual file manager and the sort activity
- be able to run Easytrieve Plus programs in interpret mode or compile and linkedit them
- execute Easytrieve Plus jobs online or in batch mode
- perform table lookups and synchronized file processing
- recognize the differences and similarities between instream macros and external macros and the macro library
- inject a range of SQL statements into DB2 from an Easytrieve Plus application program as well as read from and write to VSAM datasets
|
FORMAT: | Lecture, demonstration, boardwork, laboratory experiments, conversation. |
AUDIENCE: |
This seminar is intended for all novice or intermediate
Easytrieve Plus programmers who would like to learn Easytrieve
Plus or take their experience to the next level.
|
PREREQUISITES: |
Experience with the ISPF editor and ISPF utilities is required;
prior JCL programming with job submission and retrieval
experience is useful.
|
DURATION: | 21 hours. |
|
Easytrieve Plus with DB2
Register in the Easytrieve Plus with DB2 seminar.
|
SEMINAR CODE: | EZTPDB2
|
DESCRIPTION: |
This seminar is designed for programmers who are comfortable
with Easytrieve Plus as well as with DB2 concepts and facilities
and DB2 application programming, and who want to write
application programs for DB2 using Easytrieve Plus as the high
level driver language to inject SQL into DB2. Special attention
will be given to Easytrieve Plus arrays for use as carriers of
parameters passed to DB2, as well as to setting condition codes
in Easytrieve Plus to reflect the result of SQL invocations. A
detailed and searching critique will be given to the differences
and similarities between injecting SQL into DB2 from Easytrieve
Plus and other high level languages eg COBOL. Laboratory
experiments will present and explore all SQL operations as they
interact between Easytrieve Plus and DB2.
|
OBJECTIVES: | Upon completion of this seminar, students will be able to: |
|
- write efficient, readable application programs for DB2 using Easytrieve Plus
- choose between various Easytrieve Plus array types to house data in DB2 application programs
- exploit Easytrieve Plus condition codes as a means to indicate the result of an SQL operation
- recognize the differences and similarities between using Easytrieve Plus and COBOL as the driver language for DB2 application programs
- inject a range of SQL statements into DB2 from an Easytrieve Plus application program
- prepare an Easytrieve Plus DB2 application program for execution ie compile, generate, precompile, assemble, link-edit, and bind
|
FORMAT: | Lecture, demonstration, boardwork, laboratory experiments, conversation. |
AUDIENCE: |
This seminar is intended for all mature Easytrieve Plus
programmers who are already comfortable with DB2 application
programming using a high level language like COBOL.
|
PREREQUISITES: |
Familiarity with Easytrieve Plus application programming and DB2
concepts and facilities and SQL is required; DB2 SQL with COBOL
application programming experience is useful.
|
DURATION: | 12 hours. |
|
Focus Report Writing Introduction
Register in the Focus Report Writing Introduction seminar.
|
SEMINAR CODE: | Focus
|
DESCRIPTION: |
This seminar provides a comprehensive overview of how to use the
native report writing capability of Focus to produce reports.
Participants learn to use functions and features efficiently and
apply Focus to real work tasks, be they on mainframe or on PC
platforms. The seminar addresses tables and basic query verbs
like PRINT, LIST, COUNT, and SUM. The sort phrases BY and ACROSS
are distinguished. Aggregating functions like MAX, MIN, AVG, and
PCT are defined. Record screening and relational operators are
studied. FOCEXECs are created with TED which itself is the
subject of scrutiny. New fields (both temporary and permanent)
are defined. The rules for multiset requests are laid out. Most
of the report formatting options are shown. Many ways of
totalling are looked at including ROW-TOTAL, COLUMN-TOTAL,
SUBTOTAL, SUB-TOTAL, SUMMARIZE, and RECOMPUTE.
|
OBJECTIVES: | Upon completion of this seminar, students will be able to: |
|
- work interactively with Focus to produce ad-hoc reports
- design custom reports
- create reports to be run at regular intervals
- use TableTalk and FileTalk
- construct complex query statements
- perform mathematical functions and define new fields
- construct queries in the TED environment
|
FORMAT: | Lecture, demonstration, boardwork, laboratory experiments, conversation. |
AUDIENCE: |
This seminar is intended for people who must access data and
generate Focus reports on a regular or ad-hoc basis.
|
PREREQUISITES: |
Participants should have basic keyboard familiarity, and know
what kinds of reporting to expect from company data.
|
DURATION: | 18 hours. |
|
Focus Report Writing Advanced
Register in the Focus Report Writing Advanced seminar.
|
SEMINAR CODE: | FocusA
|
DESCRIPTION: |
This seminar is designed for the experienced Focus report writer
who requires advanced Focus reporting techniques to create
difficult reports. The scope of study includes report generation
with file matching and extraction, as well as generation of
highly formatted non-column and matrix reports. The use of Focus
dialog manager to control the execution of reports through menus
is explained. Topics covered include master file descriptions,
SET command options, DEFINEs, IN-GROUPS-OF, extract files, file
matching, joins, dialog manager, screen design, and menus
creation.
|
OBJECTIVES: | Upon completion of this seminar, students will be able to: |
|
- produce very complex reports
- create and use hold files
- understand and avoid problems with file matching
- create and use menus with dialog manager
- join two files
|
FORMAT: | Lecture, demonstration, boardwork, laboratory experiments, conversation. |
AUDIENCE: |
Experienced Focus report writers requiring to create difficult
reports. Both programmers with limited Focus experience or
talented end users can benefit from this seminar.
|
PREREQUISITES: |
Basic Focus report writing skills.
|
DURATION: | 12 hours. |
|
Focus Report Writing Introduction and Advanced Combined
Register in the Focus Report Writing Introduction seminar.
|
SEMINAR CODE: | Focus
|
DESCRIPTION: |
This seminar provides a comprehensive overview of how to use the
native report writing capability of Focus to produce reports.
Participants learn to use functions and features efficiently and
apply Focus to real work tasks, be they on mainframe or on PC
platforms. The seminar addresses tables and basic query verbs
like PRINT, LIST, COUNT, and SUM. The sort phrases BY and ACROSS
are distinguished. Aggregating functions like MAX, MIN, AVG, and
PCT are defined. Record screening and relational operators are
studied. FOCEXECs are created with TED which itself is the
subject of scrutiny. New fields (both temporary and permanent)
are defined. The rules for multiset requests are laid out. Most
of the report formatting options are shown. Many ways of
totalling are looked at including ROW-TOTAL, COLUMN-TOTAL,
SUBTOTAL, SUB-TOTAL, SUMMARIZE, and RECOMPUTE. The scope of
study includes report generation with file matching and
extraction, as well as generation of highly formatted non-column
and matrix reports. The use of Focus dialog manager to control
the execution of reports through menus is explained. Topics
covered include master file descriptions, SET command options,
DEFINEs, IN-GROUPS-OF, extract files, file matching, joins,
dialog manager, screen design, and menus creation.
|
OBJECTIVES: | Upon completion of this seminar, students will be able to: |
|
- work interactively with Focus to produce ad-hoc reports
- design custom reports
- create reports to be run at regular intervals
- use TableTalk and FileTalk
- construct complex query statements
- perform mathematical functions and define new fields
- construct queries in the TED environment
- produce very complex reports
- create and use hold files
- understand and avoid problems with file matching
- create and use menus with dialog manager
- join two files
|
FORMAT: | Lecture, demonstration, boardwork, laboratory experiments, conversation. |
AUDIENCE: |
This seminar is intended for people who must access data and
generate Focus reports on a regular or ad-hoc basis. Both
programmers with limited Focus experience or talented end users
can benefit from this seminar.
|
PREREQUISITES: |
Participants should have basic keyboard familiarity, an aptitude
for programming, and know what kinds of reporting to expect from
company data.
|
DURATION: | 30 hours. |
|
HTML
Register in the HTML seminar.
|
SEMINAR CODE: | HTML
|
DESCRIPTION: |
This seminar is designed for programmers who want to code raw
HTML rather than for those who deploy GUI HTML application
builders like FrontPage, PageMaker, or Dreamweaver. HTML syntax
and conventions are covered. Most of the major tags are
discussed as well their attributes. Attention is given to
creating attractive, uncluttered websites using a variety of
simple tools (eg lists, tables, frames, etc) as well as some
advanced tools (eg client side and server side maps, and
stylesheets). Webpages are tested with a browser like Netscape
Communicator or Internet Explorer in offline mode. Where
applicable, web pages are uploaded and installed on a real
website.
|
OBJECTIVES: | Upon completion of this seminar, students will be able to: |
|
- read and write raw HTML and understand it's syntax
- choose from a variety of HTML tags to create predictable webpage effects
- select a variety of tag attributes to enhance a webpage's ease of legibility and use
- deploy links to other webpages, graphics, sound files, e-mail, and FTP downloads
- format page output with lists and tables
- manipulate frames and framesets
- enhance page display with stylesheets
- create client side and server side image maps
- develop and build eye catching and efficient web sites
|
FORMAT: | Lecture, demonstration, boardwork, laboratory experiments, conversation. |
AUDIENCE: |
This seminar is intended for beginning raw HTML coders and
programmers - GUI HTML applications builders like FrontPage,
PageMaker, and Dreamweaver are covered cursorily but not in
depth.
|
PREREQUISITES: |
Familiarity with Netscape Communicator or Internet Explorer and
an elementary wordprocessor such as Notepad is recommended.
|
DURATION: | 24 hours. |
|
ISPF
Register in the ISPF seminar.
|
SEMINAR CODE: | ISPF
|
DESCRIPTION: |
This seminar distinguishes preliminary computer concepts and
terminology. It outlines what every new TSO/E and ISPF user
needs to know about IBM mainframe computers. This seminar shows
how to logon and logoff a TSO/E session and an ISPF session, how
to use View, Edit, and the standard utilities, and how to
investigate the job queues with SDSF or another queue viewer.
Users will become acquainted with allocating sequential and
partitioned data sets. In editing datasets, experience will be
gained with View and Edit primary commands and prefix line
commands. All the PF key commands and features will be learned
to personalize the PF key preferences. |
OBJECTIVES: | Upon completion of this seminar, students will be able to: |
|
- navigate through ISPF
- set up ISPF defaults
- use basic and advanced View operation
- use basic and advanced Edit operation
- control the Edit profile
- manage utility functions
- exploit DSLIST ie the ISPF [3.4] utility
- differentiate between dataset and library utilities
- run Compare and Search utilities
|
FORMAT: | Lecture, demonstration, boardwork, laboratory experiments, conversation. |
AUDIENCE: |
This seminar is directed toward application developers in a
technical support role in a z/OS MVS environment.
|
PREREQUISITES: |
Familiarity with a keyboard is required.
|
DURATION: | 18 hours. |
|
ISPF Dialog Manager
Register in the ISPF Dialog Manager seminar.
|
SEMINAR CODE: | DM
|
DESCRIPTION: |
ISPF Dialog Manager is an application development and execution
tool with facilities designed to aid in the rapid development of
interactive applications running under the control of ISPF. This
seminar provides an overview of the concepts, facilities and
capabilities of the product and will aid in the determination of
the suitability of the product for use on a given project. This
seminar will present the Dialog Manager as it is used in the
z/OS MVS environment.
|
OBJECTIVES: | Upon completion of this seminar, students will be able to: |
|
- describe the parts of an ISPF dialog and their relationship to one another
- set up an ISPF environment to allow the development, testing and execution of dialogs
- describe the set of services ISPF provides to a dialog
- define a simple dialog manager panel, and use that panel to enter data into and retrieve data from a command procedure
- define messages and tutorials for the panel, and cause them to be displayed at selected times
- define a dialog manager table, and access that table for inquiry and update using dialog table services
- define a simple dialog manager table display panel, and use that panel to display data retrieved from a table
- use a skeleton file to create a tailored JCL stream and submit a job based on panel input
- understand how to adapt dialog manager panels and services to promote pop up panels
- understand how to adapt dialog manager panels to promote the action bar and drop down panels
|
FORMAT: | Lecture, demonstration, boardwork, laboratory experiments, conversation. |
AUDIENCE: |
This seminar is intended for application developers,
programmers, and analysts who work with ISPF and would like to
tailor and customize its appearance and functionality.
|
PREREQUISITES: |
Familiarity with ISPF in the z/OS MVS environment, familiarity
with REXX in the z/OS MVS environment, or familiarity with TSO/E
CLists in the z/OS MVS environment.
|
DURATION: | 24 hours. |
|
JavaScript
Register in the JavaScript seminar.
|
SEMINAR CODE: | JavaScript |
DESCRIPTION: |
This seminar is designed for web page makers who want to learn
the JavaScript programming language and its concepts, and how to
deploy the features built into JavaScript-enabled web browsers
on their web sites. Custom made JavaScript functions will
validate user input to web pages and provide feedback to web
surfers via dialog boxes and alert controls. Participants in
this seminar will distinguish between local and global
variables, JavaScript objects and math objects, and JavaScript
strings and arrays. Clear and attractive web pages will be
designed using frames, windows, and interactive HTML objects.
Testing web pages will be performed with a browser like Netscape
Communicator or Internet Explorer in offline mode. Where
applicable, web pages are uploaded and installed on a real
website.
|
OBJECTIVES: | Upon completion of this seminar, students will be able to: |
|
- understand JavaScript syntax
- code expressions with character string and date features
- manage link properties with JavaScript
- correctly manage the "alert" control
- code JavaScript functions
- enhance the following HTML form controls and their events: text boxes, check boxes, radio buttons, select boxes, control buttons
- deploy JavaScript to add logic to a web page
- understand JavaScript's validation features
- manipulate windows using JavaScript
|
FORMAT: | Lecture, demonstration, boardwork, laboratory experiments, conversation. |
AUDIENCE: |
This seminar is intended for beginning JavaScript coders and
programmers who wish to deploy logic and the features of
JavaScript in JavaScript-enabled web browsers to create
attractive, interactive web pages.
|
PREREQUISITES: |
Familiarity with Netscape Communicator or Internet Explorer and
an elementary wordprocessor such as Notepad is recommended.
Familiarity with HTML is required. Familiarity with programming
concepts, especially with object oriented programming concepts,
is strongly advised.
|
DURATION: | 24 hours. |
|
QMF
Register in the QMF seminar.
|
SEMINAR CODE: | QMF
|
DESCRIPTION: |
This seminar is designed to provide mastery of QMF and to use it
to access relational databases such as DB2. SQL, QBE, and
prompted queries will be reviewed. The REXX language will be
introduced as a driver of QMF Procedures. QMF will be run online
and in batch. QMF objects will be imported and exported.
Extensive experience will be gained in the prudent use of the
QMF report writing facility.
|
OBJECTIVES: | Upon completion of this seminar, students will be able to: |
|
- understand the basic concepts and facilities of QMF
- build queries with SQL, QBE, and prompted query
- construct sophisticated reports with control columns, summary information, headings etc
- run QMF in the foreground or in batch mode
- navigate all of the QMF forms
- construct sophisticated query calling and report writing drivers using the REXX language in QMF procedures
|
FORMAT: | Lecture, demonstration, boardwork, laboratory experiments, conversation. |
AUDIENCE: |
This seminar is designed for data processing and business
professionals who want to use QMF to access, manage, and report
on the information in relational databases such as DB2.
|
PREREQUISITES: |
Familiarity with DB2 concepts and facilities is required.
Experience with SQL, JCL, and batch jobs would be useful but is
not required.
|
DURATION: | 24 hours. |
|
SQL
Register in the SQL seminar.
|
SEMINAR CODE: | SQL
|
DESCRIPTION: |
This seminar is designed for programmers and/or operations
personnel who work with relational databases, and who require an
introductory to intermediate mastery of the SQL language. All
three categories of SQL statements (DDL, DML, and DCL) will be
covered. All basic SQL syntax and parameters will be discussed
and tested. Standards for SQL coding will be incorporated into
extensive laboratory experiments. Datatypes will be explained.
SQL functions to manage (inter alia) dates and strings will be
demonstrated. Authorization and security, as it impacts the
executability of SQL, will be covered. SQL code to join multiple
tables will be scrutinized: unions for joining rows, and inner
and outer joins (left outer join, right outer join, and full
outer join) for joining columns. For interdependent tables,
referential integrity issues and code will be included. In
addition, participants will understand and manage simple
selects, sub-selects, and correlated sub-selects against base
tables and views with ease, with an understanding of the
performance issues pertaining to successful SQL.
|
OBJECTIVES: | Upon completion of this seminar, students will be able to: |
|
- write SQL using approved standards
- recognize the distinctions between DDL, DML, and DCL SQL
- distinguish between various SQL datatypes
- master SQL functions to handle dates, strings, etc
- understand the effects of gathering data from multiple tables at once
- use unions and joins (inner and outer)
- have interdependent tables refer to one another with integrity
- manage simple selects, sub-selects, and correlated sub-selects
- know about the contraints of SQL security
- set up views for restricted or revealing access to tables
- create aggregated and consolidated data reports
- code SQL calls to create, update, and manipulate relational databases
- allow for optimal performance of SQL statements
|
FORMAT: | Lecture, demonstration, boardwork, laboratory experiments, conversation. |
AUDIENCE: |
This seminar is intended for all novice to beginner SQL
programmers.
|
PREREQUISITES: |
Familiarity with basic database concepts is required. Experience
with an SQL injector would be beneficial but is not required.
|
DURATION: | 12 hours. |
|
TSO/E CLists
Register in the TSO/E CLists seminar.
|
SEMINAR CODE: | CList
|
DESCRIPTION: |
This seminar is designed for programmers intending to learn
TSO/E CList in the z/OS MVS environment. Students will study the
TSO/E CList interpreter as a basis for understanding techniques
for writing efficient and readable TSO/E CLists. Templates,
tracing, and interpreting will be reviewed. Generic builtin
functions will be reviewed. During laboratory experiments,
programmers will test TSO/E CLists in a variety of commonplace
application scenarios. Students will learn how to create their
own subroutines. Terminal output will be trapped from z/OS MVS
and TSO/E. Techniques will be presented to manage I/O from the
terminal. z/OS MVS file I/O programs written in TSO/E CList
will be scrutinized and tested in laboratory experiments. During
the seminar students will also gain an increased awareness of
the z/OS MVS environment, will have opportunities to submit
TSO/E CLists to the batch processor for background execution,
and will be introduced to the TSO/E CList interface with the
ISPF Dialog Manager.
|
OBJECTIVES: | Upon completion of this seminar, students will be able to: |
|
- write efficient, readable TSO/E CList code
- choose between various TSO/E CList templates for parsing terminal input
- exploit the TSO/E CList debugging options
- create their own builtin TSO/E CList subroutines
- trap console output from z/OS MVS and TSO/E
- effectively manage terminal I/O
- read, write, and update z/OS MVS datasets
- submit TSO/E CLists to the z/OS MVS batch processor
- understand the basics of the TSO/E CList interface with the ISPF Dialog Manager
|
FORMAT: | Lecture, demonstration, boardwork, laboratory experiments, conversation. |
AUDIENCE: |
This seminar is intended for all programmers intending to master
the TSO/E CList language on the z/OS MVS platform.
|
PREREQUISITES: |
Familiarity with TSO/E, ISPF, and the ISPF Editor is required.
Experience with JCL would be beneficial but is not required.
|
DURATION: | 18 hours. |
|
TSO/E CLists and ISPF Dialog Manager Combined
Register in the TSO/E CLists and ISPF Dialog Manager Combined seminar.
|
SEMINAR CODE: | CListDM
|
DESCRIPTION: |
This seminar is designed for programmers intending to learn
TSO/E CList in the z/OS MVS environment to write drivers for the
ISPF Dialog Manager. Students will study the TSO/E CList
interpreter as a basis for understanding techniques for writing
efficient and readable TSO/E CLists. During laboratory
experiments, programmers will test TSO/E CLists in a variety of
commonplace application scenarios. Techniques will be presented
to manage I/O from the terminal. During the seminar students
will also gain an increased awareness of the z/OS MVS
environment, and will be introduced to the TSO/E CList interface
with the ISPF Dialog Manager.
|
OBJECTIVES: | Upon completion of this seminar, students will be able to: |
|
- write efficient, readable TSO/E CList code
- effectively manage terminal I/O
- understand the basics of the TSO/E CList interface with the ISPF Dialog Manager
- set up an ISPF environment to allow the development, testing and execution of dialogs
- describe the set of services ISPF provides to a dialog
- define a simple dialog manager panel, and use that panel to enter data into and retrieve data from a command procedure
- define messages and tutorials for the panel, and cause them to be displayed at selected times
- define a dialog manager table, and access that table for inquiry and update using dialog table services
- define a simple dialog manager table display panel, and use that panel to display data retrieved from a table
- use a skeleton file to create a tailored JCL stream and submit a job based on panel input
- understand how to adapt dialog manager panels and services to promote pop up panels
- understand how to adapt dialog manager panels to promote the action bar and drop down panels
|
FORMAT: | Lecture, demonstration, boardwork, laboratory experiments, conversation. |
AUDIENCE: |
This seminar is intended for all programmers intending to master
the TSO/E CList language on the z/OS MVS platform to create
drivers for the ISPF Dialog Manager to tailor and customize its
appearance and functionality.
|
PREREQUISITES: |
Familiarity with TSO/E, ISPF, and the ISPF Editor is required.
|
DURATION: | 30 hours. |
|
Visual Basic Introduction
Register in the Visual Basic Introduction seminar.
|
SEMINAR CODE: | VB
|
DESCRIPTION: |
This seminar is designed for programmers who are novices with
Visual Basic or who have a passing acquaintance with it. All
aspects of Visual Basic will be discussed, and laboratory
experiments will be performed with the essential ones. All
primary windows of the Visual Basic desktop will be explored.
The programming environment and visual programming techniques
will be discussed. Almost all of the common controls will be
demonstrated. Syntax for Basic language variables, constants,
and operators will be reviewed. Control structures will be
tested in an environment emphasizing modular programming.
Participants will create their own menus. Visual Basic
applications will be run in test mode and also as executables.
Install diskettes will be created to install Visual Basic
applications which are created in laboratory experiments. File
I/O between Visual Basic applications and a variety of file
types will be reviewed. In addition, a basic introduction to
database access will be given as well as to custom designing
ActiveX controls if requested.
|
OBJECTIVES: | Upon completion of this seminar, students will be able to: |
|
- understand the distinctions between classical programming and object oriented and event driven programming
- know the difference between properties, events, and methods
- be able to use the menu bar, toolbar, toolbox, project explorer, properties window, form designer window, code editor window, and form layout window
- add, name, save, rename, edit, change, and delete Visual Basic objects
- decide when and how best to use list boxes, combo boxes, and control arrays
- declare explicit, implicit, and static variables
- write structured code when required using the essential Basic language control structures
- use builtin Basic language functions and subroutines as well as develop their own
- take advantage of various I/O features of Visual Basic such as InputBox, MsgBox, DriveListBox, DirListBox, FileListBox, and the common dialog control
- code and use menu bar menus and popup menus
- describe and use a variety of coded file I/O statements and techniques
|
FORMAT: | Lecture, demonstration, boardwork, laboratory experiments, conversation. |
AUDIENCE: |
This seminar is intended for all for programmers who are novices
with Visual Basic or who have a passing acquaintance with it who
would like to learn Visual Basic or take their experience to the
next level.
|
PREREQUISITES: |
Desktop experience with Windows is required; prior Basic
language or other language programming experience is useful.
|
DURATION: | 24 hours. |
|
Visual Basic Advanced
Register in the Visual Basic Advanced seminar.
|
SEMINAR CODE: | AVB
|
DESCRIPTION: |
This seminar expands the experience of programmers already
familiar with the Visual Basic product. An extensive series of
programs and solutions to laboratory experiments are provided to
each participant which not only provide insight into the prudent
application of Visual Basic but which can also be adapted and
adjusted to suit regular production work. Topics covered include
interaction with the clipboard, dynamic data exchange, printing,
control arrays, mouse control, advanced commands and functions,
file I/O, introduction to databases, error handling, interfacing
with dynamic link libraries, multiple windows, and advanced
controls.
|
OBJECTIVES: | Upon completion of this seminar, students will be able to: |
|
- manage the interprocess communication used by the clipboard and dynamic data exchange
- print reports and forms by exploiting the printer object and the printers collection
- work with control arrays and be able to write Basic code which maximizes control arrays
- recognize and utilize advantages/disadvantages of the various file I/O techniques (random access, sequential access etc)
- handle Visual Basic's interface to databases, bound controls, and the SQL language
- interface with system dynamic link libraries and exploit DLL calls
- extract useful information from the mouse by exploiting the mouse control
- trap and handle errors which occur during the execution of a Visual Basic application
- exploit applications which utilize multiple windows and share data between multiple windows
- use lesser known controls and functions
|
FORMAT: | Lecture, demonstration, boardwork, laboratory experiments, conversation. |
AUDIENCE: |
Programmers, analysts, managers, and end users who have already
been exposed to Visual Basic and who wish to expand their
experience to the next level.
|
PREREQUISITES: |
Prior exposure to Visual Basic and a grasp of it's essential use
and basic set of controls is required. More than just a passing
familiarity with Windows is assumed.
|
DURATION: | 30 hours. |
|
z/OS MVS JCL and Utilities Introduction
Register in the z/OS MVS JCL and Utilities Introduction seminar.
|
SEMINAR CODE: | JCL
|
DESCRIPTION: |
This seminar provides basic instruction in Job Control Language
as well as the more common z/OS MVS JCL Utilities. Topics
include JES overview, JCL statements and their parameters and
use, JES2 and JES3 statements, syntax and coding rules,
understanding job output listings, SMS parameters, procedures,
condition code testing, referbacks, z/OS MVS IEH and IEB
utilities, IDCAMS utility, and SORT utility.
|
OBJECTIVES: | Upon completion of this seminar, students will be able to: |
|
- code accurate, syntactically correct JCL
- understand the progress of a job through the system
- debug JCL using the JES job listings
- maintain or create production environment JCL
- work with permanent and temporary datasets
- know the new JCL (since MVS/ESA Versions 3 and 4)
- provide data files to programs through JCL
- bypass job steps based on condition code tests
- submit utility jobs with proper control cards
|
FORMAT: | Lecture, demonstration, boardwork, laboratory experiments, conversation. |
AUDIENCE: |
Programmers and technical support personnel who design or
maintain production and development z/OS MVS batch jobs.
|
PREREQUISITES: |
Experience with the ISPF editor and ISPF utilities is required;
prior JCL programming with job submission and retrieval
experience is useful.
|
DURATION: | 30 hours. |
|
z/OS MVS JCL and Utilities Advanced
Register in the z/OS MVS JCL and Utilities Advanced seminar.
|
SEMINAR CODE: | AJCL
|
DESCRIPTION: |
This seminar is designed for programmers and/or operations
personnel who are already familiar with the basics of JCL and
want to know more. The seminar begins with a review of the basic
JCL parameters and moves into additional parameters and
functions of JCL including condition code testing, concatenating
datasets, JES statements, procedures, generation data groups,
and utilities. All of the new JCL (from MVS/ESA Version 3 and
MVS/ESA Version 4) will be studied. Local standards for JCL
coding will be discussed and incorporated into extensive
laboratory experiments.
|
OBJECTIVES: | Upon completion of this seminar, students will be able to: |
|
- code intelligent JCL using approved local standards
- use COND= and the IF statement to test condition codes
- understand the effects of the SMS parameters
- concatenate a series of datasets
- use referbacks in jobs and in procedures
- manage output with the OUTPUT statement
- code JES3 statements to supplement JCL
- create generation data groups using IDCAMS
- write cataloged and instream procedures
- override symbolic values
- restart a job with the RESTART parameter
- write required cards, parameters, and control statements for
the following utilities: IEBGENER, IEBCOPY, IEHMOVE, IEHPROGM, IEFBR14, IDCAMS, SORT
|
FORMAT: | Lecture, demonstration, boardwork, laboratory experiments, conversation. |
AUDIENCE: |
This seminar is intended for all mature JCL programmers who are
already comfortable with basic JCL who are ready to go to the
next level with JCL.
|
PREREQUISITES: |
Familiarity with basic JCL is required. Experience with
utilities would be beneficial but is not required.
|
DURATION: | 18 hours. |
|
z/OS TSO/E REXX Introduction
Register in the z/OS TSO/E REXX Introduction seminar.
|
SEMINAR CODE: | MVSREXX
|
DESCRIPTION: |
This seminar is designed for programmers intending to learn REXX
in the z/OS MVS environment. Students will study the REXX
interpreter as a basis for understanding techniques for writing
efficient and readable REXX code. Templates, tracing, and
interpreting will be reviewed. Generic builtin functions will be
reviewed. During laboratory experiments, students will test REXX
in a variety of commonplace application scenarios. Students will
learn how to create their own subroutines and functions.
Terminal output will be trapped from z/OS MVS and TSO/E.
Techniques will be presented to manage the program stack. z/OS
MVS file I/O programs written in REXX will be scrutinized and
tested in laboratory experiments. During the seminar students
will also gain an increased awareness of the z/OS MVS
environment, and will have opportunities to submit z/OS TSO/E
REXX execs to the batch processor for background execution.
|
OBJECTIVES: | Upon completion of this seminar, students will be able to: |
|
- write efficient, readable REXX code
- choose between various REXX templates for parsing
- exploit INTERPRET and interactive debug TRACE
- create their own builtin REXX functions
- trap console output from z/OS MVS and TSO/E
- effectively manage the program stack
- read, write, and update z/OS MVS datasets
- submit z/OS TSO/E REXX execs to z/OS MVS batch processor
|
FORMAT: | Lecture, demonstration, boardwork, laboratory experiments, conversation. |
AUDIENCE: |
This seminar is intended for all programmers intending to master
the REXX language on the z/OS MVS platform.
|
PREREQUISITES: |
Familiarity with TSO/E, ISPF, and ISPF Editor is required.
Experience with JCL would be beneficial but is not required.
|
DURATION: | 18 hours. |
|
z/OS TSO/E REXX Advanced
Register in the z/OS TSO/E REXX Advanced seminar.
|
SEMINAR CODE: | MREXAdv
|
DESCRIPTION: |
This seminar is designed for programmers who have been using
basic or introductory level REXX in the z/OS MVS environment,
and who wish to expand their experience to the next level.
Students will study the REXX interpreter as a basis for
understanding techniques for writing more efficient and readable
REXX code. Advanced templating, tracing, and interpreting will
be reviewed. The z/OS TSO/E REXX compiler will be deployed if it
is available at the site. Various options of data conversion
will be reviewed. During laboratory experiments the TSO/E search
order will be controlled using the ALTLIB and EXECUTIL z/OS
TSO/E REXX commands. Full screen panels will provide front ends
to z/OS TSO/E REXX execs via the interface with the ISPF Dialog
Manager. Students will learn how to create their own builtin
functions. Terminal output will be trapped from z/OS MVS and
TSO/E. Techniques will be presented to manage the program stack
efficiently. z/OS MVS file I/O and ISPF Edit macros written in
REXX will be scrutinized and tested in laboratory experiments.
During the seminar students will also gain an increased
awareness of the z/OS MVS environment, and will have
opportunities to submit z/OS TSO/E REXX execs to the batch
processor for background execution.
|
OBJECTIVES: | Upon completion of this seminar, students will be able to: |
|
- write efficient, readable REXX code
- choose between various REXX templates for parsing
- exploit INTERPRET and interactive debug TRACE
- compile z/OS TSO/E REXX execs
- convert data from one type to another
- command the search order with ALTLIB and EXECUTIL
- provide ISPF panel front ends to z/OS TSO/E REXX execs
- create their own builtin REXX functions
- trap console output from z/OS MVS and TSO/E
- effectively manage the program stack
- read, write, and update z/OS MVS datasets
- create ISPF Edit macros
- describe sophisticated aspects of the z/OS MVS environemnt
- submit z/OS TSO/E REXX execs to z/OS MVS batch processor
|
FORMAT: | Lecture, demonstration, boardwork, laboratory experiments, conversation. |
AUDIENCE: |
This seminar is intended for all mature z/OS TSO/E REXX
programmers who are already comfortable with z/OS TSO/E REXX and
who intend to take their knowledge and experience of z/OS TSO/E
REXX to the next level.
|
PREREQUISITES: |
Familiarity with z/OS TSO/E REXX, TSO/E, ISPF, and ISPF Editor
is required. Experience with JCL and the ISPF Dialog Manager
would be beneficial but is not required.
|
DURATION: | 18 hours. |
|
z/OS TSO/E REXX Introduction and Advanced Combined
Register in the z/OS TSO/E REXX Introduction and Advanced Combined seminar.
|
SEMINAR CODE: | MREXXIA
|
DESCRIPTION: |
This seminar is designed for programmers intending to learn REXX
in the z/OS MVS environment. Students will study the REXX
interpreter as a basis for understanding techniques for writing
efficient and readable REXX code. Templates, tracing, and
interpreting will be reviewed. Generic builtin functions will be
reviewed. During laboratory experiments, students will test REXX
in a variety of commonplace application scenarios. Students will
learn how to create their own subroutines and functions.
Terminal output will be trapped from z/OS MVS and TSO/E.
Techniques will be presented to manage the program stack. z/OS
MVS file I/O programs written in REXX will be scrutinized and
tested in laboratory experiments. During the seminar students
will also gain an increased awareness of the z/OS MVS
environment, and will have opportunities to submit z/OS TSO/E
REXX execs to the batch processor for background execution.
Advanced templating, tracing, and interpreting will be reviewed.
The z/OS TSO/E REXX compiler will be deployed if it is available
at the site. Various options of data conversion will be
reviewed. During laboratory experiments the TSO/E search order
will be controlled using the ALTLIB and EXECUTIL z/OS TSO/E REXX
commands. Full screen panels will provide front ends to z/OS
TSO/E REXX execs via the interface with the ISPF Dialog Manager.
z/OS MVS file I/O and ISPF Edit macros written in REXX will be
scrutinized and tested in laboratory experiments.
|
OBJECTIVES: | Upon completion of this seminar, students will be able to: |
|
- write efficient, readable REXX code
- choose between various REXX templates for parsing
- exploit INTERPRET and interactive debug TRACE
- create their own builtin REXX functions
- trap console output from z/OS MVS and TSO/E
- effectively manage the program stack
- read, write, and update z/OS MVS datasets
- submit z/OS TSO/E REXX execs to z/OS MVS batch processor
- compile z/OS TSO/E REXX execs
- convert data from one type to another
- command the search order with ALTLIB and EXECUTIL
- provide ISPF panel front ends to z/OS TSO/E REXX execs
- create ISPF Edit macros
|
FORMAT: | Lecture, demonstration, boardwork, laboratory experiments, conversation. |
AUDIENCE: |
This seminar is intended for all programmers intending to master
the REXX language on the z/OS MVS platform, as well as for those
mature z/OS TSO/E REXX programmers who are already comfortable
with z/OS TSO/E REXX and who intend to take their knowledge and
experience of z/OS TSO/E REXX to the next level.
|
PREREQUISITES: |
Familiarity with TSO/E, ISPF, and ISPF Editor is required.
Experience with JCL and the ISPF Dialog Manager would be
beneficial but is not required.
|
DURATION: | 30 hours. |
|
z/OS TSO/E REXX and ISPF Dialog Manager Combined
Register in the z/OS TSO/E REXX and ISPF Dialog Manager Combined seminar.
|
SEMINAR CODE: | MREXXDM
|
DESCRIPTION: |
This seminar is designed for programmers intending to learn REXX
in the z/OS MVS environment to write drivers for the ISPF Dialog
Manager. Students will study the REXX interpreter as a basis for
understanding techniques for writing efficient and readable REXX
code. During laboratory experiments, students will test REXX in
a variety of commonplace application scenarios. During the
seminar students will also gain an increased awareness of the
z/OS MVS environment. Full screen panels will provide front
ends to z/OS TSO/E REXX execs via the interface with the ISPF
Dialog Manager.
|
OBJECTIVES: | Upon completion of this seminar, students will be able to: |
|
- write efficient, readable REXX code
- provide ISPF panel front ends to z/OS TSO/E REXX execs
- effectively manage terminal I/O
- understand the basics of the z/OS TSO/E REXX interface with the ISPF Dialog Manager
- set up an ISPF environment to allow the development, testing and execution of dialogs
- describe the set of services ISPF provides to a dialog
- define a simple dialog manager panel, and use that panel to enter data into and retrieve data from a command procedure
- define messages and tutorials for the panel, and cause them to be displayed at selected times
- define a dialog manager table, and access that table for inquiry and update using dialog table services
- define a simple dialog manager table display panel, and use that panel to display data retrieved from a table
- use a skeleton file to create a tailored JCL stream and submit a job based on panel input
- understand how to adapt dialog manager panels and services to promote pop up panels
- understand how to adapt dialog manager panels to promote the action bar and drop down panels
|
FORMAT: | Lecture, demonstration, boardwork, laboratory experiments, conversation. |
AUDIENCE: |
This seminar is intended for all programmers intending to master
the z/OS TSO/E REXX language on the z/OS MVS platform to create
drivers for the ISPF Dialog Manager to tailor and customize its
appearance and functionality.
|
PREREQUISITES: |
Familiarity with TSO/E, ISPF, and the ISPF Editor is required.
|
DURATION: | 30 hours. |
|