SAP Knowledge Base Article - Public

1202108 - Does Crystal Reports XI support the use of 'CurrentSchema' property within JDBC connections to DB2?

Symptom

Does Crystal Reports XI support the use of the CurrentSchema property within the JDBC connection to IBM DB2 version 8 and 9?

Resolution

Crystal Reports XI uses the CurrentSchema property in JDBC connection strings to make the connection.

Note: If the CurrentSchema is provided within the connection URL (for example, jdbc:db2://server:portNum/dbname:CurrentSchema=SchemaName;) Crystal Reports XI will ignore the specific schema name and retrieve all schemas from the system table.

Keywords

Connection URL, Connection string, Current Schema, Schema name, JDBC, IBM, DB2 , 5928976 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

SAP Crystal Reports XI ; SAP Crystal Reports XI R2