Corporation Video Gaming Accessories User Manual

viii
Tuning............................................................................................................................................... 8-10
XML................................................................................................................................................... 8-10
Migration Considerations.................................................................................................................... 8-11
Security Considerations ....................................................................................................................... 8-11
Setting Design Time Security ........................................................................................................ 8-12
Setting Runtime Security................................................................................................................ 8-12
Transaction Support.............................................................................................................................. 8-13
A Advanced Tuning of the Metadata
Metadata for the IMS/DB Data Source ............................................................................................... A-1
General Tab........................................................................................................................................ A-2
Columns Tab...................................................................................................................................... A-3
Column Definition Section ....................................................................................................... A-4
Column Properties..................................................................................................................... A-5
Indexes Tab ........................................................................................................................................ A-7
Table Information ...................................................................................................................... A-7
Properties .................................................................................................................................... A-8
Statistics Tab....................................................................................................................................... A-8
Generating Statistics ................................................................................................................ A-10
Advanced Tab.................................................................................................................................. A-11
Adapter Metadata.................................................................................................................................. A-13
Adapter Metadata General Properties......................................................................................... A-13
Adapter Metadata Interactions ..................................................................................................... A-15
Interaction Advanced Tab ...................................................................................................... A-16
Adapter Metadata Schema Records ............................................................................................. A-18
Adapter Metadata XML ................................................................................................................. A-20
B Back-end Adapter Data Type Support
Data Type Mapping ................................................................................................................................ B-1
C Advanced Tuning of the Daemon
Control....................................................................................................................................................... C-1
Logging...................................................................................................................................................... C-3
Security..................................................................................................................................................... C-5
Workspaces ............................................................................................................................................... C-7
General................................................................................................................................................ C-7
Server Mode..................................................................................................................................... C-11
Security ............................................................................................................................................. C-16
D Supported SQL Syntax and SQL Enhancements
Supported SQL Statements ................................................................................................................... D-1
Supported Operators .............................................................................................................................. D-1
Supported Functions............................................................................................................................... D-2
SQL Enhancements................................................................................................................................. D-3
Generating Hierarchical Results ..................................................................................................... D-3
Accessing Hierarchical Data Using SQL........................................................................................ D-4