Archives of the TeradataForum

Message Posted: Wed, 10 Sep 2003 @ 06:27:35 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

You could instead just say

.set recordmode on

followed by your SELECT statement & you get the hexdump.

For instance...

sel*from a;

sel*from a;

 *** Query completed. One row found. One column returned.
 *** Total elapsed time was 1 second.

          i
-----------
        123

 BTEQ -- Enter your DBC/SQL request or BTEQ command:
.recordmode

.recordmode
 BTEQ -- Enter your DBC/SQL request or BTEQ command:
sel*from a;

sel*from a;

 *** Success, Stmt# 1 ActivityCount = 1
 *** Query completed. One row found. One column returned.
 *** Total elapsed time was 1 second.

 *** Record#1. Dump Of Data:
  0000  7B00 0000                                 *{...*

 BTEQ -- Enter your DBC/SQL request or BTEQ command:

Sanjaya

	<Prev	Next>		<<First	<Prev	Next>	Last>>