Re: How difficult is it to export data in Informix?

jimgundlach@direcway.com said: > > We are working with a company that provides an Informix database system > with web front ends to clients who have limited skills. The clients > run their own databases using these web base front ends. We need a > copy of one of the client's database excluding two fields. The > database apparently has three "pages". The first has about ten fields > is an applicant page which indicates sending, completion, and > acceptance of applicants. The second has about twenty fields and is a > person information page which includes applicant information and > indication of acceptance or not. The third has five fields and is an > activities page which reports up to about twenty activities with each > accepted applicant. The two fields to be deleted are on the person > information fields. The local client says they do not know how to > produce the data and have contacted the company that provides the web > based front end and asked them to produce another web based tool to > dump the desired data. In addition to wanting to know how much writing > such a tool should cost, I'm interested in knowing if the local system > admin. should be able to produce the files, delimited text is fine, > without having to pay for writing a custom tool. This really seems > like a simple task to me. I've worked with a couple of other database > programs and it would be quite simple to do this in them. And, I just > don't see how informix could be as sucessful as it is if exporting > selected data is so difficult. The dbaccess UNLOAD command is your friend. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ` dire qu'il faut fermer sa gueule" - Coluche did i mention i like nulls? heck, i even go so far as to say that all columns in a table except the primary key could/should be nullable. this has certain advantages, for example, if you need to insert a child record and you don't have a parent row for it, just do an insert into the parent table with the primary key value (everything else null), and voila, relational integrity is preserved. but this is, admittedly, a bit controversial among modellers. --r937, dbforums.com sending to informix-list