Examples - 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.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2418
lifecycle
previous
Product Category
Teradata Tools and Utilities

Examples

The following examples assume successful completion of the request.

Example  

UPDATE TABLE1 SET FIELD1 999999

 

Parcel

Flavor

Parcel Body Fields

Success

8

(1, 23, 0, 0, 3, 0)

EndStatement

11

(1)

EndRequest

 

 

Example  

Select field1 from table1

 

Parcel

Flavor

Parcel Body Fields

Success

8

(1, 23, 0, 0, 3, 0)

DataInfox

146

(1, 496, 4)

Multipart record
for row 1

144

(indicator, data)

End Multipart Record

145

 

Multipart record
for row 2

144

(indicator, data)

End Multipart Record

145

 

End Statement

11

 

End Request

10

 

Example  

SELECT FIELD1 FROM TABLE1 WITH SUM (FIELD1);

 

Parcel

Flavor

Parcel Body Fields

Success

8

(1, 23, 0, 0, 3, 0)

DataInfox

146

(1, 496, 4)

With

33

(1)

PosStart

46

 

Position

34

1

PosEnd

47

 

DataInfox

146

(1, 496, 4)

EndWith

35

(1)

Multipart record
for row 1

144

(indicator, data)

End Multipart Record

145

 

Multipart record
for row 2

144

(indicator, data)

End Multipart Record

145

 

with

33

(1)

Multipart record

144

(indicator, data)

End Multipart Record

145

 

EndWith

35

(1)

End Statement

11

(1)

End Request

10

 

Example  

SELECT FIELD1 FROM TABLE1; SELECT FIELD2 FROM TABLE2;

 

Parcel

Flavor

Parcel Body Fields

Success

8

(1, 23, 0, 0, 3, 0)

DataInfox

146

(1, 496, 4)

Multipart record
for row 1

144

(indicator, data)

End Multipart Record

145

 

Multipart record
for row 2

144

(indicator, data)

End Multipart Record

145

 

End Statement

11

 

Success

8

(1, 23, 0, 0, 3, 0)

DataInfox

146

(1, 496, 4)

Multipart record
for row 1

144

(indicator, data)

End Multipart Record

145

 

Multipart record
for row 2

144

(indicator, data)

End Multipart Record

145

 

End Statement

11

(1)

End Request

10

 

Example  

ECHO “SELECT FIELD1 FROM TABLE1”

 

Parcel

Flavor

Parcel Body Fields

Success

8

(1, 0, 0, 1, 33, 0)

Multipart record(s)

144

(ind, data)

EndMultipartRecord

145

 

End Statement

11

(1)

End Request

10