Yes!! That's it, Andreas...thanks!
BTW, here's the link I've been using for ISQL, but I did not see the SET
OWNER example (or explanation of it). Where do you get that juicy piece
of info?
http://docs.hp.com/cgi-bin/doc3k/B3621690073.11839/17
Thanks,
Raymond Shahan
Information Systems
REPUBLIC TITLE OF TEXAS, INC.
2701 W Plano Parkway
Plano, TX 75075
direct 214.556.0202
main 972.578.8611
fax 972.424.5621
www.republictitle.com
[log in to unmask]
Life is not a journey to the grave with the
intention of arriving safely in a pretty and
well preserved body, but rather to skid in
broadside, thoroughly used up, totally worn out,
and loudly proclaiming:
-- WOW!!! What a Ride!!!
-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On
Behalf Of Andreas Baronick
Sent: Thursday, October 04, 2007 3:23 AM
To: [log in to unmask]
Subject: Re: [HP3000-L] ISQL QUESTION
Raymond,
You simply need to use the following ISQL command:
isql=> set owner DBNAME;
being DBNAME the name of your IMAGE database. You may find it convenient
to
put this command into to the ISQL profile ISQLPRO. This file holds
commands
to be executed every time you start ISQL.
Regards...
Andreas Baronick
On Wed, 3 Oct 2007 16:33:28 -0500, Ray Shahan
<[log in to unmask]> wrote:
>Hi all,
>
>
>
> I'm trying to use ISQL to access some IMAGE data. It
>appears that I have to qualify the table name each time I do a SELECT,
>and that's really annoying. I'm unable to locate in the manual where
it
>shows how to just be able to use the unqualified table name in a
select,
>so I thought I'd see if anyone out there knows?
>
>
>
>I have only 1 DB opened (connected), so it would seem a no-brainer that
>the table I want is in the DB I'm connected to.
>
>
>
>SELECT * FROM TABLE (this is what I want to do)
>
>
>
>SELECT * FROM DBNAME.TABLE (and this is what I have to do)
>
>
>
>The error, "Table/View [log in to unmask] not found. (DBERR 2206)"
>seems to indicate that, absent the DB name, ISQL is using my logon name
>and account as the DB name.
>
>
>
>
>
>TIA for any help.
>
>
>
>
>
><http://www.republictitle.com/>
>
> <http://www.republictitle.com/>
>
>
>
>Raymond Shahan
>
>Information Systems
> REPUBLIC TITLE OF TEXAS, INC. <http://www.republictitle.com/>
> 2701 W Plano Parkway
><http://maps.yahoo.com/maps_result?addr=2701+w+plano+parkway&csz=75075&
c
>ountry=us&new=1&name=&qty=>
>Plano, TX 75075
>
>
>
>
>direct 214.556.0202
>main 972.578.8611
>fax 972.424.5621
>
> www.republictitle.com <http://www.republictitle.com/>
>
>[log in to unmask]
>
>Life is not a journey to the grave with the
>intention of arriving safely in a pretty and
>well preserved body, but rather to skid in
>broadside, thoroughly used up, totally worn out,
>and loudly proclaiming:
>
>-- WOW!!! What a Ride!!!
>
>
>
>
>* To join/leave the list, search archives, change list settings, *
>* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
