Re: SQL Table rename problem

[Glenn Gundermann <glenn.gundermann@xxxxxxxxx>]

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?