Re: select (display) problem

You need to specify a different delimiter. The default is a vertical pipe "|" and the system is interpreting it as a field delimiter. We have the same problem when our data people try to put pipes in the data. The only other option is to go through your data and change all of your pipes. We use a tilde "~" to delimit in this case since none of our data has that character in it. Rob ----- Original Message ----- From: Dirk Moolman <DirkM@digicare.co.za> Date: Tuesday, July 4, 2006 7:04 am Subject: select (display) problem > I have a problem with one of the tables I am trying to move to another > database. > > The one field in the table is a char(30), and when I unload it, I get > this value in the unload file (the example is 1 column only, which > contains a pipe and carriage return): > > HOSPITAL|emergency^M\\ > > > > When I select this record in dbaccess or isql, only the word > "HOSPITAL"is displayed on the screen. > > Why does the full value not display on the screen during the > select ? > > > > This is in IDS7.31 FD3 > > > > The information on this e-mail including any attachments relates > to the official business of DigiCare (Pty) Ltd. The information is > confidential and legally privileged and is intended solely for the > addressee. Access to this e-mail by anyone else is unauthorised > and as such any disclosure, copying, distribution or any action > taken or omitted in reliance on it is unlawful. Please notify the > sender immediately if it has inadvertently reached you and do not > read, disclose or use the content in any way. > > > No responsibility whatsoever is accepted by DigiCare (Pty) Ltd if > the information is, for whatever reason, corrupted or does not > reach its intended destination. The views expressed in this e-mail > are the views of the individual sender and should in no way be > construed as the views of DigiCare (Pty) Ltd, except where the > sender has specifically stated them to be the views of DigiCare > (Pty) Ltd. > > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >