Getting started with Adobe Flex

SQL Procedure Language (SQL PL) is used in DB2 to write database-stored procedures. Stored procedures are used to encapsulate business logic on the database and yield the following significantly improved application performance, increased application scalability, simplified application development, and reduced network traffic. This book will teach the reader how to set up the development environment and use all language elements of SQL PL through concrete examples and thorough discussions. Also included are expert tips and best practices for achieving optimal performance and code manageability. This book will be a valuable reference for SQL PL code syntax and troubleshooting. There are currently no books on the market that cover the DB2 SQL Procedure Language, although it is extensively used by IBM business partners and other software vendors. How is this book structured?......Page 14 What’s next?......Page 15 About the Authors......Page 17 Acknowledgements......Page 19 1.1 A brief history of Adobe Flex......Page 20 1.2 Pros and cons of Flex applications......Page 25 1.3.2 Adobe Flex Builder 3......Page 26 1.4.1 Developer Resources......Page 27 1.5.1 Adobe Flex and HTML/JavaScript/Ajax......Page 28 1.5.4 Adobe Flex and Java Server Faces (JSF)......Page 29 1.7 Review questions......Page 30 2.1 Installing Flex: The big picture......Page 32 2.2.2 Installing Flex Builder......Page 33 2.3 Launching Flex Builder......Page 38 2.4.1 Building and running the "Hello Flex" application......Page 40 2.4.2 Debugging the Flex application......Page 50 2.7 Review questions......Page 53 3.1 MXML and ActionScript – the Big Picture......Page 55 3.2.1 XML......Page 57 3.2.2 Anatomy of an XML tag......Page 58 3.3.1 Inline ActionScript......Page 59 3.3.3 ActionScript Variables and data types......Page 60 3.3.4 ActionScript Classes and Objects......Page 61 3.3.5 Functions and Access modifiers......Page 63 3.3.6 [Bindable] Tag......Page 64 3.3.7 MXML and ActionScript mapping......Page 65 3.3.8 Events......Page 67 3.4 Exercises......Page 69 3.6 Review Questions......Page 72 4.1 Working with Flex components: The big picture......Page 75 4.2 Components......Page 78 4.3.1 Application containers......Page 79 4.3.2 Layout containers......Page 80 4.3.3 Navigation containers......Page 81 4.4.1 Text-based controls......Page 83 4.4.2 Basic controls......Page 85 4.4.4 Data-driven controls......Page 89 4.5 Exercises......Page 90 4.7 Review questions......Page 94 5.1 Data binding – The big picture......Page 97 5.2.2 ActionScript expressions in curly braces ({})......Page 98 5.2.4 Bindings in ActionScript......Page 99 5.3.1 Array......Page 100 5.3.3 XMLList......Page 101 5.3.4 Flex data management classes......Page 102 5.4 Data Driven UI Controls......Page 103 5.4.1 Scrolling List controls......Page 104 5.4.2 DataGrid control......Page 106 5.4.3 AdvancedDataGrid control......Page 107 5.4.4 Hierarchical Data Controls......Page 109 5.5 Item renderer controls......Page 111 5.5.2 Inline item renderer......Page 112 5.7 Review questions......Page 113 6.1 Working with view states, transitions and filters: The big picture......Page 115 6.2.1 Creating States......Page 116 6.2.2 State properties, style and events......Page 120 6.2.3 Adding components......Page 121 6.3.1 Common Effects......Page 122 6.3.2 Using Effects......Page 123 6.4 Transitions......Page 124 6.4.2 Using Action Effects......Page 125 6.5 Filters......Page 126 6.5.2 Applying Filters......Page 127 6.6 Exercises......Page 128 6.8 Review questions......Page 134 7.1 Working with the server: The big picture......Page 137 7.2 Working with Web services......Page 138 7.2.3 The ResultEvent object......Page 140 7.2.9 The tag......Page 141 7.2.10 Sample Application......Page 142 7.3.1 The tag......Page 144 7.4 Using HTTPService......Page 145 7.4.2 The send ( ) method......Page 146 7.4.5 Sample application that uses HTTPService......Page 147 7.4.7 Using the E4X Format......Page 149 7.5.1 Sample Flex application accessing a DB2 database......Page 150 7.6.1 Exercise 1 - Obtaining weather forecast information......Page 171 7.6.2 Exercise 2 - Desktop application to translate text......Page 175 7.8 Review questions......Page 178 8.1 Flex Charting: The big picture......Page 181 8.2.2 Bar Chart [BarChart]......Page 182 8.2.8 Line Chart [LineChart]......Page 183 8.2.10 Plot Chart [PlotChart]......Page 184 8.3 Column chart example......Page 185 8.4 Bar chart example......Page 186 8.5 Line chart example......Page 187 8.6 Area chart example......Page 189 8.7 Pie chart example......Page 190 8.8.2 Stacking......Page 192 8.9 Exercises......Page 193 8.10 Review questions......Page 197 Appendix A – Solutions to review questions......Page 201 B.1 DB2: The big picture......Page 211 B.3 Installing DB2......Page 214 B.4.1 Control Center......Page 215 B.4.2 Command Line Tools......Page 217 B.5 The DB2 environment......Page 220 B.7 Connecting to a database......Page 222 B.8 Basic sample programs......Page 223 B.9 DB2 documentation......Page 225 References......Page 227 Web sites......Page 229 Contact emails......Page 232

