Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 28 Mar 2002 @ 14:04:36 GMT


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


Subj:   BTEQ - eliminate the request processing statistics messages
 
From:   Rudel Simard

Hi everybody,

We have a BTEQ question.

script :
.MESSAGEOUT FILE = 'out1.TXT'
.SET RECORDMODE ON
DATABASE DATA01;
DROP TABLE USER1_TV1;
CREATE VOLATILE TABLE USER1_TV1
 (NOI INTEGER)
 ON COMMIT PRESERVE ROWS;
Quiet on
SELECT DATABASE;
.IMPORT INDICDATA FILE = 'EXSOPHIE4 1.DAT'
.REPEAT 4
USING NO_BEN_PARAM (CHAR(09))
INSERT INTO USER1_TV1
   VALUES  (:NO_BEN_PARAM);
.EXPORT RESET

Result of the import:

*** Starting Row 0 at Wed Mar 27 13:34:56 2002

 *** Total elapsed time was 1 second.

 *** Total elapsed time was 1 second.

 *** Total elapsed time was 1 second.

 *** Total elapsed time was 1 second.

 *** Finished at input row 4 at Wed Mar 27 13:34:56 2002
 *** Total number of statements: 4,  Accepted : 4,  Rejected : 0

 *** Total elapsed time was 1 second.

 *** Total requests sent to the DBC = 4
 *** Successful requests per second =  4.000

Can we eliminate the request processing statistics messages? We want to reduce the time of execution of the import with BTEQWIN.

The option in effect are : quiet off

We use the command :
                 .MESSAGEOUT FILE = 'out1.TXT'

Rudel Simard
Régie de l'assurance-maladie du Québec
DBA de l'environnement informationnel



     
  <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: 27 Dec 2016