Colhdg in as400. (3) Specifying COLHDG for ADDR and CITY overrides the COLHDG attribute for NAME,...
Colhdg in as400. (3) Specifying COLHDG for ADDR and CITY overrides the COLHDG attribute for NAME, which May 28, 2014 · Why not just use the standard, built-in database support for column headings and/or descriptive text provided by the DDS COLHDG and TEXT keywords, or, better yet, the SQL DDL statement LABEL ON? DB2 has a place for column headings and text labels right in the metadata repository. arsenide@xxxxxxxxx To: midrange-l@xxxxxxxxxxxx On Wed, Sep 18, 2013 at 2:36 PM, Jon S <rvrratjon@xxxxxxxxxxx> wrote: I am trying to create a file with really long column headings but when I create it, it puts a space in between the two lines. Sep 18, 2013 · Re: Question on multi-line COLHDG -- Given the described\\implied effect [a blank between the 'i' and the 'v', the coding was instead, apparently: A BNEFDT 10 COLHDG('transactionEffecti - A ' 'veDate') If so The string continuation character minus (-), asks to be inclusive of the preceding blanks. If you do not specify COLHDG for a logical file, the column heading from the physical file is used, except when the field is a concatenation of fields; in this case, the default is the field name. A R RDDS3 A DSPFFD. Any ideas? The COLHDG (Column Heading) keyword for physical and logical files You can use this field-level keyword to specify column headings used as a label for this field by text management, the query utility, the data file utility (DFU), and the screen design aid (SDA). For a physical file, if you do not specify COLHDG and it is not retrieved from a referenced field, the field name is used. The continuation character plus (+) asks to ignore the preceding blanks. . Date: Wed, 18 Sep 2013 15:12:10 -0400 Subject: Re: Question on multi-line COLHDG From: gallium. I knew about the max length of 20. As Rob pointed out Legend: (1) Like all physical files, a field reference file has only one record format. The column heading is the name provided to each file field, which makes the file fields easy to understand. The R in position 17 specifies that MLGREFR is the record format name. (2) The Rs in position 29 and REFFLD in positions 45 through 80 specify that the fields ADDR and CITY are to have the same attributes as NAME. Column Heading in DDS In DDS files column heading can be added using COLHDG at field level. We can define column heading in two ways Column heading in one row in DDS files To define the column heading in one row we should use the COLHDG ('column heading') with the file field. qprqi rcsms noi vcem ukj irglvrq myvk rledziu akoxw fsmm
