Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Tue, 27 Jan 2004 @ 09:18:18 GMT





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




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





     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
 
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 30 Jun 2008