Library /sys$common/syshlp/CDDLHELP.HLB  —  JUSTIFIED_RIGHT
  The JUSTIFIED_RIGHT field attribute truncates  or  fills  a  TEXT  or
  UNSPECIFIED field from the left instead of from the right.

1  –  Usage Notes

   o  Only VAX  COBOL  supports  the  JUSTIFIED  RIGHT  clause.   Other
      language processors ignore it.

   o  Use this clause only  on  fields  whose  data  type  is  TEXT  or
      UNSPECIFIED.

  1 MISSING_VALUE

  The  MISSING_VALUE  field  attribute  clause  specifies  a  value  to
  indicate that a field has never been assigned a meaningful value.

2  –  Parameters

  fixed-point-number

  quoted-string

       The VAX DATATRIEVE missing value.

3  –  Syntax Rules

   o  The quoted string or fixed point  number  must  be  a  valid  VAX
      DATATRIEVE  expression for the field.  The CDDL compiler does not
      check for correct syntax.

   o  You can use 8-bit characters in CDDL quoted strings.

4  –  Usage Notes

   o  Only VAX DATATRIEVE supports  the  MISSING_VALUE  clause.   Other
      language processors ignore it.

   o  VAX DATATRIEVE treats a field containing  a  MISSING_VALUE  as  a
      special   case;   for  example,  VAX  DATATRIEVE  ignores  fields
      containing  a  MISSING_VALUE   when   it   performs   statistical
      operations.

5  –  Example

  The following example assigns a missing  value  of  0  to  the  field
  PRICE.   A  PRICE of 0 indicates to VAX DATATRIEVE that the value for
  PRICE is missing; VAX DATATRIEVE ignores records with PRICE equal  to
  0 when it performs operations involving the PRICE field.

  PRICE                       DATATYPE IS UNSIGNED NUMERIC
                              SIZE IS 8 DIGITS 2 FRACTIONS
                              MISSING_VALUE FOR DATATRIEVE IS 0.
Close Help