Re: Fixed-length unload from Informix
Bob Lefevere wrote:
>
> Hi All,,
>
> Does anybody here know a way (ie. apart from fiddling with AWK and such) to
> make a table unload in fixed-length field format ?
>
> Thanks in advance,
> Bob
## snip here
-- unload.ace - Unload table1 in fixed-length format
database dbname end
select * from table1 end
format every row end
## snip here
Compile this using saceprep and run...
--
-----------------------------------------------------------------------
Daniel James - Database Administrator djames@statsci.com
DAPD Div of MathSoft (formerly StatSci) (206) 283-8802 x284