Re: informix and oracle

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