Re: Questions about S/36 files

James,

The key has to be contiguous.
quiz:
How long is the key below?
At what field position does it start?
How many fields (columns) does it have?
What is/are the name of the key(s)?


STRS36
BLDFILE <F4>
Name of file to be created . . . . . . . . . . . . . . . . . . JIMMY
Type of file . . . . . . . . . . . . . . . . . . . . . . D,I,S I
Size of file is in block or records . . . . . . BLOCKS,RECORDS RECORDS
Size of file to be created . . . . . . . . . . . . . 1-8000000 10
Length of record in bytes . . . . . . . . . . . . . . . 1-4096 40
Preferred disk location . . . . . . . A1,A2,A3,A4,block number
Type of file retention . . . . . . . . . . . . . . . . . T,J,S T
Starting position of key . . . . . . . . . . . . . . . 1-4096 14
Length of key . . . . . . . . . . . . . . . . . . . . . . 1-120 10
Delete capable file option . . . . . . . . . . . NDFILE,DFILE NDFILE
Allow duplicate keys . . . . . . . . . . . . . NODUPKEY,DUPKEY NODUPKEY

DSPFFD
Record Format Information
Record format . . . . . . . . . . . . . . . : JIMMY
Format level identifier . . . . . . . . . . : 1D505BB0CC354
Number of fields . . . . . . . . . . . . . : 3
Record length . . . . . . . . . . . . . . . : 40
Field Level Information
Data Field Buffer Buffer Field Column
Field Type Length Length Position Usage Heading
F00001 CHAR 13 13 1 Both
Keyboard shift . . . . . . . . . . . . . : A
Coded Character Set Identifier . . . . . : 65535
K00001 CHAR 10 10 14 Both
Keyboard shift . . . . . . . . . . . . . : A
Coded Character Set Identifier . . . . . : 65535
F00002 CHAR 17 17 24 Both
Keyboard shift . . . . . . . . . . . . . : A
Coded Character Set Identifier . . . . . : 65535


DSPFD
Record format . . . . . . . . . . . . . . . : JIMMY
Key field . . . . . . . . . . . . . . . . : K00001
Sequence . . . . . . . . . . . . . . . : Ascending
Sign specified . . . . . . . . . . . . : UNSIGNED
Zone/digit specified . . . . . . . . . : *NONE
Alternative collating sequence . . . . : No

Rob Berendt