TYPE()

From Lianjapedia
Jump to: navigation, search

Purpose

Function to return a letter code that represents a data type

Syntax

TYPE(<expC>)

See Also

ATOH(), BIN2I(), BIN2L(), BIN2W(), CAST(), CTOD(), CTOT(), DTOC(), DTOM(), DTOS(), DTOV(), ERROR(), ERRNO(), ETOS(), HTOA(), I2BIN(), ISALPHA(), ISDIGIT(), L2BIN(), MESSAGE(), MTOS(), SET JSONBOOLEAN, STR(), STRZERO(), TTOC(), TTOD(), TYPEOF(), VAL(), VARTYPE(), VTOD()

Description

The TYPE() function returns a letter code which represents the data type of the expression in <expC>. The return value of the letter code is a character string from the table below.

Data type Return Value
ARRAY (STATIC) A
ARRAY (DYNAMIC) O
BIGINT N
BIT L
BYTE N
CHARACTER C
CURRENCY Y
DATE D
DATETIME T
DECIMAL N
DOUBLE N
FLOAT N
GENERAL G
INTEGER N
LOGICAL L
LONG VARCHAR M
LONG VARBINARY G
MEDIUMINT N
MEMO M
NUMERIC N
OBJECT O
PACKED N
QUAD N
REAL N
SHORT N
SMALLINT N
Syntax error U
TEXT M
TIME C
TIMESTAMP T
TINYINT N
Undefined U
VAXDATE C
VARCHAR C
ZONED NUMERIC C

Example

i = 10
? type("i")
N