getTargetTable() Method

Usage

public java.lang.String getTargetTable(java.lang.String pPropertyName)

Description

Generic method that returns general information on the current target table. The list of available data is described in the pPropertyName values table.

In an action, this method returns information on the table being processed by the DDL command.

Parameters

Parameter

Type

Description

pPropertyName

String

String that contains the name of the requested property.

pPropertyName values

The following table lists the possible values for pPropertyName:

Parameter value

Description

I_TABLE

Internal identifier of the datastore

MODEL_NAME

Name of the model of the current datastore.

SUB_MODEL_NAME

Name of the sub-model of the current datastore.

TECHNO_NAME

Name of the target technology.

LSCHEMA_NAME

Name of the target logical schema.

TABLE_NAME

Name of the target datastore.

RES_NAME

Physical name of the target resource.

CATALOG

Catalog name.

WORK_CATALOG

Name of the work catalog.

SCHEMA

Schema name

WORK_SCHEMA

Name of the work schema.

TABLE_ALIAS

Alias of the current datastore.

TABLE_TYPE

Type of the datastore.

DESCRIPTION

Description of the current interface.

TABLE_DESC

Description of the current interface's target datastore. For a DDL command, description of the current table.

R_COUNT

Number of lines of the current datastore.

FILE_FORMAT

Format of the current datastore (file)

FILE_SEP_FIELD

Field separator (file)

XFILE_SEP_FIELD

Hexadecimal field separator (file)

SFILE_SEP_FIELD

Field separator string (file)

FILE_ENC_FIELD

Field beginning and ending character (file)

FILE_SEP_ROW

Record separator (file)

XFILE_SEP_ROW

Hexadecimal record separator (file)

SFILE_SEP_ROW

Record separator string (file)

FILE_FIRST_ROW

Number of lines to ignore at the beginning of the file (file)

FILE_DEC_SEP

Decimal symbol (file)

METADATA_DESC

Description of the metadata of the datastore (file)

OLAP_TYPE

OLAP type specified in the datastore definition

IND_JRN

Flag indicating that the datastore is including in CDC.

JRN_ORDER

Order of the datastore in the CDC set for consistent journalizing.

TABLE_DESC

Description (comment) of the table. The quotes and double quotes are replaced by spaces.

WS_NAME

Data Services - Name of the Web service generated for this datastore's model.

WS_NAMESPACE

Data Services - XML namespace of the web Service.

WS_JAVA_PACKAGE

Data Services - Java package generated for the web Service.

WS_ENTITY_NAME

Data Services - Entity name used for this datastore in the web service.

WS_DATA_SOURCE

Data Services - Datasource specified for this datastore's web service.

<flexfield code>

Flexfield value for the current table.

Examples

The current table is: <%=odiRef.getTargetTable("RES_NAME")%>