Re: Object Authority Issue - Sometimes

[Jerry Adams <jerry@xxxxxxxxxxxxxxx>]

Luis,

Thanks; I never paid much, if any, attention to the Format tab in the 
Generate SQL dialog box.  On my system it is now set to (*SYS).  I am 
guessing that it was (*SQL) before I changed the JDBC connection 
property.  I say that because I generated the SQL for my test table and 
the source is in the format of Library/Table, while it was Library.Table 
before.

However, changing the JDBC connection property to Naming(*SYS) still 
generated a table with *PUBLIC(*Exclude), which was my original concern 
- I think.

	* Jerry C. Adams
*IBM System i Programmer/Analyst
B&W Wholesale Distributors, Inc.* *
voice
	615.995.7024
fax
	615.995.1201
email
	jerry@xxxxxxxxxxxxxxx <mailto:jerry@xxxxxxxxxxxxxxx>



Luis Rodriguez wrote:
> 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
>