Re: Database

["Mosley, Banessa" <Banessa_Mosley@MAIL.CI.BALTIMORE.MD.US>]

I believe that you can also use a database link in the SQR program to
access multiple databases....at least I know you can to that in Oracle.
Your DBA will  create the link and you can access the database using the
link.  The statement would look something like this:

begin-SELECT
VCHR.VOUCHER_ID
VCHR.INVOICE_ID

FROM PS_VOUCHER@FDEV  (FDEV - the database link name)

end-SELECT

I hope this helps.

Banessa Mosley
Business Information Technology

> -----Original Message-----
> From: Michael Lee [SMTP:MLee@AGCONSULT.COM]
> Sent: Tuesday, July 07, 1998 6:37 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Re: Database
>
> What database environment are you on?  It is possible to access
> multiple
> databases.  In DB2, you can prefix the table name with the DB owner.
> As
> long as you have access to both DBs, you should be fine.  One thing is
> that
> the DB owner IDs have to exist on the same subsystem.
>
>
> Michael K. Lee
> mlee@agconsult.com
> Consultant
> AG Consulting, an ADP Company
>
>
>
>
>
> chien-wei.j.liao@AC.COM on 07/07/98 01:57:10 PM
>
> Please respond to SQR-USERS@USA.NET
>
> To:   SQR-USERS@list.iex.net
> cc:    (bcc: Michael Lee/Application Group)
> Subject:  Re: Database
>
>
>
>
> Hi,
> Does anyone know whether if it is possible for the SQR program to be
> located in one
> database and yet retrieve data from another database within the same
> server?  If so,
> how can it be accomplished?
>
> Thanks in advance!
> Jimmy Liao