public java.lang.String getSchemaName(
java.lang.String pLogicalSchemaName,
java.lang.String pLocation)
public java.lang.String getSchemaName(
java.lang.String pLogicalSchemaName,
java.lang.String pContextCode,
java.lang.String pLocation)
public java.lang.String getSchemaName(
java.lang.String pLocation)
public java.lang.String getSchemaName()
Retrieves the physical name of a data schema or work schema from its logical schema.
If the first syntax is used, the returned schema corresponds to the current context.
If the second syntax is used, the returned schema corresponds to context specified in the pContextCode parameter.
The third syntax returns the name of the data schema (D) or work schema (W) for the current logical schema in the current context.
The fourth syntax returns the name of the data schema (D) for the current logical schema in the current context.
Parameter |
Type |
Description | ||||
---|---|---|---|---|---|---|
pLogicalSchemaName |
String |
Name of the logical schema of the schema | ||||
pContextCode |
String |
Forced context of the schema | ||||
pLocation |
String |
|
If you have defined the physical schema:
Pluton.db_odi.dbo
Data catalog: |
db_odi |
Data schema: |
dbo |
Work catalog: |
tempdb |
Work schema: |
temp_owner |
and you have associated this physical schema to the logical schema: MSSQL_ODI in the context CTX_DEV
The call to |
Returns |
---|---|
<%=odiRef.getSchemaName("MSSQL_ODI", "CTX_DEV", "W")%> |
temp_owner |
<%=odiRef.getSchemaName("MSSQL_ODI", "CTX_DEV", "D")%> |
dbo |