Re: Help Mr. Wizard! Help! (Fixed length output & data conversion)

: Lance Hamilton wrote : } : }My employer, >>>against my recommendation<<<, is moving our accounting : }software from an Informix SE application on SCO Unix to HP's Allbase SQL : }database running HP's MPE/ix O/S on an HP 3000 mini-computer. : : }output : } left margin 0 : } right margin 1353 {table's "syscolumns.rowsize" = 1353} : } top margin 0 : } bottom margin 0 : }end I missed the original post -- why exactly are you writing an ACE program for this, rather than using UNLOAD or something like that? Also, note that the rowsize from the system catalogs is not necessarily the same as the number of characters it will require to print the columns out in ASCII format; rowsize refers to internal storage -- in all likelihood it will be different. June ---- June Tong Informix Software ---- ---- Senior Consultant (415) 926-6140 ---- ---- International Support junet@informix.com ---- ---- Location-du-jour: Menlo Park ---- * * Standard disclaimers apply * - Please do not send me requests/questions by mail. When I have the knowledge - and time permits, I try to answer questions on comp.databases.informix, but - travel schedule, time, and volume make responding to personal requests - difficult and often slow. Please call your local Informix Technical Support - organization for assistance with technical issues.