Issuing Requests: Indicator Mode - 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

Issuing Requests: Indicator Mode

Indicator Mode requests may return the following parcels:

  • DataInfo (flavor 71)
  • EndRequest (flavor 12)
  • EndStatement (flavor 11)
  • EndWith (flavor 35)
  • Error (flavor 49)
  • Failure (flavor 9)
  • PosEnd (flavor 47)
  • Position (flavor 34)
  • PosStart (flavor 46)
  • Record (flavor 10)
  • Success (flavor 8)
  • With (flavor 33)
  • The following examples assume successful completion of the request.

     

    Table 30: Update Table1 Set Field1 = 999999; 

    Parcel

    Flavor

    Body

    Success

    8

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

    EndStatement

    11

    (1)

    EndRequest

    12

     

     

    Table 31: Select Field1 From Table1;  

    Parcel

    Flavor

    Body

    Success

    8

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

    DataInfo

    71

    (1, 496, 4)

    Record (1)

    .

    .

    .

    Record (23)

    10

    .

    .

    .

    10

    (ind, data)

    .

    .

    .

    (ind, data)

    EndStatement

    11

    (1)

    EndRequest

    12

     

     

    Table 32: Select Field1 From Table1 With Sum (Field1); 

    Parcel

    Flavor

    Body

    Success

    8

    (1, 24, 0, 1, 1, 0)

    DataInfo

    71

    (1, 496, 4)

    With

    33

    (1)

    PosStart

    46

     

    Position

    34

    (1)

    PosEnd

    47

     

    DataInfo

    71

    (1, 496, 4)

    EndWith

    35

    (1)

    Record (1)

    .

    .

    .

    Record (23)

    10

    .

    .

    .

    10

    (ind,data)

    .

    .

    .

    (ind,data)

    With

    33

    (1)

    Record

    10

    (ind,data)

    EndWith

    35

    (1)

    EndStatement

    11

    (1)

    EndRequest

    12

     

     

    Table 33: Select Field1 From Table1; Select Field2 From Table2; 

    Parcel

    Flavor

    Body

    Success

    8

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

    DataInfo

    71

    (1, 496, 4)

    Record (1)

    .

    .

    .

    Record (23)

    10

    .

    .

    .

    10

    (ind.data)

    .

    .

    .

    (ind.data)

    EndStatement

    11

    (1)

    Success

    8

    (2, 10, 0, 1, 1, 0)

    DataInfo

    71

    (2, 496, 4)

    Record (1)

    .

    .

    .

    Record (10)

    10

    .

    .

    .

    10

    (ind,data)

    .

    .

    .

    (data)

    EndStatement

    11

    (2)

    EndRequest

    12

     

     

    Table 34: Echo ‘Select Field1 From Table1’; 

    Parcel

    Flavor

    Body

    Success

    8

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

    Record

    10

    (echoed string)

    EndStatement

    11

    (1)

    EndRequest

    12