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

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.