Archives of the TeradataForum

Message Posted: Tue, 10 Jan 2012 @ 17:23:32 GMT

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

BTEQ by default uses Field Mode, which means that it retrieves the result set one column at a time. This is slow, but the advantage is that each column is formatted for you by the database -- either the default format for the data type or the format specified in the Create Table statement.

SQL Assistant, and most other applications, use Record Mode. This means that the columns are ordinarily returned in internal form; e.g., integers are 32-bit binary, varchars have a 16-bit integer on the front, and so on.

Formatting has to be done by the application, unless you override the format for individual columns by saying something like "cast(cast( time_col as format '99:99:99') as char(8))".

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