Remapping data to a different SQL data type

Use the Mapping page to remap the data that is retrieved from a table column to a different SQL data type. This action also maps the data to a different Java class.

../rule.gif

To remap the data in a table column:

  1. Select a column from the Column list. The Current data type field displays the SQL data type for the column.

  2. Select an SQL data type from the New data type list. The data that is retrieved from the column will be mapped to the selected SQL data type.

  3. Optional: To reset the mapping of all columns to their default SQL data types, click Defaults.

../rule.gif

Related information

Mapping page - Fields and controls

Specifying the tables for an SQL statement

Specifying result columns

Joining tables

Specifying search conditions for rows

Grouping rows and specifying search conditions for groups

Sorting the result set

Verifying the SQL statement

Inserting column values

Updating column values

Completing your SQL statement

Creating SQL statements with SQL Assist

Logging on to SQL Assist

Selecting the type of SQL statement to create