Re: new to informix

Bob Frank said: > Thanks for clues. After getting the environment vars right and logging in > as > the informix user, I'm able to do it. > I used dbexport to export the schema and tables. > But now I'm a bit confused because I don't see any keys. > How do I see the key for each table? The indexes should be shown in the schema. If they didn't create the database with referential integrity, then you will not see any evidence of it ... because it's not there. :o) > "Bob Frank" <bgf@jgatech.com> wrote in message > news:d87295$hh@dispatch.concentric.net... >> Hello, >> I'm just trying to get started with a database I inherited. It's >> informix > on >> aix. I don't know the first thing about informix but I want to get a >> look > at >> the database schema and then start to extract data using sql from a > windows >> box. If someone would point me in the right direction, it'd be greatly >> appreciated. The process for sql is > /usr/local/vision/bin/sqlr.inf40.d -p5. >> Does that give any clue regarding what release of informix this is? >> >> > > -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche A smile is a gift that is free to the giver and precious to the recipient. But giving someone the finger is free too, and I find it more personal and sincere. sending to informix-list