Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 12 Dec 2002 @ 20:10:32 GMT


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


Subj:   Fastexport: unexpected data format
 
From:   JoAnn Dong

I have following fastexport script file but it give me error(copied below), can someone help me with this?

.LOGTABLE databaseName.LOG_TESTT2;

.LOGON fff/name,pwd;

DATABASE dababasename;

.BEGIN EXPORT;
.LAYOUT intLoad;
.FIELD loadNum * char(9);
.IMPORT INFILE
D:\Datawarehouses\fastExport\testttt.txt
LAYOUT intLoad;
.EXPORT OUTFILE
D:\Datawarehouses\fastExport\data91.txt
 mlscript
D:\Datawarehouses\fastExport\data91script.sql;

 SELECT

cust_no, cust_name FROM atable WHERE NLOAD =
cast(:loadNum as integer);
.END EXPORT;
.LOGOFF;

/* accesws module error '16' received during 'read'
operation  on record number '0:) unexpected data format'*/
/* record '1' of file 'd:\.. is too short by '9' bytes.*/

Thanks,

JoAnn



     
  <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