It's been available for some time.  What I do is install the entire CAE.
Then explore.  A real nice thing you can do with ISQL is copy the result and
paste it into excel.  Great for ad hoc reports.

Another neat thing you can do is see the file properties.  Expand Database,
expand a library, then right click on a file and select 'properties'.  If
you have SQL tables it's really nice because you can see all the contraints,
indexes, & views.  You can add and delete too.  You can also add/delete
triggers here, drop/add columns - great stuff.  For DDS files it's easier to
do DSPFD/DSPFFD or view the source code.

In V5, which I don't have so haven't tried yet, you can reverse engineer you
tables.  That is, it will create the SQL DDL from the file definition.
There is a redbook or redpiece about this.


> Message: 4
> From: "Norbut, Jim" <Jim.Norbut@Grubb-Ellis.com>
> To: "'midrange-l@midrange.com'" <midrange-l@midrange.com>
> Subject: RE: Ops Nav ISQL run history
> Date: Fri, 21 Dec 2001 08:46:07 -0600
> Reply-To: midrange-l@midrange.com
> How/where do you get ISQL through Operations Navigator ?
> I have never seen or used that before.....is it a separate
> purchase or only
> on V5R1 or have I just not looked deep enough into it ?
> I have V4R5 of Operations Navigator.
> I would love to be able to use ISQL if possible through the Operations
> Navigator
> Jim Norbut
> Systems Administrator
> Grubb & Ellis Company
> Phone         (847) 753-7620
> Fax   (847) 753-9854

Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.