17.10 - RADIX - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

The RADIX command sets the default radix used as the numeric base for data input to and output from Ferret as either hexadecimal or decimal. If you type just the command RADIX, the current settings of the input and output are displayed.

Syntax

{ RADIX | RAD }
  [ INPUT | IN | OUTPUT | OUT ]
  [ HEX | H | DEC | D ]

Syntax Elements

INPUT
Input to Ferret defaults to the radix you select, either hexadecimal or decimal.
OUTPUT
Output from Ferret defaults to the radix you select, either hexadecimal or decimal.
HEX
H
Input to or output from Ferret defaults to a radix of hexadecimal.
DEC
D
Input to or output from Ferret defaults to a radix of decimal.

Usage Notes

When you start Ferret, the default radix for both input and output from Ferret is decimal.

If you omit both the INPUT and OUTPUT options from the RADIX command, the radix (HEX or DEC) that you select applies to both numeric input and output.

You can select either INPUT or OUTPUT, but not both when changing the settings of Ferret data.

If you omit both the HEX and DEC options, Ferret displays the current RADIX setting.

Example: Setting the Ferret default radix to decimal

The following command example shows how to set the input to decimal:

Ferret ==>
Rad Input Dec