Re: Object Authority Issue - Sometimes

[Luis Rodriguez <luis.rodriguez2@xxxxxxxxx>]

Vernon, Jerry

AFAIK, the JDBC settings option in "RUN SQL Scripts" (under
connect) does not change or set the default for either the
"Show definition" or the "Generate SQL" options found in
other parts of iNav. That said, the "Generate SQL" has a 
FORMAT Tab that allows you to select either *SYS or *SQL
naming conventions.


Regards,

Luis Rodriguez 

--- midrange-l-request@xxxxxxxxxxxx wrote:
> message: 4
> date: Thu, 28 Feb 2008 07:40:36 -0600
> from: Vernon Hamberg <>
> subject: Re: Object Authority Issue - Sometimes
>
> Jerry
>
> I've not checked other places, but the "Run SQL
> statement" iNav 
> thingy has a JDBC options item somewhere - you can set
> naming there - 
> it might apply generally within iNav.
>
> HTH and saves you writing a DCR!
> Vern
>
> At 06:32 AM 2/28/2008, you wrote:
>
> > Ed,
> >
> > Now that makes sense.  When I compile using the
> RUNSQLSTM command, I use
> > the *Sys naming convention.  iNav does not (that I can
> find) provide and
> > option.  I know that the SQL generated by iNav defines
> the table using
> > SQL convention (Library.Table, rather than
> Library/Table).
> > I was going to put in a PMR this morning just to get an
> answer.  I still
> > may or, better, submit a requirement to IBM to provide
> the option in
> > iNav at COMMON's iSociety portal:
>
> http://isociety.common.org/secureweb/auth?link=/secure/featurerequest.htm
> .
> > Thanks.
> >
> >         * Jerry C. Adams
> > *IBM System i Programmer/Analyst
> > B&W Wholesale Distributors, Inc.* *
> > voice


Luis Rodriguez

IBM Certified Systems Expert
eServer i5 iSeries Technical Solutions


      ____________________________________________________________________________________
Looking for last minute shopping deals?  
Find them fast with Yahoo! Search.  http://tools.search.yahoo.com/newsearch/category.php?category=shopping