|
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-2024 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.