RADIX - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-15
dita:mapPath
boh1556732696163.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantageā„¢

Purpose

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 ]
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
Input to or output from Ferret defaults to a radix of hexadecimal.
DEC
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