RE: Outputting rows in fixed length format

If your fields are already defined in the appropriate length you can just do a unload from dbaccess. Example: SELECT fld1 || fld2 || fld3 FROM sometable The result would be one expression. If your fields need some padding you can do the following. Example: SELECT fld1 || " " || fld2 || " " || fld3 FROM sometable Just put between the quotes the appropriate spaces needed for padding or pad with whatever character that maybe necessary. Mike Gabbard Red Man Pipe & Supply Company -----Original Message----- From: Scott Black [mailto:sblack@elsouth.com] Sent: Thursday, September 24, 1998 11:51 AM To: 'informix-list@iiug.org' Subject: RE: Outputting rows in fixed length format I'm not sure of what the ACE line length limit is (assuming there is one) but it is over one thousand. Of course not everybody has ACE, but I can't imagine using Informix without ISQL. -----Original Message----- From: Peter Lancashire [SMTP:Peter.Lancashire.PL1@bayer.co.uk] Posted At: Thursday, September 24, 1998 9:19 AM Posted To: Informix Conversation: Outputting rows in fixed length format Subject: Re: Outputting rows in fixed length format WF Software wrote: > > In article <6ubfkt$lb5$1@news.xmission.com>, sblack@elsouth.com (Scott > Black) wrote: > > > > > The easiest way might be to generate an ACE report. > > That way you can print each field at a given point on every line. > > Also you will need to include the following: > > > > Page length 1 > > Top margin 0 > > Bottom margin 0 > > Left margin 0 > > > [cutting] > > Assuming that you've got ACE capabilities And you don't exceed the ACE line length limit (132 chars?). > > Paul Watson # I don't suffer from > WF Software Ltd. # stress, I'm just > Tel. (+44) 1436 674729 # a carrier > Fax. (+44) 1436 678693 # > www.wfsoftware.co.uk -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 --- If all else fails, read the instructions AND the release notes. All opinions are my own and not those of Bayer plc. My Internet plumbing does not allow me to mail and post news together. Sorry. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/