SQL Adapters: Support for SET HOLDATTR for Formats SAME_DB and SQL_SCRIPT

Example: Propagating TITLE and DESCRIPTION Attributes to a HOLD File in Format SQL_SCRIPT

The following request propagates TITLE and DESCRIPTION attributes to a HOLD file generated as format SQL_SCRIPT.

APP HOLD ibisamp
SET HOLDATTR=ON
TABLE FILE wf_retail_lite
SUM BUSINESS_REGION STATE_PROV_CODE_ISO_3166_2
BY BUSINESS_REGION NOPRINT 
BY STATE_PROV_CODE_ISO_3166_2 NOPRINT
WHERE BUSINESS_REGION EQ 'North America' OR 'EMEA'
WHERE STATE_PROV_CODE_ISO_3166_2 EQ 'AR' OR 'IA' OR 'KS' OR 'KY' 
OR 'WY' OR'CT' OR 'MA' OR '04' OR '11' OR '14'OR 'NJ' 
OR 'NY' OR 'RI'
ON TABLE HOLD AS HOLDATTR2 FORMAT SQL_SCRIPT
END

The generated Master File, holdattr2.mas follows. The TITLE and DESCRIPTION attributes were propagated from the wf_retail_lite Master File.

FILENAME=HOLDATTR2, SUFFIX=DATREC  , IOTYPE=BINARY, $
  SEGMENT=HOLDATTR, SEGTYPE=S0, $
    FIELDNAME=BUSINESS_REGION, ALIAS=E01, USAGE=A15V, ACTUAL=A15V,      MISSING=ON,
      TITLE='Customer,Business,Region', DESCRIPTION='Business Region', $
    FIELDNAME=STATE_PROV_CODE_ISO_3166_2, ALIAS=E02, USAGE=A5V, ACTUAL=A5V,      MISSING=ON,
      TITLE='Customer,State,Province,ISO-3166-2,Code', DESCRIPTION='The ISO-3166-2 Code for the State or Province', $
    FIELDNAME=NULLFLAG, ALIAS=__NULLFLAG__, USAGE=A2, ACTUAL=A2B, ACCESS_PROPERTY=(INTERNAL), $