RADIX - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
xha1591998860283.ditamap
dita:ditavalPath
xha1591998860283.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantageā„¢

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