Data Type - Call-Level Interface Version 2

Teradata Call-Level Interface Version 2 Reference for Workstation-Attached Systems

Product
Call-Level Interface Version 2
Release Number
15.00
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-2418
lifecycle
previous
Product Category
Teradata Tools and Utilities

Data Type

The Data Type field specifies the type of data contained in a database column.

 

Table 16: Data Type Values 

Name

Type if
non-nullable

Type if Nullable

Type if IN parameter

Type if INOUT parameter

Type if OUT parameter

BLOB

400

401

900

901

902

BLOB AS DEFERRED

404

405

904

905

906

BLOB AS LOCATOR

408

409

908

909

910

BLOB AS DEFERRED BY NAME

412

413

912

913

914

CLOB

416

417

916

917

918

CLOB AS DEFERRED

420

421

920

921

922

CLOB AS LOCATOR

424

425

924

925

926

UDT

432

433

932

933

934

Distinct UDT

436

437

936

937

938

Structure UDT

440

441

940

941

942

VARCHAR

448

449

948

949

950

CHAR

452

453

952

953

954

LONGVARCHAR

456

457

956

957

958

VARGRAPHIC

464

465

964

965

966

GRAPHIC

468

469

968

969

970

LONGVARGRAPHIC

472

473

972

973

974

FLOAT

480

481

980

981

982

DECIMAL

484

485

984

985

986

INTEGER

496

497

996

997

998

SMALLINT

500

501

1000

1001

1002

ARRAY - one dimension

504

505

1004

1005

1006

ARRAY - multiple dimensions

508

509

1008

1009

1010

BIGINT

600

601

1100

1101

1102

NUMBER

604

605

1104

1105

1106

VARBYTE

688

689

1188

1189

1190

BYTE

692

693

1192

1193

1194

LONGVARBYTE

696

697

1196

1197

1198

DATE with DBCAREA Date-format 'A'

748

749

1248

1249

1250

DATE with DBCAREA Date-format 'T'

752

753

1252

1253

1254

BYTEINT

756

757

1256

1257

1258

TIME

760

761

1260

1261

1262

TIMESTAMP

764

765

1264

1265

1266

TIME WITH TIME ZONE

768

769

1268

1269

1270

TIMESTAMP WITH TIME ZONE

772

773

1272

1273

1274

INTERVAL YEAR

776

777

1276

1277

1278

INTERVAL YEAR TO MONTH

780

781

1280

1281

1282

INTERVAL MONTH

784

785

1284

1285

1286

INTERVAL DAY

788

789

1288

1289

1290

INTERVAL DAY TO HOUR

792

793

1292

1293

1294

INTERVAL DAY TO MINUTE

796

797

1296

1297

1298

INTERVAL DAY TO SECOND

800

801

1300

1301

1302

INTERVAL HOUR

804

805

1304

1305

1306

INTERVAL HOUR TO MINUTE

808

809

1308

1309

1310

INTERVAL HOUR TO SECOND

812

813

1312

1313

1314

INTERVAL MINUTE

816

817

1316

1317

1318

INTERVAL MINUTE TO SECOND

820

821

1320

1321

1322

INTERVAL SECOND

824

825

1324

1325

1326

PERIOD (DATE)

832

833

1332

1333

1334

PERIOD (TIME)

836

837

1336

1337

1338

PERIOD (TIME WITH TIME ZONE)

840

841

1340

1341

1342

PERIOD (TIMESTAMP)

844

845

1344

1345

1346

PERIOD (TIMESTAMP WITH TIME ZONE)

848

849

1348

1349

1350

XML Text

852

853

1352

1353

1354

XML Text Deferred

856

857

1356

1357

1358

XML Text Locator

860

861

1360

1361

1362

The several values for each type are algorithmically related to the non-nullable value: the nullable value is one greater; the IN parameter value is 500 greater; the INOUT parameter value is 501 greater; and the OUT parameter value is 502 greater. Note that the three parameter values do not differentiate non-nullable from nullable.

Non-nullable refers to columns defined NOT NULLS.

IN, INOUT, and OUT refer to attributes for parameters on an SQL CALL statement.

The temporal data types are given for “StatementInformation” on page 331. When used elsewhere, these types are all indicated as the CHAR data type.