Client Load Metamodel Class Property Descriptions
Property Names and Relative Property IDs are defined in CLcreateaim.h.
|
Property Name |
Description |
Property |
Type |
Size |
|
VersionId |
ID identifying a particular instance of the execution of this Client Load script |
1 |
Short |
|
|
ScriptQualifier |
Identification information for this script on the origin system |
2 |
String |
255 |
|
OutputFileName |
Name of this script’s output file |
3 |
String |
255 |
|
LoadUtility |
Client Load Utility that this script is for |
4 |
String |
30 |
|
SessCharSet |
The character set used by this script session |
5 |
String |
30 |
|
ScriptLevelDDLUsed |
String list of non-Target related DDL statements executed in the script |
6 |
String |
255 |
|
ProcessorTime |
Amount of processor time used during the execution of this script |
7 |
String |
25 |
|
HighestReturnCode |
The highest return code produced during the execution of this script |
8 |
Short |
|
|
CompletionStatus |
Status of the script’s execution |
9 |
String |
10 |
|
StartTime |
Time when the execution of the script started (HH:MM:SS) |
10 |
String |
8 |
|
StartDate |
Date when the execution of the script started (“YYYY-MM-DD”) |
11 |
Date |
|
|
EndTime |
Time when the execution of the script ended (HH:MM:SS) |
12 |
String |
8 |
|
EndDate |
Date when the execution of the script ended (“YYYY-MM-DD”) |
13 |
Date |
|
|
Property Name |
Description |
Property |
Type |
Size |
|
SourceType |
Type of the input data source |
1 |
String |
30 |
|
INMODRoutine |
Name of the INMOD routine that is preprocessing the input data from this source |
2 |
String |
255 |
|
StartRecordRange |
Record number of the first input record to be processed |
3 |
Integer |
|
|
EndRecordRange |
Record number of the last input record to be processed |
4 |
Integer |
|
|
RecordFormat |
Format of the input records |
5 |
String |
11 |
|
IndicatorBits |
Indicates whether Indicator Bits are present in the input records |
6 |
String |
3 |
|
Property Name |
Description |
Property |
Type |
Size |
|
DataType |
Data type of the source field |
1 |
String |
15 |
|
DataLength |
Data length of the source field |
2 |
Short |
|
|
RecLayoutName |
Name of the record layout definition where this source field is defined |
3 |
String |
30 |
|
Property Name |
Description |
Property |
Type |
Size |
|
TargetType |
Type of the target |
1 |
String |
30 |
|
TargetSystemName |
Name of the target system |
2 |
String |
256 |
|
TargetDatabaseName |
Name of the target database |
3 |
String |
128 |
|
TargetLevelDDLUsed |
String list of DDL statements executed against the target |
4 |
String |
255 |
|
TargetLevelDMLUsed |
String list of DML statements executed against the target |
5 |
String |
255 |
|
NbrRecordsRead |
Number of input records read |
6 |
Integer |
|
|
NbrRecsSentToTD |
Number of input records sent to the Teradata Database |
7 |
Integer |
|
|
NbrRecordsDeleted |
Number of records deleted from the target |
8 |
Integer |
|
|
NbrRecordsInserted |
Number of records inserted into the target |
9 |
Integer |
|
|
NbrRecordsSkipped |
Number of input records skipped |
10 |
Integer |
|
|
NbrRecordsUpdated |
Number of records updated in the target |
11 |
Integer |
|
|
NbrErrorsTbl1 |
Number of error records in error table #1 |
12 |
Integer |
|
|
NbrErrorsTbl2 |
Number of error records in error table #2 |
13 |
Integer |
|