15.10 - Data Type - Call-Level Interface Version 2

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

prodname
Call-Level Interface Version 2
vrm_release
15.10
category
Programming Reference
featnum
B035-2417-035K

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

 

Table 65: 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

CLOB

416

417

917

916

918

CLOB AS DEFERRED

420

421

920

921

922

CLOB AS LOCATOR

424

425

924

925

926

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

BIGINT

600

601

1100

1101

1102

VARBYTE

688

689

1188

1189

1190

BYTE

692

693

1192

1193

1194

LONGVARBYTE

697

696

1197

1196

1198

DATE with DBCAREA Dateformat 'A'

748

749

1248

1249

1250

DATE with DBCAREA Dateformat 'T'

752

753

1252

1253

1254

BYTEINT

756

757

1256

1257

1258

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 Character

852

853

1352

1353

1354

XML Character-deferred

856

857

1356

1357

1358

XML Character-locator

860

861

1360

1361

1362

XML Binary

864

865

1364

1365

1366

XML Binary-deferred

868

869

1368

1369

1370

XML Binary-locator

872

873

1372

1373

1374]

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 INPUT 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 (TIME, TIMESTAMP, TIME WITH TIME ZONE, TIMESTAMP WITH TIME ZONE, INTERVAL YEAR, INTERVAL YEAR TO MONTH, INTERVAL MONTH, INTERVAL DAY, INTERVAL DAY TO HOUR, INTERVAL DAY TO MINUTE, INTERVAL DAY TO SECOND, INTERVAL HOUR, INTERVAL HOUR TO MINUTE, INTERVAL HOUR TO SECOND, INTERVAL MINUTE, INTERVAL MINUTE TO SECOND, INTERVAL SECOND) are given for the “StatementInformation” on page 466. When used elsewhere, these types are all indicated as the CHAR data type.