public java.lang.String getInfo(java.lang.String pPropertyName)
Generic method that returns generic information about the current task. The list of available information is described in the pPropertyName values table.
Parameter |
Type |
Description |
---|---|---|
pPropertyName |
String |
String containing the name of the requested property. |
The following table lists the different values possible for pPropertyName :
Parameter value |
Description |
---|---|
I_SRC_SET |
Internal identifier of the current Source Set if the task belongs to a Loading Knowledge Module |
SRC_SET_NAME |
Name of the current Source Set if the task belongs to a Loading Knowledge Module |
COLL_NAME |
Name of the current loading resource (C$) if the task belongs to a Loading Knowledge Module |
INT_NAME |
Name of the current integration resource (I$) if the task belongs to a string Loading, Integration or Check Knowledge Module. |
ERR_NAME |
Name of the current error resource (E$) if the task is part of a Loading, Integration or Check Knowledge Module |
TARG_NAME |
Name of the target resource if the task is part of a Loading, Integration or Check Knowledge Module |
SRC_CATALOG |
Name of the data catalog in the source environment |
SRC_SCHEMA |
Name of the data schema in the source environment |
SRC_WORK_CATALOG |
Name of the work catalog in the source environment |
SRC_WORK_SCHEMA |
Name of the work schema in the source environment |
DEST_CATALOG |
Name of the data catalog in the target environment |
DEST_SCHEMA |
Name of the data schema in the target environment |
DEST_WORK_CATALOG |
Name of the work catalog in the target environment |
DEST_WORK_SCHEMA |
Name of the work schema in the target environment |
SRC_TECHNO_NAME |
Name of the source technology |
SRC_CON_NAME |
Name of the source connection |
SRC_DSERV_NAME |
Name of the data server of the source machine |
SRC_CONNECT_TYPE |
Connection type of the source machine |
SRC_IND_JNDI |
JNDI URL flag |
SRC_JAVA_DRIVER |
Name of the JDBC driver of the source connection |
SRC_JAVA_URL |
JDBC URL of the source connection |
SRC_JNDI_AUTHENT |
JNDI authentication type |
SRC_JNDI_PROTO |
JNDI source protocol |
SRC_JNDI_FACTORY |
JNDI source Factory |
SRC_JNDI_URL |
Source JNDI URL |
SRC_JNDI_RESSOURCE |
Accessed source JNDI resource |
SRC_USER_NAME |
User name of the source connection |
SRC_ENCODED_PASS |
Encrypted password of the source connection |
SRC_FETCH_ARRAY |
Size of the source array fetch |
SRC_BATCH_UPDATE |
Size of the source batch update |
SRC_EXE_CHANNEL |
Execution canal of the source connection |
SRC_COL_ALIAS_WORD |
Term used to separated the columns from their aliases for the source technology |
SRC_TAB_ALIAS_WORD |
Term used to separated the tables from their aliases for the source technology |
SRC_DATE_FCT |
Function returning the current date for the source technology |
SRC_DDL_NULL |
Returns the definition used for the keyword NULL during the creation of a table on the source |
SRC_MAX_COL_NAME_LEN |
Maximum number of characters for the column name on the source technology |
SRC_MAX_TAB_NAME_LEN |
Maximum number of characters for the table name on the source technology |
SRC_REM_OBJ_PATTERN |
Substitution model for a remote object on the source technology. |
SRC_LOC_OBJ_PATTERN |
Substitution model for a local object name on the source technology. |
DEST_TECHNO_NAME |
Name of the target technology |
DEST_CON_NAME |
Name of the target connection |
DEST_DSERV_NAME |
Name of the data server of the target machine |
DEST_CONNECT_TYPE |
Connection type of the target machine |
DEST_IND_JNDI |
Target JNDI URL flag |
DEST_JAVA_DRIVER |
Name of the JDBC driver of the target connection |
DEST_JAVA_URL |
JDBC URL of the target connection |
DEST_JNDI_AUTHENT |
JNDI authentication type of the target |
DEST_JNDI_PROTO |
JNDI target protocol |
DEST_JNDI_FACTORY |
JNDI target Factory |
DEST_JNDI_URL |
JNDI URL of the target |
DEST_JNDI_RESSOURCE |
Target JNDI resource that is accessed |
DEST_USER_NAME |
Name of the user for the target connection |
DEST_ENCODED_PASS |
Encrypted password for the target connection |
DEST_FETCH_ARRAY |
Size of the target array fetch |
DEST_BATCH_UPDATE |
Size of the target batch update |
DEST_EXE_CHANNEL |
Execution canal of the target connection |
DEST_COL_ALIAS_WORD |
Term used to separate the columns from their aliases on the target technology |
DEST_TAB_ALIAS_WORD |
Term used to separate the tables from their aliases on the target technology |
DEST_DATE_FCT |
Function returning the current date on the target technology |
DEST_DDL_NULL |
Function returning the definition used for the keyword NULL during the creation on a table on the target |
DEST_MAX_COL_NAME_LEN |
Maximum number of characters of the column in the target technology |
DEST_MAX_TAB_NAME_LEN |
Maximum number of characters of the table name on the target technology |
DEST_REM_OBJ_PATTERN |
Substitution model for a remote object on the target technology |
DEST_LOC_OBJ_PATTERN |
Substitution model for a local object name on the target technology |
CT_ERR_TYPE |
Error type (F: Flow, S: Static). Applies only in the case of a Check Knowledge Module |
CT_ERR_ID |
Error identifier (Table # for a static control or interface number for flow control. Applies only in the case of a Check Knowledge Module |
CT_ORIGIN |
Name that identifies the origin of an error (Name of a table for static control, or name of an interface prefixed with the project code). Applies only in the case of a Check Knowledge Module |
JRN_NAME |
Name of the journalized datastore. |
JRN_VIEW |
Name of the view linked to the journalized datastore. |
JRN_DATA_VIEW |
Name of the data view linked to the journalized datastore. |
JRN_TRIGGER |
Name of the trigger linked to the journalized datastore. |
JRN_ITRIGGER |
Name of the Insert trigger linked to the journalized datastore. |
JRN_UTRIGGER |
Name of the Update trigger linked to the journalized datastore. |
JRN_DTRIGGER |
Name of the Delete trigger linked to the journalized datastore. |
SUBSCRIBER_TABLE |
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. |
SRC_DEF_CATALOG |
Default catalog for the source data server. |
SRC_DEF_SCHEMA |
Default schema for the source data server. |
SRC_DEFW_CATALOG |
Default work catalog for the source data server. |
SRC_DEFW_SCHEMA |
Default work schema for the source data server. |
DEST_DEF_CATALOG |
Default catalog for the target data server. |
DEST_DEF_SCHEMA |
Default schema for the target data server. |
DEST_DEFW_CATALOG |
Default work catalog for the target data server. |
DEST_DEFW_SCHEMA |
Default work schema for the target data server. |
SRC_LSCHEMA_NAME |
Source logical schema name. |
DEST_LSCHEMA_NAME |
Target logical schema name. |
The current source connection is: <%=odiRef.getInfo("SRC_CON_NAME")%>
on server: <%=odiRef.getInfo("SRC_DSERV_NAME")%>