|
midrange.com
Glenn, you might find the following useful. It is the screen shot of my
DSPFFD utility, showing the layout for the DSPFFD outfile record format
QWHDRFFD. I've chopped part of the Field Description to avoid as much
wrapping in the list email as possible, but you get the idea. If there were
keys on this file, you'd see those as well.
You know, I'm not even sure why I have the From & To positions anymore. An
OLD carryover from the S/36 days I guess.
hth,
db
File Field Specifications S1120558
10/26/04
File . . . . . : QSYS/QADSPFFD Type: Physical Created:
1/07/02
Record Format No: 1 of 1 Format Name: QWHDRFFD
Description: . .: Data base file for Display file field descriptions
Record Length . : 1040 Number of fields: 96
From To Field Name DataType Length Field Description
1 10 WHFILE Char 10 File
11 20 WHLIB Char 10 Library
21 27 WHCRTD Char 7 File creation date
28 28 WHFTYP Char 1 Type of file: P=Ph
29 33 WHCNT Z(5,0) 5 Number of record f
34 46 WHDTTM Char 13 Retrieval date: ce
47 56 WHNAME Char 10 Record format
57 69 WHSEQ Char 13 Format level ident
70 119 WHTEXT Char 50 Format text descri
120 124 WHFLDN Z(5,0) 5 Number of fields a
125 129 WHRLEN Z(5,0) 5 Record format leng
130 139 WHFLDI Char 10 Internal field nam
140 149 WHFLDE Char 10 External field nam
150 154 WHFOBO Z(5,0) 5 Output buffer posi
155 159 WHIBO Z(5,0) 5 Input buffer posit
160 164 WHFLDB Z(5,0) 5 Field length in by
165 166 WHFLDD Z(2,0) 2 Number of digits
167 168 WHFLDP Z(2,0) 2 Decimal positions
169 218 WHFTXT Char 50 Field text descrip
219 221 WHRCDE Z(3,0) 3 32=Data Type,64=Na
222 231 WHRFIL Char 10 Reference file
232 241 WHRLIB Char 10 Reference library
242 251 WHRFMT Char 10 Reference record f
252 261 WHRFLD Char 10 Reference field
262 281 WHCHD1 Char 20 Column heading 1
282 301 WHCHD2 Char 20 Column heading 2
302 321 WHCHD3 Char 20 Column heading 3
322 322 WHFLDT Char 1 Field type: B,A,S,
323 323 WHFIOB Char 1 I/O attribute: I=In
324 325 WHECDE Char 2 Edit code
326 357 WHEWRD Char 32 Edit word: Truncate
358 361 WHVCNE Z(4,0) 4 Number of validity
362 366 WHNFLD Z(5,0) 5 Number of fields
367 368 WHNIND Z(2,0) 2 Number of indicator
369 369 WHSHFT Char 1 Keyboard shift
370 370 WHALTY Char 1 Character field may
371 400 WHALIS Char 30 Alternative field n
401 402 WHJREF Z(2,0) 2 Join reference to J
403 404 WHDFTL Z(2,0) 2 DFT value length: -
405 434 WHDFT Char 30 DFT value: Truncate
435 435 WHCHRI Char 1 Character Id change
436 436 WHCTNT Char 1 Translation table u
437 446 WHFONT Char 10 Font identifier
447 449 WHCSWD Z(3,1) 3 Character size widt
450 452 WHCSHI Z(3,1) 3 Character size heig
453 462 WHBCNM Char 10 Barcode name
463 465 WHBCHI Z(3,1) 3 Barcode height:0=No
466 466 WHMAP Char 1 Substring specified
467 471 WHMAPS Z(5,0) 5 Substring starting
472 476 WHMAPL Z(5,0) 5 Substring number of
477 484 WHSYSN Char 8 System Name (Source
485 486 WHRES1 Char 2 Reserved
487 487 WHSQLT Char 1 SQL file type: 0=No
488 488 WHHEX Char 1 Hexadecimal: Y=Yes
489 491 WHPNTS P(4,1) 3 Point size: 0 = non
492 494 WHCSID P(5,0) 3 Coded Character set
495 498 WHFMT Char 4 Date and time form
499 499 WHSEP Char 1 '/', '-', '.', ','
500 500 WHVARL Char 1 Variable length fi
501 503 WHALLC P(5,0) 3 Allocated length
504 504 WHNULL Char 1 Allow Null Value:
505 514 WHFCSN Char 10 Font character set
515 524 WHFCSL Char 10 Char set lib, blan
525 534 WHFCPN Char 10 Font code page, bl
535 544 WHFCPL Char 10 Code page lib, bla
545 554 WHCDFN Char 10 Coded Font, blank
555 564 WHCDFL Char 10 Coded font lib, bl
565 574 WHDCDF Char 10 DBCS Coded Font, b
575 584 WHDCDL Char 10 DBCS font lib, bla
585 586 WHTXRT P(3,0) 2 Degree of text rot
587 591 WHFLDG Z(5,0) 5 Field length in ch
592 596 WHFDSL Z(5,0) 5 Alternate field le
597 599 WHFSPS P(4,1) 3 Font character set
600 602 WHCFPS P(4,1) 3 Coded font point s
603 605 WHIFPS P(4,1) 3 DBCS Coded font po
606 611 WHDBLL P(10,0) 6 LOB field length
612 739 WHDBUN Char 128 User-defined type
740 749 WHDBUL Char 10 User-defined type
750 750 WHDBFC Char 1 0=No control, 1=Fi
751 751 WHDBFI Char 1 0=Selective, 1=All
752 752 WHDBRP Char 1 0=Database, 1=File
753 753 WHDBWP Char 1 0=Blocked, 1=File
754 754 WHDBRC Char 1 0=No, 1=Yes, blank
755 755 WHDBOU Char 1 0=Delete, 1=Restor
756 756 WHPSUD Char 1 0=*NOCONVERT, 1=*CO
757 761 WHBCUH Z(5,2) 5 Barcode height usin
762 764 WHFPSW P(4,1) 3 Font point size wid
765 767 WHFSPW P(4,1) 3 Font character set
768 770 WHCFPW P(4,1) 3 Coded font point si
771 773 WHIFPW P(4,1) 3 DBCS Coded font poi
774 774 WHRWID Char 1 ROWID specified. Y=
775 775 WHIDC Char 1 Identity column. Y=
776 778 WHDROW Z(3,0) 3 Display row
779 781 WHDCOL Z(3,0) 3 Display column
782 1039 WHALI2 Char 258 Alternative field n
1040 1040 WHALCH Char 1 Alternate length 0=
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
