Base dbfgen7.hlp>main Title Test 1 Introducing SQL Anywhere Studio 1 Overview=HELP_TOP_INDEX@dbfgen7.hlp 1 Copyright page =id_fg_3@dbfgen7.hlp>main 2 About This Manual 2 Overview=id_fg_4@dbfgen7.hlp 2 About this Manual =preface@dbfgen7.hlp>main 2 Using this book =id_fg_6@dbfgen7.hlp>main 2 Related books =related-preface@dbfgen7.hlp>main 3 Documentation conventions 3 Overview=documentation-conventions-pref@dbfgen7.hlp 3 Syntax conventions =synconv@dbfgen7.hlp>main 3 Graphic icons =htgi@dbfgen7.hlp>main 2 PART 1. SQL Anywhere Studio Overview 2 Overview=id_fg_11@dbfgen7.hlp 3 CHAPTER 1. Introducing SQL Anywhere Studio 3 Overview=asaintro@dbfgen7.hlp 3 Welcome to SQL Anywhere Studio =welcome-asaintro@dbfgen7.hlp>main 3 Installing SQL Anywhere Studio =software-installation-pref@dbfgen7.hlp>main 3 SQL Anywhere Studio documentation =anywhere-doc-preface@dbfgen7.hlp>main 3 CHAPTER 2. SQL Anywhere Architecture 3 Overview=concepts@dbfgen7.hlp 3 The pieces of a database system =database-concepts@dbfgen7.hlp>main 3 Embedded database architecture =standalone-application-architecture@dbfgen7.hlp>main 3 Client/server architecture =client-application-architecture@dbfgen7.hlp>main 3 Three tier computing architecture =three-tier-architecture@dbfgen7.hlp>main 4 Using multiple databases 4 Overview=multidb-architecture@dbfgen7.hlp 4 Running multiple databases on a single database server =multidb-application-architecture@dbfgen7.hlp>main 4 Accessing data in other databases =remote-access-application-architecture@dbfgen7.hlp>main 4 Comparing Adaptive Server Anywhere and UltraLite 4 Overview=comparing-architecture@dbfgen7.hlp 4 Adaptive Server Anywhere =id_fg_25@dbfgen7.hlp>main 4 UltraLite: the "small fingerprint" database =id_fg_26@dbfgen7.hlp>main 4 Choosing a database =id_fg_27@dbfgen7.hlp>main 3 CHAPTER 3. Running and Connecting to a Database Server 3 Overview=chapter01@dbfgen7.hlp 3 About the database server =about-engines@dbfgen7.hlp>main 4 Starting the sample database 4 Overview=iwstart@dbfgen7.hlp 4 Starting the sample database on Windows operating systems =starting-asademo-win-servertutorial@dbfgen7.hlp>main 4 Starting the sample database on UNIX operating systems =starting-asademo-unix-servertutorial@dbfgen7.hlp>main 4 The database server window =server-window-starting-servertutorial@dbfgen7.hlp>main 3 Connecting to the sample database from Interactive SQL =wlogon@dbfgen7.hlp>main 3 Using ODBC data sources to connect =odbc-servertutorial@dbfgen7.hlp>main 3 Shutting down a database server =shut-down-local-server@dbfgen7.hlp>main 2 PART 2. Getting Results with SQL Anywhere Studio 2 Overview=id_fg_37@dbfgen7.hlp 3 CHAPTER 4. Managing Databases with Sybase Central 3 Overview=scent@dbfgen7.hlp 3 About Sybase Central =scover@dbfgen7.hlp>main 4 Lesson 1: Getting started 4 Overview=lesson-dbxintro@dbfgen7.hlp 4 Start Sybase Central =scmnst@dbfgen7.hlp>main 4 Connect to the sample database from Sybase Central =sccd@dbfgen7.hlp>main 4 Explore the database schema =scic@dbfgen7.hlp>main 4 Lesson 2: Create and edit tables 4 Overview=id_fg_44@dbfgen7.hlp 4 Create a table and column in Sybase Central =scaet@dbfgen7.hlp>main 4 Edit existing tables using the Table Editor =id_fg_46@dbfgen7.hlp>main 4 Lesson 3: Add and delete columns 4 Overview=id_fg_47@dbfgen7.hlp 4 Add a column =id_fg_48@dbfgen7.hlp>main 4 Delete tables =scdt@dbfgen7.hlp>main 4 Lesson 4: View and edit procedures 4 Overview=scap@dbfgen7.hlp 4 Use the Sybase Central Code Editor =scvp@dbfgen7.hlp>main 4 Edit a procedure =id_fg_52@dbfgen7.hlp>main 4 Lesson 5: Manage users and groups 4 Overview=scmu@dbfgen7.hlp 4 Add a group to the sample database =scaug@dbfgen7.hlp>main 4 Add a user to the database =scau@dbfgen7.hlp>main 4 Add a user to a group =scauug@dbfgen7.hlp>main 3 Lesson 6: Back up your database =scbu@dbfgen7.hlp>main 3 Restore the sample database =id_fg_58@dbfgen7.hlp>main 4 Summary 4 Overview=id_fg_59@dbfgen7.hlp 4 Where do I go from here? =id_fg_60@dbfgen7.hlp>main 3 CHAPTER 5. Designing Databases with PowerDesigner 3 Overview=sqlmodeler@dbfgen7.hlp 3 About PowerDesigner =what-sqlmodeler@dbfgen7.hlp>main 4 Lesson 1: Getting Started 4 Overview=id_fg_63@dbfgen7.hlp 4 Reverse engineer the database =id_fg_64@dbfgen7.hlp>main 3 Lesson 2: Add a column =id_fg_65@dbfgen7.hlp>main 3 Lesson 3: Check your work =id_fg_66@dbfgen7.hlp>main 3 Lesson 4: Save changes and generate database =id_fg_67@dbfgen7.hlp>main 4 Summary 4 Overview=id_fg_68@dbfgen7.hlp 4 Where do I go from here? =id_fg_69@dbfgen7.hlp>main 3 CHAPTER 6. Building a Dynamic Web Site with PowerDynamo 3 Overview=dynatut@dbfgen7.hlp 4 About PowerDynamo 4 Overview=id_fg_71@dbfgen7.hlp 4 Beyond HTML: Dynamic content =id_fg_72@dbfgen7.hlp>main 4 Lesson 1: Getting started 4 Overview=id_fg_73@dbfgen7.hlp 4 Create an ODBC data source for the Web site =id_fg_74@dbfgen7.hlp>main 4 Create a connection profile =id_fg_75@dbfgen7.hlp>main 3 Lesson 2: Create a PowerDynamo Personal Web Server mapping =id_fg_76@dbfgen7.hlp>main 4 Lesson 3: Create a template 4 Overview=id_fg_77@dbfgen7.hlp 4 About embedded queries and formatting =id_fg_78@dbfgen7.hlp>main 4 Create the Employees template with an embedded query =id_fg_79@dbfgen7.hlp>main 4 View the output =id_fg_80@dbfgen7.hlp>main 4 Lesson 4: Improve the template 4 Overview=id_fg_81@dbfgen7.hlp 4 Refine the HTML and the formatting =id_fg_82@dbfgen7.hlp>main 4 Save changes to the database and reload the URL =id_fg_83@dbfgen7.hlp>main 4 Lesson 5: Working with DynaScript 4 Overview=id_fg_84@dbfgen7.hlp 4 About DynaScript =id_fg_85@dbfgen7.hlp>main 4 Add DynaScript to the template =id_fg_86@dbfgen7.hlp>main 4 Pass an argument to a template =id_fg_87@dbfgen7.hlp>main 3 Lesson 6: Working with forms =id_fg_88@dbfgen7.hlp>main 4 Summary 4 Overview=id_fg_89@dbfgen7.hlp 4 Where do I go from here? =id_fg_90@dbfgen7.hlp>main 3 CHAPTER 7. Replicating Data with SQL Remote 3 Overview=remote@dbfgen7.hlp 3 About SQL Remote =about-remote@dbfgen7.hlp>main 4 Lesson 1: Getting Started 4 Overview=lesson1-remote@dbfgen7.hlp 4 Create directories for the tutorial =id_fg_94@dbfgen7.hlp>main 4 Lesson 2: Set up the consolidated database 4 Overview=lesson2-remote@dbfgen7.hlp 4 Add a SQL Remote message type =add-let-s-remote@dbfgen7.hlp>main 4 Add the publisher to the database =add-pub-remote@dbfgen7.hlp>main 4 Add a remote user to the database =addremoteuser-remote@dbfgen7.hlp>main 4 Add publications and subscriptions =add-pubsandsubs-remote@dbfgen7.hlp>main 4 Lesson 3: Set up the remote database 4 Overview=lesson3-remote@dbfgen7.hlp 4 Create the remote database =id_fg_101@dbfgen7.hlp>main 4 Verify that the database is created properly =verify-db-remote@dbfgen7.hlp>main 4 Lesson 4: Replicate data 4 Overview=lesson4-remote@dbfgen7.hlp 4 Add data to the consolidated database =add-datatocons-remote@dbfgen7.hlp>main 4 Verify that the data has arrived =verify-data-remote@dbfgen7.hlp>main 4 Replicate from the remote database to the consolidated database =replicate-fromatob-remote@dbfgen7.hlp>main 4 Lesson 5: Restore the database and database settings 4 Overview=lesson5-remote@dbfgen7.hlp 4 Restore the data in the database =restore-data-remote@dbfgen7.hlp>main 4 Summary 4 Overview=id_fg_109@dbfgen7.hlp 4 Where do I go from here? =id_fg_110@dbfgen7.hlp>main 3 CHAPTER 8. Adaptive Server Anywhere Synchronization Using MobiLink 3 Overview=synchtutorial@dbfgen7.hlp 3 About MobiLink =about-mobilink@dbfgen7.hlp>main 4 Lesson 1: Create the consolidated database 4 Overview=id_fg_113@dbfgen7.hlp 5 Create a SQL file for the consolidated database 5 Overview=creating-consolidated-synchtutorial@dbfgen7.hlp 5 Explanation of the sample code =id_fg_115@dbfgen7.hlp>main 4 Build the consolidated database =id_fg_116@dbfgen7.hlp>main 4 Lesson 3: Create the remote database 4 Overview=id_fg_117@dbfgen7.hlp 4 Create a template and site for synchronization =id_fg_118@dbfgen7.hlp>main 4 Create the remote database =id_fg_119@dbfgen7.hlp>main 4 Lesson 3: Synchronize the databases 4 Overview=synchronizing-running-synchtutorial@dbfgen7.hlp 4 Synchronize the databases =id_fg_121@dbfgen7.hlp>main 4 Modify the remote database =id_fg_122@dbfgen7.hlp>main 4 Upload changes =upload-running-synchtutorial@dbfgen7.hlp>main 4 Summary 4 Overview=summary-mobilink@dbfgen7.hlp 4 Where do I go from here? =id_fg_125@dbfgen7.hlp>main 3 CHAPTER 9. Creating Reports with InfoMaker 3 Overview=infomaker@dbfgen7.hlp 3 About InfoMaker =id_fg_127@dbfgen7.hlp>main 3 Lesson 1: Getting Started =id_fg_128@dbfgen7.hlp>main 4 Lesson 2: Create a basic report 4 Overview=lesson-lesson-infomaker@dbfgen7.hlp 4 Create a report =id_fg_130@dbfgen7.hlp>main 4 Preview your report =id_fg_131@dbfgen7.hlp>main 4 Save the report =id_fg_132@dbfgen7.hlp>main 4 Set up the design environment =id_fg_133@dbfgen7.hlp>main 4 Lesson 3: Enhance your report 4 Overview=id_fg_134@dbfgen7.hlp 4 Define sorting and grouping =id_fg_135@dbfgen7.hlp>main 4 Enhance the report =id_fg_136@dbfgen7.hlp>main 4 Summary 4 Overview=id_fg_137@dbfgen7.hlp 4 Where do I go from here? =id_fg_138@dbfgen7.hlp>main 2 PART 3. Appendixes 2 Overview=id_fg_139@dbfgen7.hlp 3 APPENDIX A. Supported Platforms 3 Overview=platforms@dbfgen7.hlp 4 Introduction 4 Overview=introduction-platforms@dbfgen7.hlp 4 Key to the tables =key-introduction-platforms@dbfgen7.hlp>main 3 Adaptive Server Anywhere supported operating systems =asa-platforms@dbfgen7.hlp>main 4 MobiLink supported operating systems 4 Overview=mobilink-platforms@dbfgen7.hlp 4 MobiLink synchronization consolidated databases =consoldb-mobilink-platforms@dbfgen7.hlp>main 3 Replication Agent supported operating systems =replication-agent-platforms@dbfgen7.hlp>main 3 SQL Remote supported operating systems =sql-remote-platforms@dbfgen7.hlp>main 4 UltraLite supported operating systems 4 Overview=ultralite-platforms@dbfgen7.hlp 4 Supported host platforms =id_fg_149@dbfgen7.hlp>main 4 Supported target platforms =id_fg_150@dbfgen7.hlp>main