Getting the warnjng- *** Warning: Out of data-while importing csv file using bteq

General

Getting the warnjng- *** Warning: Out of data-while importing csv file using bteq

HiI am getting the warning message *** Warning: Out of data while importing the csv file to bteq.But,It is loading all the records successfully.

Please find the below code

.logon xxxxx/xxxxx,xxxxxxxx
delete from xxxxxxxx.jobdetails;

.import VARTEXT ',' file=jobdetails1.csv, skip =1;
.QUIET ON
.repeat *

using(in_jobid varchar(20),
in_jobname varchar(50),
in_RunDate varchar(50),
in_RunTime varchar(50),
in_Operation varchar(50),
in_TDPId varchar(50),
in_Streams varchar(50),
in_ClientID varchar(50),
in_Size varchar(50),
in_ElapsedTime varchar(50),
in_ExitCode varchar(50))

insert into xxxxxxxxx.jobdetails values(:in_jobid
,:in_jobname
,:in_RunDate
,:in_RunTime
,:in_Operation
,:in_TDPId
,:in_Streams
,:in_ClientID
,:in_Size
,:in_ElapsedTime
,:in_ExitCode);

.quit;
.logoff

Could any one please help me in resolving the issue. Your help here is appreciated.

Thanks,

vikram

3 REPLIES
Teradata Employee

Re: Getting the warnjng- *** Warning: Out of data-while importing csv file using bteq

There is no issue to resolve. The message is simply notifying you that BTEQ import reached the end of file, as expected.

xzy
Not applicable

Re: Getting the warnjng- *** Warning: Out of data-while importing csv file using bteq

greate Fred:

     so  how to close this warning? I don't like this warning.

Teradata Employee

Re: Getting the warnjng- *** Warning: Out of data-while importing csv file using bteq

What are you trying to accomplish by eliminating the warning?