Re: [Bulk] Format level identifiers on SQL tables?

[Charles Wilt <charles.wilt@xxxxxxxxx>]

The 10 character system names matter...

But long SQL Names don't.

Charles

On Wed, Apr 20, 2016 at 4:27 PM, Rob Berendt <rob@xxxxxxxxx> wrote:

> Apparently names do matter.
>
> CREATE TABLE ROB.XZ (
> MYCHAR1 CHAR (1 ) NOT NULL WITH DEFAULT,
> MYCHAR2 CHAR (2 ) NOT NULL WITH DEFAULT,
> MYCHAR3 CHAR (3 ) NOT NULL WITH DEFAULT
> ) rcdfmt xzr
>
>                       Record  Format Level
> Format       Fields   Length  Identifier
> XZR               3        6  2B1AB600655D4
>
> drop table rob.xz
>
> CREATE TABLE ROB.XZ (
> MYCHARA CHAR (1 ) NOT NULL WITH DEFAULT,
> MYCHARB CHAR (2 ) NOT NULL WITH DEFAULT,
> MYCHARC CHAR (3 ) NOT NULL WITH DEFAULT
> ) rcdfmt xzr
>
> Record Format List
>                        Record  Format Level
>  Format       Fields   Length  Identifier
>  XZR               3        6  2B17A6FD5C574
>
> drop table rob.xz
> run this again
> CREATE TABLE ROB.XZ (
> MYCHAR1 CHAR (1 ) NOT NULL WITH DEFAULT,
> MYCHAR2 CHAR (2 ) NOT NULL WITH DEFAULT,
> MYCHAR3 CHAR (3 ) NOT NULL WITH DEFAULT
> ) rcdfmt xzr
>
>                       Record  Format Level
> Format       Fields   Length  Identifier
> XZR               3        6  2B1AB600655D4
>
>
>
>
>
> Rob Berendt
> --
> IBM Certified System Administrator - IBM i 6.1
> Group Dekko
> Dept 1600
> Mail to:  2505 Dekko Drive
>           Garrett, IN 46738
> Ship to:  Dock 108
>           6928N 400E
>           Kendallville, IN 46755
> http://www.dekko.com
>
> --
> 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.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.