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

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.