User manual BUSINESS OBJECTS CONNECTION SERVER XI 3.1 DATA ACCESS GUIDE

[. . . ] Data Access Guide BusinessObjects Connection Server XI 3. 1 Copyright © 2008 Business Objects, an SAP company. patents, which may cover products that are offered and licensed by Business Objects: 5, 295, 243; 5, 339, 390; 5, 555, 403; 5, 590, 250; 5, 619, 632; 5, 632, 009; 5, 857, 205; 5, 880, 742; 5, 883, 635; 6, 085, 202; 6, 108, 698; 6, 247, 008; 6, 289, 352; 6, 300, 957; 6, 377, 259; 6, 490, 593; 6, 578, 027; 6, 581, 068; 6, 628, 312; 6, 654, 761; 6, 768, 986; 6, 772, 409; 6, 831, 668; 6, 882, 998; 6, 892, 189; 6, 901, 555; 7, 089, 238; 7, 107, 266; 7, 139, 766; 7, 178, 099; 7, 181, 435; 7, 181, 440; 7, 194, 465; 7, 222, 130; 7, 299, 419; 7, 320, 122 and 7, 356, 779. Business Objects and its logos, BusinessObjects, Business Objects Crystal Vision, Business Process On Demand, BusinessQuery, Cartesis, Crystal Analysis, Crystal Applications, Crystal Decisions, Crystal Enterprise, Crystal Insider, Crystal Reports, Crystal Vision, Desktop Intelligence, Inxight and its logos , LinguistX, Star Tree, Table Lens, ThingFinder, Timewall, Let There Be Light, Metify, NSite, Rapid Marts, RapidMarts, the Spectrum Design, Web Intelligence, Workmail and Xcelsius are trademarks or registered trademarks in the United States and/or other countries of Business Objects and/or affiliated companies. SAP is the trademark or registered trademark of SAP AG in Germany and in several other countries. [. . . ] · language is specified in ISO-639 standard · country is specified in ISO-3166 standard For example: en_US for English United States. If this setting is not specified, Connection Server retrieves the information from the database middleware. Values Default Max Rows Available <Parameter Name="Max Rows Available">True</Parameter> Description Specifies if the driver supports the Max Rows function to limit the maximum number of rows that can be retrieved from a datasource. 82 Data Access Guide SBO parameter reference Default SBO parameters 6 True: The driver supports the Max Rows function . False Default Optimize Execute <Parameter Name="Optimize Execute">False</Parameter> Description Specifies whether or not Connection Server optimizes the execution of SQL queries. True: specifies that where possible, SQL queries are optimized on execution. False: SQL queries are not optimized for execution. Values Default False Owners Available <Parameter Name="Owners Available">True</Parameter> Description Specifies whether or not Owners are supported by the target database. Data Access Guide 83 6 SBO parameter reference Default SBO parameters True: Specifies that owners are supported by the target database. Values False: Specifies that owners are not supported by the target database. Not specified: value retrieved from the database middleware. Default Password Encryption <Parameter Name="Password Encryption">True</Parameter> Description Specifies whether or not to use the encryption password mechanism specified in the middleware for the password entered in the Connection details dialog box. True: Specifies that the encryption password mechanism of the middleware is used. Values False: Specifies that the encryption password mechanism of the middleware is not used. Default True Procedure Name Max Size <Parameter Name="Procedure Name Max Size">1024</Parameter> 84 Data Access Guide SBO parameter reference Default SBO parameters 6 Description Specifies the maximum length in characters of a database procedure name. An integer that specifies the maximum database procedure name length in characters. The value set in the database middleware. Values Default Procedure Parameter Name Max Size <Parameter Name="Procedure Parameter Name Max Size">1024</Pa rameter> Description Specifies the maximum length in characters of a database procedure parameter name. An integer that specifies the maximum database procedure parameter name length in characters. The value set in the database middleware. Values Default Qualifiers Available <Parameter Name="Qualifiers Available">True</Parameter> Description Specifies whether or not Qualifiers are supported. Data Access Guide 85 6 SBO parameter reference Default SBO parameters True: Specifies that Qualifiers are supported. Connection Server retrieves this information from the database middleware. Default Query TimeOut Available <Parameter Name="Query TimeOut Available">True</Parameter> Description Specifies whether or not Query TimeOut is supported by the database middleware, that is if a query that is running can be cancelled after a time period has expired. True: Specifies that Query TimeOut is supported by the database middleware . Values False: Specifies that Query TimeOut is not supported by the database middleware . Default False Quoted Identifier Case <Parameter Name="Quoted Identifier Case Available">True</Param eter> 86 Data Access Guide SBO parameter reference Default SBO parameters 6 Description Specifies how the database treats the case of quoted identifiers. UpperCase: quoted identifiers must be in upper case. Values MixedCase: quoted identifiers can be in mixed case. Connection Server retrieves the information from the middleware. Default Schema Name Max Size <Parameter Name="Schema Name Max Size">1024</Parameter> Description Specifies the maximum length in characters of the database schema name. An integer that specifies the maximum database schema name length in characters. The value set in the database middleware. Values Default Shared Connection <Parameter Name="Shared Connection">True</Parameter> Data Access Guide 87 6 SBO parameter reference Default SBO parameters Description Specifies whether or not the requested connection of a connection pool is shared. Is not taken into account if the Max Pool Time parameter of cs. cfg is set to 0. True: the connection is shared. Values False: the connection is not shared. [. . . ] · Documentation from the products Online help and guides in Adobe PDF format are available from the product Help menus. Where only online help is provided, the online help file contains the entire contents of the PDF version of the guide. · Documentation on the web The full electronic documentation set is available to customers on the web from support website at: http://service. sap. com/bosap-support. · Documentation on the product CD Look in the docs directory of your product CD for versions of guides in Adobe PDF format. Send us your feedback Do you have a suggestion on how we can improve our documentation? [. . . ]