BTEQ - INDICDATA in Teradata

INDICDATA specifies the mode of information returned from the Teradata RDBMS in response to SQL SELECT statements.

For example, if a user wants the data from Teradata RDBMS as in native format then INDICDATA can be used.

Syntax:
.SET INDICDATA ON | OFF;


Example:

.database forgetcode;
.set defaults
.set indicdata on
select empno
,proj_id from tbl_emp
where empno = 101
order by proj_id
;
.indicdata off
= 1
.defaults
.format off
.logoff
.exit


Response:
BTEQ returns the following response:
*** New default database accepted .
*** Success, Stmt# 1 ActivityCount = 2
*** Query completed. 2 rows found. 2 columns
returned.
*** Dump of Parcel DATAINFO: 0000 0002 01F4 0002
01C4 0008 * ...4...D..*
*** Record#1 . Dump Of Data: 0000 0027 14C5 D5C7
60F0 F0F0 F2 * ...ENG-0002*
*** Record#2 . Dump Of Data: 0000 0027 14C5 D5C7
60F0 F0F0 F3 * ...ENG-0003*
*** Query completed. 2 rows found. 2 columns
returned.
Employee Project
Id Id
-------- --------
101 ENG-0002
101 ENG-0003