RE: Ops Nav ISQL run history

["Phil" <sublime78ska@xxxxxxxxx>]

Jim,

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.

Phil



> 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