Joined: 07 Jun 2005 Posts: 70 Location: South Africa
As William said a different slect statement is required. For flat files access mode and organization must be sequential. For relative record files, organization is relative, access mode can be sequential, random or dynamic and the same goes for key-sequential files where access mode is concerned. For key-sequential files organization is indexed and a record key must be declared. For RR files a relative key must be declared. This is off of the top of my head but should make the differences in the select statement clearer.