FW: Fixed length fields
If you are using V5 of informix you can use the syntax:
select col1 || col2 || col3
from ....
This will produce a fixed length record output (I have only tried it using a
few different datatypes, not all of them). You do not have any control over
the size of the fields, this is determined by the length of the datatype.
I have also not checked out what happens for negative numbers (my guess is
that this will ruin your output file format)
Mark Denham
BBC
Email: Mark.Denham@bbc.itd.co.uk
----------
From: ilist
To: wayne
Cc: informix-list
Subject: Re: Fixed length fields
Date: 19 June 1995 12:44
> Hello,
>
> A colleague is looking for a way to use SQL (not 4GL), to download fixed
> length fields without delimeters. Any pointers qould be useful.
check into "output to" in the sql reference guide
> Also, the reverse, is there any way to get fixed length fields without
> delimeters into Informix, without using incredibly complex Unix formatting
> commands?
check into dbload command
> Thank You
> Wayne
>
> |Wayne Harlech-Jones
> |Windhoek, Namibia, Southern Africa
> |wayne@jones.mac.alt.na
>
>
>
--
regards,
+---------------------------------------------------------------------------
-+
| . . | Bob Baskett
|
| ... ... | Software Engineer
|
| ..... ..... | Business Systems Integration Group
|
| .. ... .. | Semiconductor Products Sector
|
| . . . | Mesa, AZ
|
| | President, Informix Users Group Of Arizona
|
| Motorola, Inc. |
|
+---------------------------------------------------------------------------
-+
| Sun 690MP 4.1.3, Online 5.01, 4.10.UD1 Tools, Fourgen v4.10.UC1
|
+---------------------------------------------------------------------------
-+