Use the Schema Designer to add a column in the database.
Follow these steps:
The Add New Column dialog opens.
WSP verifies that you added the prefix, but adds a z to the beginning of the column name if necessary.
(Display-only) Specifies the object name of the column. For example, the object name of the Contact alt_phone column is alt_phone.
Specifies the user-friendly name of the column. You can change the Display Name of a column by entering another name in this field. For example, the display name of the Contact alt_phone column is alternative phone.
(Read-only for standard tables) Specifies the name used to refer to the column in CA SDM utilities, such as pdm_userload. For site-defined tables, Schema Name defaults to the Object Name. You can change the Schema Name by entering another value in this field.
(Read-only for all tables) Specifies the name used to refer to the table in the physical DBMS. For site-defined tables, the DBMS Name equals the same as Schema Name.
Provides a brief description of the column.
(Read-only for all standard columns in standard tables, and saved site-defined columns) Specifies the data type of the column. You can specify or change the field type of new site-defined columns by selecting a value from the drop-down. The following list describes the available Field Types:
Indicates a numeric value.
Indicates a text string. The String Length field indicates the number of characters in a string.
Indicates a date and time. The integer value stored in the database contains the number of seconds since midnight on January 1, 1970.
Indicates a period of time. The value stored in the database is an integer containing a number of seconds.
Indicates a real (floating point) number.
Indicates a foreign key reference to another table. The SREL Table field specifies the referenced table. The value stored in the database is the rel attr of the referenced table, which can be either an integer or a string. The value displayed in the product is the common name of the referenced table row. For information on setting SREL attributes with foreign key values, see the Technical Reference Guide.
Indicates a virtual column representing the set of all objects with an SREL to this table. It exists only in the Object Engine and is not physically stored in the database. Select this field type only on direction from a CA Technologies employee.
Indicates a virtual column representing a set of objects selected by the where clause on the Advanced tab. It exists only in the Object Engine and is not physically stored in the database. Select this field type only on direction from a CA Technologies employee.
Indicates a virtual column constructed by the Object Engine from the values of other columns, under the direction of a formula specified on the Advanced tab. It exists only in the Object Engine and is not physically stored in the database. Select this field type only on direction from a CA Technologies employee.
The length of a string column. This field is blank for non-string columns. It is read-only for all standard columns, and for site-defined columns that have been saved. You can specify or change the length of new site-defined STRING columns by entering an integer between 1 and 32767 in this field.
The table referenced by an SREL column. This field is blank for non-SREL columns. It is read-only for all standard columns, and for site-defined columns that have been saved. You can specify the table referenced by a new site-defined SREL by selecting it from the drop-down list.
The default value assigned to this column when a new row of the table is defined. It should be a value appropriate to the field type. Some keyword values are available for particular field types:
Specifies the current date and time for a DATE column.
Specifies the active user for an SREL to the Contact table.
The value assigned to this column when a row of the table is updated. It should be a value appropriate to the field type. Some keyword values are available for particular field types:
Specifies the current date and time for a DATE column.
Specifies the active user for an SREL to the Contact table.
When checked, this option indicates that a value must be supplied for the column before a row of the table containing it can be saved. You can set this option for both standard and site-defined columns, and you can disable an option that you have set. However, you cannot turn off the option of a standard column unless it was set by your site.
When checked, this option indicates that a value for this column can be provided only when a row of its table is initially created, and cannot thereafter be changed. You can set this option for both standard and site-defined columns, and you can disable an option that you have set. However, you cannot turn off the option of a standard column unless it was set by your site.
When checked, this option indicates that this column is one of the columns tested by pdm_userload to determine whether or not its input is an update to an existing row. This option is available only for STRING columns. It is read only for all columns in standard tables.
These options specify characteristics of a column that is an index of the physical DBMS. They are available only for columns in site-defined tables.
Specifies that the column is unique within the table and that no two rows have the same value for the column.
Specifies that the DBMS index is listed in ascending sequence by this column. Mutually exclusive with Descending.
Specifies that the DBMS index is listed in descending sequence by this column. Mutually exclusive with Ascending.
Important! The Schema Designer includes an Advanced tab. Information on this tab is intended for CA Technologies Support and field representatives. You will not need to work with this tab for most uses of the Schema Designer, and it will not be discussed further in this document.
This selection saves your changes in the database, and creates a file (wsptest.mods) on the server defining your changes to the Object Engine. This file is stored in the site/mods/majic subdirectory of your CA SDM installation directory. After creating the wsptest.mods file, WSP causes its Object Engine to recycle so that it will use the new changes. This may take from a few seconds to a couple of minutes, depending on the complexity of your schema.
A message is prompted. Click Yes to continue. The wsptest.mods file affects only the Object Engine designated by the wsp_domsrvr option. Other Object Engines on the same server do not process this file, and the file is not distributed to other servers. In addition, new tables and columns in Test mode are defined to the Object Engine as local objects. This means that the Object Engine knows about them and you can use them on web forms. However, they do not exist in the database, and do not affect other users. Typical CA SDM users do not use WSP Object Engine, so they are unaffected by the schema modifications you are testing.
The column is added to the table.
|
Copyright © 2013 CA.
All rights reserved.
|
|