Thanks, Robert.
Ok, maybe another approach to this question: In SUPRTOOL or QUERY, when
I do a FORM command, I get 'key' info (what item(s) is/are the key(s)
and what item is the primary key, sorted path, etc.), but I'm not having
much luck finding that info using either IMAGESQL or ISQL (via the
online help).
I've located a hard copy of the ISQL manual, so I guess I'll start at
page 1, and read the entire manual until I get what I need. I was just
hoping that I could cruise through a few commands in help, and get a
feel for using ISQL with IMAGE, but looks as though I was wrong (of
course, it could just be me, too).
Thanks to all, and have a great weekend!
Raymond Shahan
Computer Programmer
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]
-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On
Behalf Of Robert Mills
Sent: Friday, December 08, 2006 4:03 AM
To: [log in to unmask]
Subject: Re: [HP3000-L] ISQL and the INFO command
Ray,
Not within ISQL but it can be done with a bit of scripting.
BTW: I think that Flexibase/SQL has a command that can do this.
regards,
Robert W.Mills
Systems Development Manager
Pinnacle Arvato
(020) 8309 3604
-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On
Behalf Of Ray Shahan
Sent: 07 December 2006 22:28
To: [log in to unmask]
Subject: [HP3000-L] ISQL and the INFO command
Hi all,
Is there a way in ISQL to see all of the tables in an IMAGE
DB? The INFO command will only show you the columns of a table if you
know the table name, but I'd like to be able to connect to a DB, and see
all of the tables. In other words, does ISQL have a corresponding
command for FORM in QUERY (or SUPRTOOL)?
TIA,
<http://www.republictitle.com/>
Raymond Shahan
Computer Programmer
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]
* 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 *
|