Re: How difficult is it to export data in Informix?
Should be bloody simple. Assuming someone involved
possesses even low level DBA skills and access as a
DBA to the server housing the database you should be
able to write a SQL statement to do something similar
to the following based on Informix RDBMS and version
you are using;
UNLOAD to "FILENAME" SELECT * FROM TABLENAME WHERE1=1;
Given multiple tables within the database this will
create a Pipe Delimited file named "FILENAME".
Suggest you make the filename equal something like
TABNAME.YYYYMMDD
To quote the clown "RTFM". Ok so that was nicer than
what the clown would say but you get the point. If
your client is in the US and you really want to bring
in an expert contact me. :-D
Rob Vorbroker
--- jimgundlach@direcway.com wrote:
> 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.
>
>
Rob Vorbroker Phone: 513/309-1112
sending to informix-list