public java.lang.String getSchemaNameDefaultPSchema(
java.lang.String pLogicalSchemaName,
java.lang.String pLocation)
public java.lang.String getSchemaNameDefaultPSchema(
java.lang.String pLogicalSchemaName,
java.lang.String pContextCode,
java.lang.String pLocation)
public java.lang.String getSchemaNameDefaultPSchema(
java.lang.String pLocation)
public java.lang.String getSchemaNameDefaultPSchema()
Allows you to retrieve the name of the default physical data schema or work schema for the data server to which is associated the physical schema corresponding to the tuple (logical schema, context). If no context is specified, the current context is used. If no logical schema name is specified, then the current logical schema is used. If no pLocation is specified, then the data schema is returned.
Parameter |
Type |
Description | ||||
---|---|---|---|---|---|---|
pLogicalSchemaName |
String |
Name of the logical schema | ||||
pContextCode |
String |
Code of the enforced context of the schema | ||||
pLocation |
String |
|
If you have defined the physical schemas:
Pluton.db_odi.dbo
Data catalog: |
db_odi |
Data schema: |
dbo |
Work catalog: |
tempdb |
Work schema: |
temp_odi |
Default Schema |
Yes |
that you have associated with this physical schema: MSSQL_ODI in the context CTX_DEV, and Pluton.db_doc.doc
Data catalog: |
db_doc |
Data schema: |
doc |
Work catalog: |
tempdb |
Work schema: |
temp_doc |
Default Schema |
No |
that you have associated with this physical schema: MSSQL_DOC in the context CTX_DEV
The call to |
Returns |
---|---|
<%=odiRef.getSchemaNameDefaultPSchema("MSSQL_DOC", "CTX_DEV", "W")%> |
temp_odi |
<%=odiRef.getSchemaNameDefaultPSchema("MSSQL_DOC", "CTX_DEV", "D")%> |
dbo |