|
|
| Line 2: |
Line 2: |
| [[Profiler Object:Reference|← Profiler Object Reference]] | | [[Profiler Object:Reference|← Profiler Object Reference]] |
|
| |
|
| {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;" | | {{ProfilerObjectNav |
| ! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"|'''Profiler Object Interface Navigation'''
| | |IteratorsCollapse= |
| |-
| | }} |
| | style="padding-right:220px;"|
| |
| |-
| |
| |[[Profiler Object:Initialization|Initialization]]
| |
| |-
| |
| |[[Profiler Object:Object Information|Object Information]]
| |
| |-
| |
| |[[Profiler Object:Enumeration Listing and Parsing|Enumeration Listing and Parsing]]
| |
| |-
| |
| |[[Profiler Object:Column Specification|Column Specification]]
| |
| |-
| |
| |[[Profiler Object:Initiate Profiling|Initiate Profiling]]
| |
| |-
| |
| |[[Profiler Object:Data Input|Data Input]]
| |
| |-
| |
| |[[Profiler Object:Profiling|Profiling]]
| |
| |-
| |
| |[[Profiler Object:Table-Based Statistics|Table-Based Statistics]]
| |
| |-
| |
| |-
| |
| |
| |
| {| class="mw-collapsible mw-collapsed" style="width:100%;" | |
| |- align="left" | |
| ! style="color:black; text-align:left;"|[[Profiler Object:Column-Based Statistics|Column-Based Statistics]]
| |
| |-
| |
| |[[Profiler Object:Column-Based String Statistics|Column-Based String Statistics]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Numeric Statistics|Column-Based Numeric Statistics]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Date/Time Statistics|Column-Based Date/Time Statistics]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Name Statistics|Column-Based Name Statistics]]
| |
| |-
| |
| |[[Profiler Object:Column-Based State/Province Statistics|Column-Based State/Province Statistics]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Zip/Postal Code Statistics|Column-Based Zip/Postal Code Statistics]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Country Statistics|Column-Based Country Statistics]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Email Statistics|Column-Based Email Statistics]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Phone Statistics|Column-Based Phone Statistics]]
| |
| |-
| |
| |}
| |
| |-
| |
| |
| |
| {| class="mw-collapsible" style="width:100%;"
| |
| |- align="left"
| |
| ! style="color:black; text-align:left;"|[[Profiler Object:Iterators|Iterators]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Value Frequency Table Iteration|Column-Based Value Frequency Table Iteration]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Value Length Frequency Table Iteration|Column-Based Value Length Frequency Table Iteration]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Value Pattern Table Iteration|Column-Based Value Pattern Table Iteration]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Value Date/Time Table Iteration|Column-Based Value Date/Time Table Iteration]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Value SoundEx Table Iteration|Column-Based Value SoundEx Table Iteration]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Word Table Iteration|Column-Based Word Table Iteration]]
| |
| |-
| |
| |[[Profiler Object:Column-Based Word Length Table Iteration|Column-Based Word Length Table Iteration]]
| |
| |-
| |
| |}
| |
| |-
| |
| |
| |
| {| class="mw-collapsible mw-collapsed" style="width:100%;"
| |
| |- align="left"
| |
| ! style="color:black; text-align:left;"|[[Profiler Object:Result Codes|Result Codes]]
| |
| |-
| |
| |[[Returned Result Codes:APIs#Profiler Object|Returned Result Codes]]
| |
| |-
| |
| |[[Result Codes]]
| |
| |}
| |
| |}
| |
|
| |
|
|
| |
|
← Profiler Object Reference
These functions allow you to step through each distinct value length for a specific column.
StartLengthFrequency
This function initiates the iterator.
This function takes two parameters.
Parameters
| Name
|
Data Type
|
Description
|
| ColumnName
|
String
|
Column Name to start the iterator.
|
| Order
|
Order
|
This specifies how to order. See Order Enumeration for details.
|
| Syntax
|
profiler->StartLengthFrequency(columnNameStr, Order);
|
| C
|
mdProfilerStartLengthFrequency(profiler,columnNameStr, Order);
|
| .Net
|
profiler.StartLengthFrequency(columnNameStr, Order);
|
GetLengthFrequencyValue
This function returns a column's distinct length.
This function takes one parameter.
Parameters
| Name
|
Data Type
|
Description
|
| ColumnName
|
String
|
Column Name to get the column’s distinct length.
|
| Syntax
|
profiler->GetLengthFrequencyValue(ColumnNameStr);
|
| C
|
integer = mdProfilerGetDataFrequencyValue(profiler,columnNameStr);
|
| .Net
|
integer = profiler.GetDataFrequencyValue(columnNameStr);
|
GetLengthFrequencyCount
This function returns the number of times the length appears in the profiled data for this particular column.
This function takes one parameter.
Parameters
| Name
|
Data Type
|
Description
|
| ColumnName
|
String
|
Column Name to get the number of times the length appears in the profiled data.
|
| Syntax
|
profiler->GetLengthFrequencyCount(columnNameStr);
|
| C
|
integer = mdProfilerGetLengthFrequencyCount(profiler,columnNameStr);
|
| .Net
|
integer = profiler.GetLengthFrequencyCount(columnNameStr);
|
GetNextLengthFrequency
This function steps to the next distinct length. It returns 1 if there are more distinct lengths or 0 when there are no more lengths.
This function takes one parameter.
Parameters
| Name
|
Data Type
|
Description
|
| ColumnName
|
String
|
Column Name to get the next distinct length.
|
| Syntax
|
profiler->GetNextLengthFrequency(ColumnNameStr);
|
| C
|
integer = mdProfilerGetNextLengthFrequency(profiler,columnNameStr);
|
| .Net
|
integer = profiler.GetNextLengthFrequency(columnNameStr);
|