The Easy, Visual Guide to IBM DB2 V8.2

IBM DB2 Universal Database™ V8.2 for Linux®, UNIX®, and Windows® is a flexible, scalable, cost-effective, and easy-to-use enterprise database. Now, one book makes DB2 even easier. Understanding DB2 teaches DB2 V8.2 visually, step by step, with dozens of examples and case studies drawn from the authors' unsurpassed experience as DB2 consultants at IBM.

Understanding DB2 doesn't just present the big picture. It thoroughly introduces every DB2 concept, procedure, and tool you'll need to get results as an administrator, user, or developer. You'll find authoritative coverage of installation, configuration, objects, database instances, storage, connectivity, security, performance, backup and recovery, SQL fundamentals, and much more. Virtually every new concept is explained with screenshots, diagrams, or tables, all designed to help you learn faster and remember more.

For those preparing for certification, this book also contains over a hundred sample questions crafted by the authors to reflect the content and format of the IBM DB2 UDB Database Administration Certification exams, with answers and detailed explanations.

Coverage includes

• Understanding the DB2 product family, DB2 commands, and the DB2 environment

• Configuring client and server connectivity: walkthroughs of four typical scenarios

• Managing DB2 storage: partitions, tablespaces, buffer pools, and more

• Leveraging the power of SQL: queries, inserts, deletes, and updates

• Implementing security: encryption, authentication, and authorization

• Administering and maintaining data, from LOADand EXPORT to backup/recovery

• Providing high availability with online split mirroring and suspended I/O

• DB2 architecture: process and memory models

• Managing database performance and troubleshooting

The Easy, Visual Way to Master IBM® DB2 for Linux®, UNIX®, and Windows® - Fully Updated for Version 9.5 IBM DB2 9 and DB2 9.5 provide breakthrough capabilities for providing Information on Demand, implementing Web services and Service Oriented Architecture, and streamlining information management. Understanding DB2: Learning Visually with Examples, Second Edition, is the easiest way to master the latest versions of DB2 and apply their full power to your business challenges. Written by four IBM DB2 experts, this book introduces key concepts with dozens of examples drawn from the authors' experience working with DB2 in enterprise environments. Thoroughly updated for DB2 9.5, it covers new innovations ranging from manageability to performance and XML support to API integration. Each concept is presented with easy-to-understand screenshots, diagrams, charts, and tables. This book is for everyone who works with DB2: database administrators, system administrators, developers, and consultants. With hundreds of well-designed review questions and answers, it will also help professionals prepare for the IBM DB2 Certification Exams 730, 731, or 736. Coverage includes Choosing the right version of DB2 for your needs Installing and configuring DB2 Understanding the DB2 environment, instances, and databases Establishing client and server connectivity Working with database objects Utilizing breakthrough pureXML technology, which provides for nativeXML support Mastering administration, maintenance, performance optimization, troubleshooting, and recovery Understanding improvements in the DB2 process, memory, and storage models Implementing effective database security Leveraging the power of SQL and XQuery The Easy, Visual Way to Master IBM® DB2 for Linux®, UNIX®, and Windows®—Fully Updated for Version 9.5 IBM DB2 9 and DB2 9.5 provide breakthrough capabilities for providing Information on Demand, implementing Web services and Service Oriented Architecture, and streamlining information management. Understanding DB2: Learning Visually with Examples, Second Edition, is the easiest way to master the latest versions of DB2 and apply their full power to your business challenges. Written by four IBM DB2 experts, this book introduces key concepts with dozens of examples drawn from the authors'experience working with DB2 in enterprise environments. Thoroughly updated for DB2 9.5, it covers new innovations ranging from manageability to performance and XML support to API integration. Each concept is presented with easy-to-understand screenshots, diagrams, charts, and tables. This book is for everyone who works with DB2: database administrators, system administrators, developers, and consultants. With hundreds of well-designed review questions and answers, it will also help professionals prepare for the IBM DB2 Certification Exams 730, 731, or 736. Coverage includes Choosing the right version of DB2 for your needs Installing and configuring DB2 Understanding the DB2 environment, instances, and databases Establishing client and server connectivity Working with database objects Utilizing breakthrough pureXMLTM technology, which provides for nativeXML support Mastering administration, maintenance, performance optimization, troubleshooting, and recovery Understanding improvements in the DB2 process, memory, and storage models Implementing effective database security Leveraging the power of SQL and XQuery Covers all language elements of DB2 SQL procedure language with an abundance of examples and detailed explanations. Includes expert tips and best practices derived from experiences with real customers. From the specialists at the IBM Toronto Lab.