getCatalogName() Method

Usage

public java.lang.String getCatalogName(
java.lang.String pLogicalSchemaName, 
java.lang.String pLocation)

public java.lang.String getCatalogName(
java.lang.String pLogicalSchemaName, 
java.lang.String pContextCode, 
java.lang.String pLocation)

public java.lang.String getCatalogName(
java.lang.String pLocation)

public java.lang.String getCatalogName()

 

Description

Allows you to retrieve the name of a physical data catalog or work catalog, from its logical schema.

If the first syntax is used, the returned catalog name matches the current context.

If the second syntax is used,  the returned catalog name is that of the context specified in the pContextCode parameter.

The third syntax returns the name of the data catalog (D) or work catalog (W) for the current logical schema in the current context.

The fourth syntax returns the name of the data catalog (D) for the current logical schema in the current context.

Parameters

Parameter

Type

Description

pLogicalSchemaName

String

Name of the logical schema

pContextCode

String

Code of the enforced context of the schema

pLocation

String

"W"

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

"D"

Returns the data catalog of the physical schema corresponding 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

that you have associated with this physical schema: MSSQL_ODI in the context CTX_DEV

The call to 

Returns

<%=odiRef.getCatalogName("MSSQL_ODI", "CTX_DEV", "W")%>

tempdb

<%=odiRef.getCatalogName("MSSQL_ODI", "CTX_DEV", "D")%>

db_odi