You mean like INFO ?
Denys
-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On Behalf
Of Ray Shahan
Sent: Thursday, December 07, 2006 4:54 PM
To: [log in to unmask]
Subject: Re: [HP3000-L] ISQL and the INFO command
Thanks Mike. I was aware of that construct, however, it just gives me
the table names - what I wanted was a dump of the table names and the
columns within it (as in FORM). I can get the dump style I want using
IMAGESQL, but it'd be great if I could do it while in ISQL, too.
Again, thanks for your reply.
<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]
________________________________
From: [log in to unmask] [mailto:[log in to unmask]]
Sent: Thursday, December 07, 2006 4:48 PM
To: Ray Shahan
Cc: [log in to unmask]
Subject: Re: [HP3000-L] ISQL and the INFO command
Ray,
How about select * from system.table where owner=dbname
Michael Berkowitz
Project Manager, CGS Application Solutions
707 Wilshire Blvd Suite 1900
Los Angeles, CA 90017-3509
T: 213 614-1308
F: 213 614-2028
[log in to unmask]
Ray Shahan <[log in to unmask]>
Sent by: HP-3000 Systems Discussion <[log in to unmask]>
12/07/2006 02:27 PM
Please respond to
Ray Shahan <[log in to unmask]>
To
[log in to unmask]
cc
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 *
|