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
N/A

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?