 |
 |
Archives of the TeradataForum
Message Posted: Mon, 08 Jul 2002 @ 18:09:21 GMT
| 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.... | |
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
| |
