ca.portal.admin

Index key length

Discussion created by ca.portal.admin on Feb 9, 2007
What is the maximum length (in bytes) of an index key?

Kay Rozeboom
State of Iowa
Information Technology Enterprise
Department of Administrative Services
Telephone: 515.281.6139 Fax: 515.281.6137
Email: Kay.Rozeboom@Iowa.Gov

"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: [IDMSVENDOR-L] Index key length
"from 13.6 of the Database Administration manual: (set statement)


Sort-element-name specifies the name of a group or elementary data
item defined in an element description statement for the named member
record type, with the following restrictions:

· No element named FILLER can be used in the sort control element.

· No element that redefines another element or is subordinate to an
element that redefines another element can be used in the sort
control element.

· No repeating element (that is, one defined with an OCCURS clause)
and no element subordinate to a repeating element can be used in
the sort control element.

· No element exceeding 256 bytes can be used in the sort control
element.

·





Chris Hoelscher
IDMS & DB2 Database Administrator
Humana Inc
502-710-3038
choelscher@humana.com




The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.

"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Index key length
"What is the idd description of the 2 elements, as defined by the record being indexed?

Scott J. Brady
Holland America Line

Outcomes