Transfering data

Posted in 1999

Willaert Doris — Thu, 18 Nov 1999 13:53:51 +0100 — source: Informix-list mailing list archive (1991-1998)

I have an RS6000 with Informix 7.3 UC6 and an NT server with Microsoft SQL-server. I need to extract data from my Informix database and transfer it to the NT server. I know that I need an Informix client to do this, but can anyone tell me what products I exactly need ? TIA Doris Willaert doris.willaert@suzuki.be

↪ replying to Willaert Doris

Vardan Aroustamian — Thu, 18 Nov 1999 18:26:42 GMT — source: Informix-list mailing list archive (1991-1998)

In article <810u7g$2t3$1@news.xmission.com>, Willaert Doris <doris.willaert@suzuki.be> wrote: > > I have an RS6000 with Informix 7.3 UC6 and an NT server with Microsoft > SQL-server. I need to extract data from my Informix database and transfer it > to the NT server. I know that I need an Informix client to do this, but can > anyone tell me what products I exactly need ? > > TIA > > Doris Willaert > doris.willaert@suzuki.be > > You need telnet session to RS6000. Then run dbaccess, which is part of IDS 7.3. Make sure you have necessary environment variables: INFORMIXDIR and INFORMIXSERVER, and PATH contains $INFORMIXDIR/bin. Then you can unload whatever data you need unload to 'your_file.unl' select ... from ... where ...; Regards -- Vardan Aroustamian vaar@geocities.com Sent via Deja.com http://www.deja.com/ Before you buy.