Profiler Object:Enumeration Listing and Parsing

From Melissa Data Wiki
Revision as of 19:47, 23 February 2015 by Admin (talk | contribs)
Jump to navigation Jump to search

← Profiler Object Reference

Profiler Object Interface Navigation
Initialization
Object Information
Enumeration Listing and Parsing
Column Specification
Initiate Profiling
Data Input
Profiling
Table-Based Statistics
Column-Based Statistics
Column-Based String Statistics
Column-Based Numeric Statistics
Column-Based Date/Time Statistics
Column-Based Name Statistics
Column-Based State/Province Statistics
Column-Based Zip/Postal Code Statistics
Column-Based Country Statistics
Column-Based Email Statistics
Column-Based Phone Statistics
Frequency Iterators
Column-Based Value Frequency Table Iteration
Column-Based Value Length Frequency Table Iteration
Column-Based Value Pattern Table Iteration
Column-Based Value Date/Time Table Iteration
Column-Based Value SoundEx Table Iteration
Column-Based Word Table Iteration
Column-Based Word Length Table Iteration
Result Codes
Profiler Object Result Codes
Result Codes


These functions are largely used by enterprise client applications to poll enumerators and result codes. For example, a GUI product author may opt to not to use a hard-coded list of column types, and rather retrieve a list of valid column types from the object itself. This provides some amount of upward compatibility, as new column types can be added to the object without requiring the developers to update and rebuild their applications.

GetColumnTypeEnum

This function returns all Column Type enumerations. This returns a comma delimited list of the numeric values of each enumeration (i.e., "1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29".) You will typically use this by splitting the result by the comma delimiter and iterate through the list of numeric values, passing each value to GetColumnTypeDescription, to get a description of this enumeration. See ProfilerColumnType Enumerations for more details.

Syntax profiler->GetColumnTypeEnum();
C string = mdProfilerGetColumTypeEnum(profiler);
.Net string = profiler.GetColumnTypeEnum();


GetColumnTypeDescription

This function returns the description for the specified ColumnType Enumerator.

This function accepts one parameter.

Parameters

Name Data Type Description
ProfilerColumnTypeValue ProfilerColumnType See ProfilerColumnType Enumerations for more details.


Syntax profiler->GetColumnTypeDescription(ProfilerColumnTypeValue);
C string = mdProfilerGetColumTypeDescription(profiler, ProfilerColumnTypeValue);
.Net string = profiler.GetColumnTypeDescription(ProfilerColumnTypeValue);


ParseColumnTypeDescription

This function parses the description of the Column Type. This is actually a reverse function of GetColumnTypeDescription. See ProfilerColumnType Enumerations for details.

This function accepts one parameter.

Parameters

Name Data Type Description
ColumnTypeDescString String This string contains the description of the Profiler Column Type.


Return Value

This function returns a ProfilerColumnType value.

Syntax profiler->ParseColumnTypeDescription(ColumnTypeDescString);
C ProfilerColumnTypeValue = mdProfilerParseColumnTypeDescription(profiler, ColumnTypeDescString);
.Net ProfilerColumnTypeValue = profiler.GetColumnTypeDescription(ColumnTypeDescString);


GetDataTypeEnum

This function returns all Data Type enumerations. This returns a comma delimited list of the numeric values of each enumeration (i.e., "1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23".)You will typically use this by splitting the result by the comma delimiter and iterate through the list of numeric values, passing each value to GetDataTypeDescription, to get a description of this enumeration. See ProfilerDataType Enumerations for more details.

Syntax profiler->GetColumnTypeEnum();
C string = mdProfilerGetDataTypeEnum(profiler);
.Net string = profiler.GetDataTypeEnum();


GetDataTypeDescription

This function returns the description for a specified Data Type enumerator.

This function accepts one parameter.

Parameters

Name Data Type Description
ProfilerDataTypeVale ProfilerDataType See ProfilerDataType Enumerations for details.


Syntax profiler->GetDataTypeDescription(profilerDataTypeValue);
C string = mdProfilerGetDataTypeDescription(profiler,profilerDataTypeValue);
.Net string = profiler.GetDataTypeDescription(profilerDataTypeValue);


ParseDataTypeDescription

This function parses the description of the Data Type. This is actually a reverse function of GetDataTypeDescription.

This function accepts the Data Type description in string form as a parameter. See ProfilerDataType Enumerations for details.

Parameters

Name Data Type Description
DataTypeString String The string contains the description of the Profiler Data Type.

Return Value

This function returns a ProfilerDataType value.

Syntax profiler->ParseDataTypeDescription(StringValue);
C ProfilerDataTypeValue = mdProfilerParseDataTypeDescription(profiler, string);
.Net ProfilerDataTypeValue = profiler.ParseDataTypeDescription(string);


GetResultCodeEnum

This function returns a comma delimited list of all Result Code enumerations. See Result Codes for more information.

Syntax profiler->GetResultCodeEnum();
C stringValue = mdProfilerGetResultCodeEnum(profiler);
.Net stringValue = profiler.GetResultCodeEnum();


GetResultCodeDescription

This function returns the specified result code's description. See Result Codes for more information.

This function accepts one parameter.

Parameters

Name Data Type Description
ResultCodeString String The string contains the result code.


Syntax profiler->GetResultCodeDescription(resultcodeStr);
C stringValue = mdProfilerGetResultCodeDescription(profiler, ResultCodeString);
.Net stringValue = profiler.GetResultCodeDescription(ResultCodeString);


ProfilerColumnType Enumerations

These enumerations describe the type of column to be profiled. They are used as input parameters for AddColumn.

Value Name Description
1 ColumnTypeInt1 8 bit Signed Integer
2 ColumnTypeInt2 16 bit Signed Integer
3 ColumnTypeInt4 32 bit Signed Integer
4 ColumnTypeInt8 64 bit Signed Integer
5 ColumnTypeUInt1 8 bit Unsigned Integer
6 ColumnTypeUInt2 16 bit Unsigned Integer
7 ColumnTypeUInt4 32 bit Unsigned Integer
8 ColumnTypeUInt8 64 bit Unsigned Integer
9 ColumnTypeReal4 32 bit Floating Point Number
10 ColumnTypeReal8 64 bit Floating Point Number
11 ColumnTypeNumeric Numeric Value
12 ColumnTypeDecimal Numeric Value
13 ColumnTypeCurrency Numeric Value
14 ColumnTypeFixedMBCSString Fixed-Length Multi-Byte String
15 ColumnTypeVariableMBCSString Variable-Length multi-byte string
16 ColumnTypeFixedUnicodeString Fixed-Length Unicode String
17 ColumnTypeVariableUnicodeString Variable-Length Unicode String
18 ColumnTypeDate Date
19 ColumnTypeDBDate Database Date
20 ColumnTypeDBTime Database Time
21 ColumnTypeDBTime2 Database Time
22 ColumnTypeDBTimeStamp Time Stamp
23 ColumnTypeDBTimeStamp2 Time Stamp
24 ColumnTypeDBTimeStampOffset Date/Time Offset
25 ColumnTypeFileTime File Date/Time
26 ColumnTypeBoolean Boolean Value
27 ColumnTypeGUID GUID Value
28 ColumnTypeBytes Byte Array
29 ColumnTypeImage Image Array


ProfilerDataType Enumerations

These enumerations describe the type of data to be profiled. They are used as input parameters for AddColumn.

Value Name Description
1 DataTypeFullName Full name
2 DataTypeInverseName Inverse ordered name (Last – First)
3 DataTypeNamePrefix Name prefix
4 DataTypeFirstName First name
5 DataTypeMiddleName Middle name
6 DataTypeLastName Last name
7 DataTypeNameSuffix Name Suffix
8 DataTypeTitle Title / Department
9 DataTypeCompany Company or Organization
10 DataTypeAddress Street address
11 DataTypeCity City Name
12 DataTypeStateOrProvince US state or Canadian province
13 DataTypeZipOrPostalCode US zip code or Canadian postal code
14 DataTypeCityStateZip City/State/Zip combined
15 DataTypeCountry Country Name
16 DataTypePhone Phone number
17 DataTypeEmail Email address
18 DataTypeString Generic string value
19 DataTypeNumeric Generic numeric value
20 DataTypeDateMDY Generic Date/Time(formatted Month Day Year)
21 DataTypeDateYMD Generic Date/Time(formatted Year Month Day)
22 DataTypeDateDMY Generic Date/Time(formatted Day Month Year)
23 DataTypeBoolean Generic Boolean Value