[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] problem connecting to different database
- Subject: [sqr-users] problem connecting to different database
- From: ashwin reddy <ashwin443@yahoo.co.uk>
- Date: Fri, 5 Jan 2007 19:53:51 +0000 (GMT)
- Delivery-date: Fri, 05 Jan 2007 14:56:43 -0500
- Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.uk;h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID;b=xUk46DLYGEWqdlhKp7a8dN/D904c4CVogEEubG1QDgjF29rUge+veQ3mVRq8jTgHqrElsa/gmS9L6z6I5Wf29aFVftTA7bQ756xELrIknmbzjdb3pgpMKP7kkIfHwyepPHqbdkzP4CsW7fz8FKO8yDy4mApBRlCo84Y2LP+IaBE=;
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
we are runnin an sqr and it has to access data from two different oracle
databases from within the sqr. The default database is HRINT
here is a snippet of the code i am using
Begin-select
a.emplid
.....
from IT_PAY_LIST@prod a
end-select
if i run the select statement from oracle it connects to the prod database
without any problem...
do i need to initialize somethin at the begining of the sqr before using the
database link i created in oracle
Send instant messages to your online friends http://uk.messenger.yahoo.com
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users