RE: Restoring a .txt file

["Reggie Acosta" <racosta@xxxxxxxxxxxxxxx>]

How about using SQL to substring the number in the flat record and cast the
result as a decimal? 

Let's say your number starts in column 21 and is 14 characters long and the
field in you regular format is a 13,2 decimal, the following (untested)
specification should work.

CAST(SUBSTR(flatr_cd, 21, 14) as DECIMAL(13, 2) as field_name


Reggie

> ------------------------------
> from: "Angela Wawrzaszek" <awawrzaszek@xxxxxxxxxxxxxxx>
> 
>     I have a .txt file that was saved from an as/400 
> inventory file.  It
> was saved as a fixed format file.   I now want to bring that .txt file
> back to the as400 to run queries on it.   However since it was fixed
> there is not comma delimiters etc.   So I copied it back to a 
> flat file
> on the as400 and then tried using the cpyfrmimpf command to 
> copy it back
> into its regular format.   The problem occurs because there is numeric
> data in the file.  Therefore the copy crashes because I am 
> trying to copy  17.00  - which is beign treated as a 
> character field to a numberic field.
> 
> ------------------------------