MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » October 2004

RE: DSPFFD *OUTFILE Curiosity



fixed

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=






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact