RE: How to dump data to flat file?

What version and platform are you on? What type of data are you unloading. For simple data types and relatively small amounts of data, you could consider using dbaccess. It's somewhat similar to sql+ . -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]On Behalf Of John Doe Sent: Wednesday, February 25, 2004 2:34 PM To: informix-list@iiug.org Subject: How to dump data to flat file? I am an Oracle DBA but a tyro at Informix. [1] Need to get some data out of tables with names like: informix.sometable root.another_table ...etcetera. Evidently it's <owner>.<tablename> as in Oracle, and I've determined that these are all in the same "dbspace" (there's only one). WHAT I'VE TRIED: Figured out how to get into the menu-driven "onmonitor," but when I choose to display Dbspaces -> Info it just gives me the name of the dbspace, and Status-> Databases just gives me the names of three databases. "esql" just prints out the help page for esql. (I was going to try a DESCRIBE on these tables to get column descriptions, and then SELECT * FROM ...). I am timorous about trying any of the options for fear of doing something to this production system. THE QUESTION: How to get to the table information so I can do a SELECT * FROM <tablename> and dump it into a flat file? Everything in your FAQ is already over my head. I downloaded the manuals in *.pdf format and have been pouring over the "Informix Guide to SQL: Reference" and "Administrator's Guide" to no avail. ("Getting Started" was about installation.) As a reward for help, you all can hit me up by e-mail with any Oracle questions you may have now or in the future. ----------------------------- [1] Tyro is the "real" word for "newbie." Look: http://www.m-w.com sending to informix-list