| Result | Description |
|---|---|
| Generated SQL | Generated SQL to create table with suggested type information. Returned as text. |
| Column Types Matrix | Matrix in which each column has a row showing the type of the column throughout its transformation. Noncharacter data types are at end of matrix. NA means Not Applicable (as for the numeric test when the data type is not numeric). Returned as result set. |
| Unicode Analysis Matrix | [Created only if extendedunicodeanalysis=true.] Matrix showing all Unicode character columns. Each row contains column name, number of data values that can be translated correctly to Latin character set, and number of values that column contains. Returned as result set. |
Column Types Matrix Example
| Column | Data Type | Min Max Type | Sample Type | Numeric Test Type |
|---|---|---|---|---|
| name_prefix | CHAR(4) | VARCHAR(4) | VARCHAR(4) | VARCHAR(4) |
| last_name | CHAR(30) | VARCHAR(15) | VARCHAR(15) | VARCHAR(15) |
| age | SMALLINT FORMAT '-(5)9 ' | NA | NA | NA |
| state_code | CHAR(2) | VARCHAR(2) | VARCHAR(2) | VARCHAR(2) |
| city_name | CHAR(20) | VARCHAR(16) | VARCHAR(16) | VARCHAR(16) |
| gender | CHAR(1) | VARCHAR(1) | VARCHAR(1) | VARCHAR(1) |
| nbr_children | SMALLINT FORMAT '-(5)9 ' | NA | NA | NA |
| income | INTEGER FORMAT '-(10)9' | NA | NA | NA |
| postal_code | CHAR(5) | INTEGER | INTEGER | INTEGER |
| first_name | CHAR(30) | VARCHAR(12) | VARCHAR(12) | VARCHAR(12) |
| years_with_bank | SMALLINT FORMAT '-(5)9' | NA | NA | NA |
| street_nbr | SMALLINT FORMAT '-(5)9' | NA | NA | NA |
| cust_id | INTEGER FORMAT '-(10)9' | NA | NA | NA |
| street_name | CHAR(30) | VARCHAR(15) | VARCHAR(15) | VARCHAR(15) |
| marital_status | CHAR(1) | SMALLINT | SMALLINT | SMALLINT |
Unicode Analysis Matrix Example
| Column | Translatable to Latin | Total |
|---|---|---|
| street_name | 747 | 747 |
| gender | 747 | 747 |
| name_prefix | 747 | 747 |
| state_code | 747 | 747 |
| city_name | 747 | 747 |
| postal_code | 747 | 747 |
| last_name | 747 | 747 |
| marital_status | 747 | 747 |
| first_name | 747 | 747 |