BTEQ Warning: Out of data

Database
Enthusiast

BTEQ Warning: Out of data

the step that creates the table works fine... it's step 2 when loading the table I get 

*** WARNING: Out of data

my input file contains 4 records, however when I view the table contents only the 1st record is loaded.  I have tried revising the code below in differnernt methods but no success.  the log file captured after the scripts complets is ok no errors.  can someone give me a solution...  thank you for your time.

 *** Starting Row 0 at Wed Jan 25 11:49:13 2012

 *** Finished at input row 4 at Wed Jan 25 11:49:13 2012

 *** Total number of statements: 4,  Accepted : 4,  Rejected : 0 

 *** Total elapsed time was 1 second.

+---------+---------+---------+---------+---------+---------+---------+----

commit;

 *** Total elapsed time was 1 second.

+---------+---------+---------+---------+---------+---------+---------+----

.logoff;

 *** You are now logged off from the DBC.

+---------+---------+---------+---------+---------+---------+---------+----

.quit;

 *** Exiting BTEQ...

 *** RC (return code) = 0 

the main script that loads the table...




-- BTEQ Multi Sessions Sample Script

.set sessions 32

.logon prod/vincent_gabrielli,xxxxxxxx;

--  This option minimizes messages...

.set quiet on

.import vartext ',' file=C:\BTEQ\Load_Usoc\ld_usocs.txt;

.repeat *

using 

usoc (varchar(6)),

flag (varchar(2))

insert into vincent_gabrielli.ld_usocs 

values (

trim(:usoc),

trim(:flag)

); 

commit;

.logoff;

.quit;

.exit;

1 REPLY
Enthusiast

Re: BTEQ Warning: Out of data

I found the problem disregard my previous note.