Archives of the TeradataForum

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

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

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>>