admin translate

Description

Performs a datatype translation on a value, displaying the results in delimited literal format.

Syntax

admin translate, value, source_datatype, target_datatype

Parameters

value

The literal representation of the value that is to be translated.

source_datatype

The name of a datatype (either a Replication Server native datatype or a datatype definition that describes the content and format of value).

target_datatype

The name of a datatype (either a Replication Server base datatype or a datatype definition that is the requested output for the translation).

Examples

Example 1

This examples translates the DB2 TIMESTAMP value ‘1999-06-22-14.35.23.123456’ to the Oracle DATE value ‘22-Jan-99.’

admin translate, '1999-06-22-14.35.23.123456',
rs_db2_timestamp, rs_oracle_date

Example 2

This example translates the Adaptive Server binary value 0x1122aabb to the Oracle binary value ‘1122aabb.’

admin translate, 0x1122aabb, 'binary(4)',
        'rs_oracle_binary(4)'

Usage

Permissions

Any user may execute this command.

See also

alter replication definition, create replication definition, alter connection, create connection