Re: SQL problem accessing another database

YEAP >From: Peter Wages <pmwages@chele.cais.net> >To: informix-list@iiug.org >Subject: SQL problem accessing another database >Date: Tue, 5 Oct 1999 10:01:09 -0400 (EDT) > >Hey , I know this is crazy but we're still using ESQLCOBOL. We're having >a peculiar > compile problem, Have an Declare SQL statement where we want to >acccess >a table in another Informix database. This other database can change from >development to production of course, so the database is in a variable. > >Below is SQL > > exec SQL > declare data_entry_csr cursor with hold for > select data_entry_id, > batch_type_code, > transaction_data, > date_data_entered, > needs_verific_date, > date_verified, > csr_id, > ss_index_value >13 from :de-database-server,>13 data_entry > where data_entry_id > 0 and > batch_type_code in >102296 ('76' , '84' , '85', '86', '87', '88') >082796 and ( ( update_lock is null and >082796 date_verified is null ) >082796 or >082796 ( update_lock = '2' and >082796 date_verified is not null) ) > order by batch_type_code, data_entry_id > end-exec. > >Compiler doesn't like :de-database-server. > > Is the only way to do this through a prepare statement. > > >ciao >p > >****************************************************************************** >Peter Wages >pmwages@cais.com >Work: (703) 741-7436 Home: (703) 528-9569 >****************************************************************************** > > > ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com