Re: new to informix

Bob Frank said: > 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? Not really. Is there not an oninit, tbinit or sqlexec process running somewhere? In general, dbschema -d <dbname> -t <tabname> should give you what you need on the schema and the dbaccess command allows the use of the UNLOAD statement with a SELECT to unload a set of data. If dbaccess doesn't work, try isql -q . Alternatively, dbexport <dbname> will unload the entire database into the current directory. Manuals are available from http://www-306.ibm.com/software/data/informix/pubs/ -- 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

A better set of documentation on IDS can be found in the new "IDS Information Center" at http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp. It's a great set of docs, and even Google will turn up hits from it. Thanks - Mark. Obnoxio The Clown wrote: > Bob Frank said: > > 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? > > Not really. Is there not an oninit, tbinit or sqlexec process running > somewhere? > > In general, dbschema -d <dbname> -t <tabname> should give you what you > need on the schema and the dbaccess command allows the use of the UNLOAD > statement with a SELECT to unload a set of data. > > If dbaccess doesn't work, try isql -q . > > Alternatively, dbexport <dbname> will unload the entire database into the > current directory. > > Manuals are available from > http://www-306.ibm.com/software/data/informix/pubs/ > > -- > > 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