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 Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023