getSchemaName() Method

Usage

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()

Description

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.

Parameters

Parameter

Type

Description

pLogicalSchemaName

String

Name of the logical schema of the schema

pContextCode

String

Forced context of the schema

pLocation

String

"W"

Returns the work schema of the physical schema that corresponds to the tuple (context, logical schema)

"D"

Returns the data schema of the physical schema that corresponds to the tuple (context, logical schema)

Examples

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