Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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;

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'.


  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023