RE: **SOLVED *** RE: How IS theRecordFormatLevelIdentifiercalculated?

["Wilt, Charles" <CWilt@xxxxxxxxxxxx>]

Not true Joe.

If you create a SQL table and specify a primary key, you end up with a
keyed physical file that is keyed on the specified primary key.

Now, lets check the following:

CREATE TABLE CWLIBR/JEFF1 (MYCHAR CHAR ( 15) NOT NULL WITH DEFAULT,
MYDEC DEC ( 9, 2) NOT NULL WITH DEFAULT, PRIMARY KEY (MYCHAR))     

INSERT INTO cwlibr/JEFF1 VALUES('test', 1)

Create table cwlibr/jeff2                       
  as (select * from cwlibr/jeff1)               
  with data                                     
  including column defaults                     
  including identity column attributes          
  rcdfmt jeff1                                  

Interestingly enough, the Format Level Identifier is the same for both
files, even though JEFF1 is a keyed file and JEFF2 is not.

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx 
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Joe Pluta
> Sent: Thursday, September 28, 2006 10:02 AM
> To: 'Midrange Systems Technical Discussion'
> Subject: RE: **SOLVED *** RE: How IS 
> theRecordFormatLevelIdentifiercalculated?
>
> Oh heck, you'll NEVER get SQL to create a keyed physical, 
> Jeff.  SQL just
> doesn't understand the concept.
>
> Joe
>
> > From: Jeff Crosby
> >
> > That still doesn't do it.
> >
> > No data is in the new file.
> > No key on the new file. (access path is ARRIVAL)
> > File level ID and format level ID different.
> >
> > I think I'll stick with CRTDUPOBJ.  It's actually simpler 
> than what this
> > is
> > turning out to be.
>
>
> -- 
> 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.