IBM Systems Magazine, Mainframe digital edition - September/October 2009 - (Page 48) Developer With XML, developers can add new elements to the structure without making database changes, which is more flexible than files because the record length constrains the file structure. Some developers define a record length longer than their application requires to support future enhancements. With XML being stored in DB2, data-type limits are the only constraining factor. Another flexibility feature with XML is not all documents must be defined with the same elements. If you’re a database administrator (DBA), you may not think of this as a feature, but for business analyst and developers it provides flexibility for changing business requirements. A couple of employees are listed as an example in Code Sample 1. The first employee with empid 1000 contains element phone-nbr and the second employee with empid 2000 doesn’t have a phone-nbr. What if the requirement is to ensure every employee has a work and home phone number listed, and optionally a cell-phone number? With COBOL you’d have a repeating group to hold the maximum number of phone numbers. With DB2 you’d have a fixed set of columns on a row to support this, or you’d have a relationship with another table that contains a row for each phone type that an employee has. With both files and DB2 you must have business logic in the application to enforce the requirements. This is simplified with XML through a data type definition (DTD) or XML schema definition (XSD). Code Sample 3 <xs:element DTD Versus XSD The XML language seen in the sample doesn’t suppor t structure enforcement. The DTD schema language was developed to validate and enforce the XML document structure. The DTD defines the document structure with a list of elements and attributes. The DTD was an important step toward defining a family of documents being shared between data producers and data consumers. Code Sample 2 (below) is an example of a DTD for the employee document. Code Sample 2 name=”batteries” nillable=”true” minOccurs=”0” maxOccurs=”unbounded”> 48 SEPTEMBER/OCTOBER 2009 ibmsystemsmag.com/mainframe http://www.ibmsystemsmag.com/mainframe Table of Contents for the Digital Edition of IBM Systems Magazine, Mainframe digital edition - August/September 2009 IBM Systems Magazine, Mainframe digital edition - August/September 2009 Editor's Desk: IBM Makes it Easy to be Green Focus on Storage: System z, DS8000 and Tivoli Provide a Complete Encryption Package Trends: CICS Transaction Server 4.1 Helps Organizations, Compete, Comply and Control Case Study: Transzap Consolidates its Oracle Databases in a Virtualized Linux on Mainframe Environment Cover Story: IBM Poughkeepsie Green Data Center Showcases a Dynamic Infrastructure Feature: IBM Study Reveals the System z10 Provides a Cheaper, Easier-to-Manage Cloud Solution Feature: Women in IT Team Up to Succeed Developer: Process XML Documents Within COBOL and DB2 SSDs Are Integral to Enterprise Storage Infrastructures Product News Advertiser Index Stop Run: Gordon Bruce Talks His Way Into a High-Profile IT Gig Reference Point 2010 Mainframe Buyer's Guide IBM Systems Magazine, Mainframe digital edition - August/September 2009 IBM Systems Magazine, Mainframe digital edition - August/September 2009 - (Page Intro) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - IBM Systems Magazine, Mainframe digital edition - August/September 2009 (Page Cover1) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - IBM Systems Magazine, Mainframe digital edition - August/September 2009 (Page Cover2) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - IBM Systems Magazine, Mainframe digital edition - August/September 2009 (Page 1) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - IBM Systems Magazine, Mainframe digital edition - August/September 2009 (Page 2) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - IBM Systems Magazine, Mainframe digital edition - August/September 2009 (Page 3) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - IBM Systems Magazine, Mainframe digital edition - August/September 2009 (Page 4) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - IBM Systems Magazine, Mainframe digital edition - August/September 2009 (Page 5) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - IBM Systems Magazine, Mainframe digital edition - August/September 2009 (Page 6) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - IBM Systems Magazine, Mainframe digital edition - August/September 2009 (Page 7) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Editor's Desk: IBM Makes it Easy to be Green (Page 8) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Editor's Desk: IBM Makes it Easy to be Green (Page 9) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Focus on Storage: System z, DS8000 and Tivoli Provide a Complete Encryption Package (Page 10) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Focus on Storage: System z, DS8000 and Tivoli Provide a Complete Encryption Package (Page 11) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Focus on Storage: System z, DS8000 and Tivoli Provide a Complete Encryption Package (Page 12) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Focus on Storage: System z, DS8000 and Tivoli Provide a Complete Encryption Package (Page 13) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Focus on Storage: System z, DS8000 and Tivoli Provide a Complete Encryption Package (Page 14) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Focus on Storage: System z, DS8000 and Tivoli Provide a Complete Encryption Package (Page 15) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Trends: CICS Transaction Server 4.1 Helps Organizations, Compete, Comply and Control (Page 16) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Trends: CICS Transaction Server 4.1 Helps Organizations, Compete, Comply and Control (Page 17) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Trends: CICS Transaction Server 4.1 Helps Organizations, Compete, Comply and Control (Page 18) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Trends: CICS Transaction Server 4.1 Helps Organizations, Compete, Comply and Control (Page 19) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Trends: CICS Transaction Server 4.1 Helps Organizations, Compete, Comply and Control (Page 20) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Trends: CICS Transaction Server 4.1 Helps Organizations, Compete, Comply and Control (Page 21) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Case Study: Transzap Consolidates its Oracle Databases in a Virtualized Linux on Mainframe Environment (Page 22) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Case Study: Transzap Consolidates its Oracle Databases in a Virtualized Linux on Mainframe Environment (Page 23) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Case Study: Transzap Consolidates its Oracle Databases in a Virtualized Linux on Mainframe Environment (Page 24) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Case Study: Transzap Consolidates its Oracle Databases in a Virtualized Linux on Mainframe Environment (Page 25) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Case Study: Transzap Consolidates its Oracle Databases in a Virtualized Linux on Mainframe Environment (Page 26) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Case Study: Transzap Consolidates its Oracle Databases in a Virtualized Linux on Mainframe Environment (Page 27) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Cover Story: IBM Poughkeepsie Green Data Center Showcases a Dynamic Infrastructure (Page 28) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Cover Story: IBM Poughkeepsie Green Data Center Showcases a Dynamic Infrastructure (Page 29) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Cover Story: IBM Poughkeepsie Green Data Center Showcases a Dynamic Infrastructure (Page 30) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Cover Story: IBM Poughkeepsie Green Data Center Showcases a Dynamic Infrastructure (Page 31) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Cover Story: IBM Poughkeepsie Green Data Center Showcases a Dynamic Infrastructure (Page 32) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Cover Story: IBM Poughkeepsie Green Data Center Showcases a Dynamic Infrastructure (Page 33) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Cover Story: IBM Poughkeepsie Green Data Center Showcases a Dynamic Infrastructure (Page 34) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Cover Story: IBM Poughkeepsie Green Data Center Showcases a Dynamic Infrastructure (Page 35) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Feature: IBM Study Reveals the System z10 Provides a Cheaper, Easier-to-Manage Cloud Solution (Page 36) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Feature: IBM Study Reveals the System z10 Provides a Cheaper, Easier-to-Manage Cloud Solution (Page 37) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Feature: IBM Study Reveals the System z10 Provides a Cheaper, Easier-to-Manage Cloud Solution (Page 38) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Feature: IBM Study Reveals the System z10 Provides a Cheaper, Easier-to-Manage Cloud Solution (Page 39) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Feature: IBM Study Reveals the System z10 Provides a Cheaper, Easier-to-Manage Cloud Solution (Page 40) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Feature: IBM Study Reveals the System z10 Provides a Cheaper, Easier-to-Manage Cloud Solution (Page 41) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Feature: Women in IT Team Up to Succeed (Page 42) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Feature: Women in IT Team Up to Succeed (Page 43) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Feature: Women in IT Team Up to Succeed (Page 44) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Feature: Women in IT Team Up to Succeed (Page 45) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Developer: Process XML Documents Within COBOL and DB2 (Page 46) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Developer: Process XML Documents Within COBOL and DB2 (Page 47) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Developer: Process XML Documents Within COBOL and DB2 (Page 48) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Developer: Process XML Documents Within COBOL and DB2 (Page 49) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - SSDs Are Integral to Enterprise Storage Infrastructures (Page 50) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - SSDs Are Integral to Enterprise Storage Infrastructures (Page 51) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - SSDs Are Integral to Enterprise Storage Infrastructures (Page 52) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - SSDs Are Integral to Enterprise Storage Infrastructures (Page 53) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Product News (Page 54) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Advertiser Index (Page 55) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Stop Run: Gordon Bruce Talks His Way Into a High-Profile IT Gig (Page 56) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Stop Run: Gordon Bruce Talks His Way Into a High-Profile IT Gig (Page 57) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Stop Run: Gordon Bruce Talks His Way Into a High-Profile IT Gig (Page 58) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Stop Run: Gordon Bruce Talks His Way Into a High-Profile IT Gig (Page Cover3) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Stop Run: Gordon Bruce Talks His Way Into a High-Profile IT Gig (Page Cover4) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Reference Point (Page RF1) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - Reference Point (Page RF2) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BGCover1) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BGCover2) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG1) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG2) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG3) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG4) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG5) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG6) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG7) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG8) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG9) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG10) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG11) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG12) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG13) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG14) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG15) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG16) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG17) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG18) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG19) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG20) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG21) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG22) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG23) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG24) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG25) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG26) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG27) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG28) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG29) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG30) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG31) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG32) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG33) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG34) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG35) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG36) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG37) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG38) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG39) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BG40) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BGCover3) IBM Systems Magazine, Mainframe digital edition - August/September 2009 - 2010 Mainframe Buyer's Guide (Page BGCover4) http://www.nxtbookMEDIA.com
For optimal viewing of this digital publication, please enable JavaScript and then refresh the page. If you would like to try to load the digital publication without using Flash Player detection, please click here.