Re: Read and write in different databases with the SE
Sorry but I have only 4gl 4.xx but there your can make following:
database db1
main
define
h_txt char(200)
# now you are in database 1
select .....
let h_txt = "database db2"
prepare prep_dbs from h_txt
if status != 0 then
display "prepare: ", h_txt clipped
sleep 3
exit program
end if
execute prep_dbs
if status != 0 then
display "Fehler bei execute:",sele clipped
sleep 3
exit program
end if
# now your are in database 2
select .....
end main
Live long and prosper!
Patric
Marc Beauvais <mbeauvais@wbn.ca> schrieb im Beitrag
<34637c48.89847213@news.magma.ca>...
> Enviroment : Informix SE 7.1.0
> Informix 4GL 6.02
> Platform AIX 4.1.2
>
> I'll like to know if somebody can tell me if it's possible to read and
> write in different databases with a 4gl program using the SE.
>
> I had help some from peoples that told me to use this syntax:
> INSERT INTO database@server:table
> SELECT * FROM database@server:table>
> ... but I have this error and don't no if it's my settings or my
> engiine that does not accept it:
>
> SQL statement error number -554
> syntax disallowed in this databases server.
>