Database field name

A database field name should have the following characteristics:

  • Can contain one to 18 bytes
  • Must begin with A through Z or a through z; other characters can include A through Z, a through z, 0 through 9, @, $, _, and #
  • Cannot be any of the Content Manager OnDemand reserved keywords:
    • annot
    • comp_len
    • comp_off
    • comp_type
    • doc_len
    • doc_name
    • doc_off
    • doc_type
    • pri_nid
    • res_comp_type
    • resource
    • sec_nid
  • Cannot be any of the keywords reserved by the database manager. See the documentation provided with your database manager product for a list of reserved words.
  • Can be mixed case. However, the case does not create a unique name (repDate is the same as repdate).
  • Must be unique to the application group.