![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
The user_attrib table holds the definitions of all iProcess attributes defined on the system.
This key enforces the DELETE CASCADE referential action.
The user_attrib table contains one or more rows for each iProcess attribute defined on the system. If an attribute’s maximum length is defined as:
• 25 characters or more, one row is created for each 24 characters of the attribute’s maximum length, and a number is appended to the attribute_name entry for each row.
• DESCRIPTION is a system-defined attribute of type ASCII with a maximum length of 24 characters; one row is therefore added to the table.
• QSUPERVISORS is a system-defined attribute of type ASCII with a maximum length of 48 characters; two rows are therefore added to the table - QSUPERVISORS_01 and QSUPERVISORS_02, each with a unique attribute_id.
• JOBDESC is a user-defined attribute of type ASCII with a maximum length of 60 characters; two rows are therefore added to the table - JOBDESC_01 and JOBDESC_02, each with a unique attribute_id.
a Move System Information is performed, if the flag_table indicates that the Users data area has been modified. a Move System Information is performed, if the flag_table indicates that the Users data area has been modified.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |