Cheatsheet/File

Filetypes

All Files are basically ENSCRIBE files, even SQL-MPy SQL-MX or OSS (posix) files.

Limits

Complarison of Format1 vs Format2 files

	Format1	Format2
Disk file partition size	2 GB minus 1 MB	1TB
Single-partitioned disk file size	2 GB minus 1 MB	1TB
Multipartitioned disk file sizes (key-sequenced)	16 TB	16 TB (for 16 partitions) 63 TB (for 64 partitions) 127 TB (for 128 partitions)
Multipartitioned disk file sizes (not key-sequenced)	4 GB minus 4 KB	1TB
Structured disk file record sizes: :Entry-sequenced

Filetypes

Short	Type	Header text
U	Unstructured	Example
R	Relative file
E	Entry-sequenced
K	Key-sequenced

File security (rwep)

Short	Type
r	Read
w	Write
e	Execute
p	Purge

Values for rwep

Short	Type
****	Safeguard protected (file mode only)-Local super ID only
O	Owner only (local)
G	Member of owner's group (local)
A	Any user (local)
U	Member of owner's user class—owner only (local or remote)
C	Member of owner's community—member of owner's group (local or remote)
N	Any user (local or remote)

• SQL SQL/MX object

NOTE:

For an OSS file, a 10-character OSS security vector appears in the RWEP column. (The vector extends into the TYPE column.) For more information, see the Open System Services User’s Guide.

NOTE:

If an OSS file has a POSIX ACL protection, FUP INFO displays a plus sign (+) after the permissions. However, if FUP INFO is executed remotely from a system without ACL support, “+” will not be printed for files with optional ACL entries. This feature is supported only on systems running G06.29 and later G-series RVUs and H06.08 and later H-series RVUs