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 *
|