Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 08 Jul 2002 @ 18:09:21 GMT


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


Subj:   Re: FastExport using boundary values
 
From:   Geoffrey Rommel

  I am using the following script to export the data by using Boundry values, from a 'employee' table having two columns empid (INTEGER), empname CHAR(10). The table has records from 1001 to 1025. But it is not exporting any record to the file.  



I believe the problem is the format of your two numbers. Your FIELD statements say:

.FIELD fromval * INTEGER;
.FIELD toval * INTEGER;


But then you say:

  My Infile is as follows....  


  First Record 1001 1020  


If the record looks just the way you have printed it here, it will not work. When you define a field as INTEGER, FastExport is expecting internal (binary) integer format. From an Intel platform, an integer 1001 would be 4 bytes with the value x'E9030000'; from MVS, it would be x'000003E9'.


--wgr



     
  <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: 15 Jun 2023