Re: informix and oracle

In article <366ED4D8.2231@bloomberg.net>, kagel@bloomberg.net wrote: > worcester@rocketmail.com wrote: > > > > In article <74jokv$2hs$1@news.xmission.com>, > > Sandra Ward <sandraw@peregrine.ie> wrote: > > > > > > Hi all, > > > just regarding my recent query - I want to make an amendment . = > > > Apparently, what we really need to do is fire an informix stored = > > > procedure from SQL*Plus or a pl/sql stored procedure if possible. Any = > > > ideas on this. > > > Thanks > > > Sandra > > > > > > > > If you can execute a system command from sqlplus you could retreive the data > > through an unload. This would produce an ascii file that would have the fields > > delimited with a "|". > > > > the command to extract the data on the informix side would look like this; > > > > isql dbname<<+ > > unload to /tmp/datafile > > select * from table where feild = value> > + > > That will not work. The unload command is not built into the Informix > engine, it is not part of SQL, it is a dbacess built-in and as such > isnot available through Oracle's sqlplus. > > Art S. Kagel > I need to clarify. Create a shell script(assuming informix is on a unix system) that contains the following; isql dbname<<+ unload to /tmp/datafile select * from table where field = value + Make this script file executable. This is the command that runs on the same machine as informix and extracts the data to an ascii file. -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own