Re: Delimiter-free Unload Utility

John Morton (mortonj@interlog.com) wrote: { Does anyone know of a utility (Informix or other) that will allow us { to unload an Informix table into a file without delimiters? Special { characters are causing our DB2/MVS loads to fail. { The data is unloaded from informix, then ftp'd to mvs and loaded into { db2. { This is what we'd like to see (for example) { 123 John Doe 123 Any Street Anytown { 156 Frank Smith Anytown { etc. etc (ie the data is positional, not delimited, in the unload { file) { Any help would be appreciated. if setting DBDELIMITER to "" doesn't work, try writing a report with the following output top margin 0 bottom margin 0 left margin 0 page length 1 format on every row print fieldname1, fieldname2, fieldname3, fieldname4, etc.... -- gburnore@databasix.com mailto:gburnore@databasix.com --------------------------------------------------------------------------- How you look depends on where you go. --------------------------------------------------------------------------- Gary L. Burnore | '۳''''''۳'''''''''''۳ DataBasix | '۳''''''۳'''''''''''۳ San Francisco, CA | '۳''''''۳'''''''''''۳ | '۳ 3 4 1 4 2 '' 6 9 0 6 9 '۳ http://www.databasix.com | Official Proof of Purchase ===========================================================================