Archives of the TeradataForum
Message Posted: Tue, 10 Jan 2012 @ 17:23:32 GMT
| Subj: || || Re: Missing a setting here ..can't recollect what |
| From: || || Geoffrey Rommel |
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
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))".