|
|
Archives of the TeradataForum
Message Posted: Tue, 27 Jan 2004 @ 09:18:18 GMT
Subj: | | Re: Displaying More Than 100 Columns using BTEQ |
|
From: | | Santra, Partho |
Hi,
These are bteq defaults, so I think u should be able to display more than 100 columns.
Default Maximum Byte Count = 1048500
Default Multiple Maximum Byte Count = 2048
Current Response Byte Count = 65473
Maximum number of sessions = 200
Maximum request size = 1048500
Maximum IMPORT/USING data size = 65473
Maximum number of columns per SELECT= 2048
Maximum number of WITH clauses = 10
Maximum number of times in a REPEAT = 2147483647
Maximum number of script files = 30
Maximum number of lines in a TITLE = 10
Maximum number of lines per page = 55
Maximum string length = 254
Maximum number of WIDTH in a report = 254
Minimum number of WIDTH in a report = 20
Thanks
| |