getTable() Method

Usage

public java.lang.String getTable(
java.lang.String pMode, 
java.lang.String pProperty, 
java.lang.String pLocation) 

public java.lang.String getTable(
java.lang.String pProperty, 
java.lang.String pLocation) 

public java.lang.String getTable(
java.lang.String pProperty) 

Description

Allows the retrieval of the full name of temporary and permanent tables handled by odi.

Parameters

Parameter

Type

Description

pMode

String

"L" uses the local object mask to build the complete path of the object. This value is used when pMode is not specified.

"R" uses the object mask to build the complete path of the object

"A" Automatic. Defines automatically the adequate mask to use.

pProperty

String

Parameter that indicates the name of the table to be built. The list of possible values is provided hereafter:

Parameter value

Description

ID

Datastore identifier.

TARG_NAME

Full name of the target datastore. In actions, this parameter returns the name of the current table handled by the DDL command

COLL_NAME

Full name of the loading datastore.

INT_NAME

Full name of the integration datastore.

ERR_NAME

Full name of the error datastore.

CHECK_NAME

Name of the error summary datastore.

CT_NAME

Full name of the checked datastore.

FK_PK_TABLE_NAME

Full name of the datastore referenced by a Foreign Key

JRN_NAME

Full name of the journalized datastore.

JRN_VIEW

Full name of the view linked to the journalized datastore.

JRN_DATA_VIEW

Full name of the data view linked to the journalized datastore.

JRN_TRIGGER

Full name of the trigger linked to the journalized datastore.

JRN_ITRIGGER

Full name of the Insert trigger linked to the journalized datastore.

JRN_UTRIGGER

Full name of the Update trigger linked to the journalized datastore.

JRN_DTRIGGER

Full name of the Delete trigger linked to the journalized datastore.

SUBSCRIBER_TABLE

Full name of the datastore containing the subscribers list.

CDC_SET_TABLE

Full name of the table containing list of CDC sets.

CDC_TABLE_TABLE

Full name of the table containing the list of tables journalized through CDC sets.

CDC_SUBS_TABLE

Full name of the table containing the list of subscribers to CDC sets.

CDC_OBJECTS_TABLE

Full name of the table containing the journalizing parameters and objects.

<flexfield code>

Flexfield value for the current target table.

 

pLocation

String

"W"

Returns the full name of the object in the physical catalog and the physical work schema that corresponds to the current tuple (context, logical schema)

"D"

Returns the full name of the object in the physical catalog and the physical data schema that corresponds to the current tuple (context, logical schema).

"A"

Lets odi determine the default location of the object. This value is used if pLocation is not specified.

Examples

If you have defined the following elements:

 physical schema: Pluton.db_odi.dbo

Data catalog:

db_odi

Data schema:

dbo

Work catalog:

tempdb

Work schema:

temp_owner

Local Mask:

%CATALOG.%SCHEMA.%OBJECT

Remote mask: 

%DSERVER:%CATALOG.%SCHEMA.%OBJECT

Loading prefix:

CZ_

Error prefix:

ERR_

Integration prefix: 

I$_

and you have associated this physical schema to the logical schema: MSSQL_ODI in your context CTX_DEV

and you table is named CUSTOMER

A call to 

Returns

<%=odiRef.getTable("L", "COLL_NAME", "W")%>

tempdb.temp_owner.CZ_0CUSTOMER

<%=odiRef.getTable("R", "COLL_NAME", "D")%>

MyServer:db_odi.dbo.CZ_0CUSTOMER

<%=odiRef.getTable("L", "INT_NAME", "W")%>

tempdb.temp_owner.I$_CUSTOMER

<%=odiRef.getTable("R", "ERR_NAME", "D")%>

MyServer:db_odi.dbo.ERR_CUSTOMER