UNLOAD question.

Posted in 1999

Topics: Migration, Import/Export & Data Conversion

Suhas Tembe — Mon, 19 Jul 1999 19:08:45 -0400 — source: Informix-list mailing list archive (1991-1998)

Huy, I am trying to 'unload' a table, drop it, re-create it & load it back up. There are certain columns that have been defined as char which contain either 'spaces' or 'nulls'. ex : if a row has the following values : A 09987 null PPK spaces Y the 'unloaded' data looks like this : A|09987||PPK||Y| The problem is, when I load this data back into the table, the row looks like this : A 09987 null PPK null Y Truly speaking, the unloaded data should look like this : A|09987||PPK| |Y| (note : there is a space between 'PPK' and 'Y') Is there a solution to this ?? I have around 15 columns which are either 'nulls' or 'spaces'. Is there any other utility which I can use? Thanks. Suhas Suhas Tembe Home : (770)-803-0161 Email : stembe@msn.com Place : Atlanta, GA

↪ replying to Suhas Tembe

Suhas Tembe — Mon, 19 Jul 1999 19:34:08 -0400 — source: Informix-list mailing list archive (1991-1998)

Oops, I forgot, I have Informix 7.24 running on HP-9000. Thanks. Suhas -- Suhas Tembe Home : (770)-803-0161 Email : stembe@msn.com Place : Atlanta, GA Suhas Tembe <stembe@email.msn.com> wrote in message news:#1eU9tj0#GA.341@cpmsnbbsa03... > Huy, > > I am trying to 'unload' a table, drop it, re-create it & load it back up. > There are certain columns that have been defined as char which contain > either 'spaces' or 'nulls'. > > ex : if a row has the following values : > > A 09987 null PPK spaces Y > > the 'unloaded' data looks like this : > > A|09987||PPK||Y| > > The problem is, when I load this data back into the table, the row looks > like this : > > A 09987 null PPK null Y > > Truly speaking, the unloaded data should look like this : > > A|09987||PPK| |Y| (note : there is a space between 'PPK' and 'Y') > > Is there a solution to this ?? I have around 15 columns which are either > 'nulls' or 'spaces'. > Is there any other utility which I can use? > > Thanks. > > Suhas > > Suhas Tembe > Home : (770)-803-0161 > Email : stembe@msn.com > Place : Atlanta, GA > >

↪ replying to Suhas Tembe

Yuri Dovgart — Tue, 20 Jul 1999 06:51:08 GMT — source: Informix-list mailing list archive (1991-1998)

In article <#1eU9tj0#GA.341@cpmsnbbsa03>, "Suhas Tembe" <stembe@email.msn.com> wrote: > Huy, > > I am trying to 'unload' a table, drop it, re-create it & load it back up. > There are certain columns that have been defined as char which contain > either 'spaces' or 'nulls'. > > ex : if a row has the following values : > > A 09987 null PPK spaces Y > > the 'unloaded' data looks like this : > > A|09987||PPK||Y| > > The problem is, when I load this data back into the table, the row looks > like this : > > A 09987 null PPK null Y > > Truly speaking, the unloaded data should look like this : > > A|09987||PPK| |Y| (note : there is a space between 'PPK' and 'Y') > > Is there a solution to this ?? I have around 15 columns which are either > 'nulls' or 'spaces'. > Is there any other utility which I can use? > Try dbexport with -x option - this will unload your data in hexadecimal format, that save your 'spaces'. Hope, this help. -- With best regards, Yuri Dovgart, SAP R/3, Informix consultant, "Telecominvest" company. E-mail y_dovgart@tci.ukrtel.net Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.