Profiler Object:Enumeration Listing and Parsing
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 | const char* = 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 | const char* = 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 | const char* = 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 | const char* = 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 | const char* = mdProfilerGetResultCodeEnum(profiler); |
.Net | string = 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 | const char* = mdProfilerGetResultCodeDescription(profiler, ResultCodeString); |
.Net | string = 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 |