Re: SQL Table rename problem

[Glenn Gundermann <glenn.gundermann@xxxxxxxxx>]

Hi again,

I think I misread what you were doing.
You're right.  It doesn't like when both are valid system names.

Interesting.


Yours truly,

Glenn Gundermann
Email: glenn.gundermann@xxxxxxxxx
Work: (905) 795-2111 ext. 3098
Cell: (416) 317-3144


On 3 November 2014 17:22, Glenn Gundermann <glenn.gundermann@xxxxxxxxx> wrote:
> Hey John,
>
> I tried it on my system and it was fine.  We're on 6.1.
> rename table zgxgs85.emp to this_is_a_test for system name emp;
> Yours truly,
>
> Glenn Gundermann
> Email: glenn.gundermann@xxxxxxxxx
> Cell: (416) 317-3144
>
>
> On 3 November 2014 16:36, John R. Smith, Jr. <smith5646@xxxxxxxxx> wrote:
> > We have an external system with a data connection that is using SQL to
> > insert data into files/tables on the iSeries.
> >
> >
> >
> > To not have PF names like STG_Ixxxxx where xxxxx is a one up sequence
> > number, I was doing the following rename in the create script
> >
> >
> >
> > RENAME TABLE IIASTGFIL/STGWHSE
> >
> >   TO STG_IN_WH
> >
> >   FOR SYSTEM NAME STGWHSE
> >
> >
> >
> > This appears to work until I get to a table name of 10 characters or less as
> > in the above example.  When I try to do this rename, it fails with the error
> > SQL7029  30     229  Position 7 New name STG_IN_WH is not valid.  It appears
> > that if I include the "FOR SYSTEM NAME", then the table name must be > 10
> > characters and if I omit it, the file name becomes STG_Ixxxxx.
> >
> >
> >
> > The table names have already been defined in the external systems and
> > documentation and getting them changed is going to be a feat just short of
> > moving Mt. Everest.
> >
> >
> >
> > I have less than 5% of the files hitting this problem and I don't want
> > different rules for just these few that will confuse someone down the road.
> > For example, I don't want an index (STG_IN_WHS) built over these few which
> > makes them different than all the rest.  I also don't want these few named
> > differently (STG_IN_WH, etc.) while the rest are named with regular iSeries
> > files names such as STGSTORE (instead of STG_IN_STO).
> >
> >
> >
> > Does anyone have any ideas how I can get past this wall without having a
> > bunch of one-offs?