|
|
|
|
|
z/OS Data – Strategies to Extend Your Investment
|
|
 Frank C. Fillmore Jr., is founder and principal of The Fillmore Group, Inc., an IBM Information Management software sales and consulting firm. Frank has been assisting clients worldwide with DB2 on all platforms for 20 years. He and his team work closely with IBM’s services divisions and Business Partners to ensure the delivery of expert DB2 services. An authorized IBM DB2 instructor and popular speaker, Frank is a regular presenter at DB2 technical conferences and local users groups, as well as IDUG North America and Europe. He is a DB2 Gold Consultant.
Mountains of data remain locked in IMS and VSAM on z/OS. In this session, attendees will learn about tools that allow organizations to:
- Migrate VSAM data to DB2 on z/OS without re-writing applications.
- Access IMS and VSAM data in place using the SQL API from Linux and Windows programs.
See how alternative technologies like CICS VSAM Transparency (VT) and Information Integrator Classic Federation (IICF) open up non-relational data to the enterprise for web-enabled application development and data warehousing.
Platform: z/OS
|
|
|
Intermediate DB2 SQL
|
 BL "Tink" Tysor is an experienced Consultant and Educator for Database Administration, SQL development and Relational Data Modeling with over 34 years of computer experience. Tink has concentrated on DB2 Universal Database for z/OS and LUW since 1994, and has been involved in every aspect of Database Management from Conceptual, Logical and Physical Data Modeling, database creation and maintenance, SQL generation and reviews, SQL Routines development through performance tuning, security, and data recovery. The Intermediate SQL class will ease the novice SQL coder into fully understanding SQL features and terminology so that the students are not overwhelmed in the Advanced SQL class. Specifically, simple SELECTs, WHERE clauses, simple joins, subqueries, table expressions, and CASE expressions as well as, scalar functions. Emphasis will be on converting business syntax into SELECT statements.
CASE Expressions
- Simple
- Searched
- CASE within a CASE
- Scalar
ADD_MONTHS, CEIL, CHAR, COALESCE/VALUE, CCSID_ENCODING, CONCAT, DATE, DAY, DAYOFMONTH, DAYOFWEEK, DAYOFWEEK_ISO, DAYOFYEAR, DAYS, DEC, DIGITS, FLOOR, HOUR, IDENTITY_VAL_LOCAL(), IFNULL, INSERT, INTEGER, JULIAN_DAY, LCASE/LOWER, LEFT, LENGTH, LTRIM, LAST_DAY, MAX, MICROSECOND, MIN, MINUTE, MOD, MONTH, MULTILPLY_ALT, NEXT_DAY, NULLIF, POSSTR, POWER, QUARTER, RAISE_ERROR, RAND, REPEAT, REPLACE, RIGHT, ROUND, ROUND_TIMESTAMP, RTRIM, SECOND, SMALLINT, SPACE, STRIP, SUBSTR, TIME, TIMESTAMP, TIMESTAMP_FORMAT, TRANSLATE, TRUNC, TRUNC_TIMESTAMP, UCASE,VARCHAR, VARCHAR_TIMESTAMP/TO_CHAR , WEEK, YEAR
- Character
- Numeric
- Chronological
- Common
- NULL
- Large Object
- SUM
- AVG
- MIN
- MAX
- COUNT, COUNT_BIG
- STDDEV, STDDEV_POP
- VAR, VAR_SAMP
3. Joins
- INNER
- LEFT &RIGHT OUTER
- FULL OUTER
4. Sub-queries
- Non-Correlated Sub-Queries
- Correlated Sub-Queries
5. Nested Table Expressions
- Basics
- For Outer Joins
- Separate Work
- Time Period Reports
|
|
|
IBM - XML on DB2 to the Max
|
|
David Majcher is an IBM Consulting Software IT Specialist working in Chicago. He joined IBM in May of 2000. Prior to joining IBM he worked for several Chicago land companies and distributed z/OS DBA. He currently supports all the Data Management products for Linux, Unix and Windows in a presales technical role.
 If you are an IT Professional and would like to discover the following about XML;
What is a well formed document?
Why do I need to know XML?
What is the difference between DTD and XML Schemas?
What is native and enabled XML?
Then this workshop is for you. If you are new to XML as a DBA or an applications programmer this workshop will help you understand the basics about XML. If you know XML already but need to know more about native XML with DB2 version 9 or just curious about XML then you will also benefit from attending.
This workshop will give you technical presentation with live demos showing you how easy DB2 XML version 9 scan span the spectrum from an applications perspective to a DBA structured approach.
AGENDA Introductions
Objective
Why XML
XML history
XML Concepts
XML terms
Anatomy of an XML Document
Create and store an XML Document
Native XML with DB2
Performance
Tooling
XPATH/XQUERY/SQL
|
|
|
|
|
|
|
