Profiler Object:Enumeration Listing and Parsing

← Profiler Object Reference

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->ParseColumnTypeDescription(StringValue);
C	ProfilerDataTypeValue = mdProfilerParseDataTypeDescription(profiler, string);
.Net	ProfilerDataTypeValue = profiler.GetColumnTypeDescription(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	ColumnTypeUInt1	16 bit unsigned integer
7	ColumnTypeUInt1	32 bit unsigned integer.
8	ColumnTypeUInt1	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