Re: Create Table for Previous Release

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Chris,

Have you tried it?  What error messages do you get?

I can create a basic table on v5r4 and save it with SAVOBJ
TGTRLS(v5r2m0) without error...

Though I don't have a v5r2 box to try restoring it to.

Charles

On Tue, Mar 27, 2012 at 1:24 PM, Chris Bipes
<chris.bipes@xxxxxxxxxxxxxxx> wrote:
> How does one create a new table and access paths within SQL for a previous release.  The TGTRLS parameter does not apply to the CREATE TABLE.  I need to save/restore these new files  and access paths on machines that have not yet been upgraded.  We are creating the new stuff on V6R1 and trying to put onto V5R4.
>
> I can manually create the files on the remote systems using RUNSQLSTM but that bypasses Mimix, which then tries to mirror back to production.
>
> Is it possible to CREATE TABLE or CREATE INDEX for previous release?
>
> --
> Chris Bipes
> Director of Information Services
> CrossCheck, Inc.
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.