Manuals / Sybase / Household Appliance / Water System

Sybase 7.5 Using a validation rule in check parameters, To define additional check parameters

Models: 7.5

1 288

Download 288 pages 28.98 Kb

Page 142

Defining check parameters

You define additional check parameters for data constraints where standard check parameters are not sufficient.

ϖTo define additional check parameters:

1Click the Additional Checks tab in the property sheet of an attribute or domain.

The Additional Checks page appears.

2Type SQL expression using the variables %MINMAX%, %LISTVAL%, and %RULES%.

3Click OK.

Using a validation rule in check parameters

A validation rule is a rule that validates data based on a corresponding business rule. A validation rule can be generated as a check parameter when the following conditions apply:

♦Validation rule is attached to a class, attribute, or domain

♦Validation rule is defined as a server expression

132

Image 142

Sybase 7.5 manual Using a validation rule in check parameters, To define additional check parameters, 132

Contents

User’s Guide Page Contents Changing an association into an associative class 102 Modifying the code of an implementation operation100 103 111 112 Generating Objects from an OOM 179 Using Object Languages 229 Vii Viii Subject Audience Where to find information About This Book If you want to Use these parts of the book Contents Object-Oriented Model Basics Functional overview Build an Object-Oriented Model OOM UML and object-oriented modeling OOM roles What is an OOM?OOM creation Object Objects in an OOMAn OOM represents the interaction of the following objects Selection Tool Description Creating a new OOM To create an OOM Object-Oriented Model Basics An OOM has the file extension .OOM Opening an existing OOMTo open an existing OOM Classes Defining OOM model optionsYou can set the following option for classes in an OOM Non-divergence To define OOM model optionsResult To modify the model properties Defining OOM propertiesLength Defining OOM properties Building an Object-Oriented Model Defining packages Package properties To modify the package display preferences Displaying text in package symbolsPreference Defining packages Defining classes Property Description Class propertiesClass has the following general properties Maximum length Modify or creating Analyzing class propertiesStereotype New stereotypes Type Stereotype Cardinality Creating a classVisibility Visible Creating a class from the list of classes Accessing the list of classesCreating a class from the Browser To create a class from the Browser To create a class in a diagram Creating a class from a diagramInner classes Attaching an inner class to a class Opening property sheets at last accessedTo declare an inner class within a class Building an Object-Oriented Model Detaching an inner class from a class To detach an inner class from a class Modifying class properties from its property sheet ClassifiersModifying class properties To modify class properties from its property sheet Modifying class properties from the list of classes To modify class properties from the list of classes Adding objects to a class Adding an attribute to a class To add an attribute to a class Adding an operation to a class To add an operation to a class Defining classes Preview the code of a class or an interface To preview the code of a class Displaying text in class symbols To modify the class display preferences Building an Object-Oriented Model Interface properties Defining interfacesAn interface has the following properties Creating an interface from the Browser Analyzing interface propertiesCreating an interface Visibility To create an interface in a diagram Creating an interface from a diagramAccessing the list of interfaces Creating an interface from the list of interfaces Modifying interface properties from its property sheet Modifying interface propertiesTo modify interface properties from its property sheet To modify interface properties from the list of interfaces Modifying interface properties from the list of interfacesInterface property sheet opens to the General Select Model Interfaces Adding inner classes to an interface Adding objects to an interface You can add the following objects to an interface Adding an attribute to an interfaceTo add an attribute to an interface Building an Object-Oriented Model Adding an operation to an interface To add an operation to an interface Preview the code of an interface To preview the code of an interface Displaying text in interface symbols Code Preview page appears Click OK To modify the interface display preferences Defining attributes Attribute properties An attribute has the following properties Analyzing attribute properties Data Type Creating an attribute from the Browser Creating an attributeMultiplicity To create an attribute from the Browser To create an attribute by inserting it in the list Accessing the list of attributesCreating an attribute from the list of attributes Select Model Attributes. The list of attributes appears Creating an attribute from a class in a diagram To create an attribute from a class in a diagram Modifying attribute properties Modifying attribute properties from its property sheet To modify attribute properties from its property sheet To modify attribute properties from the list of attributes Modifying attribute properties from the list of attributesSelect Model Attributes Attaching an attribute to a domain To attach an attribute to a domain Attribute property sheet opens to the General Copying an attribute to another class To copy an attribute to another class An attribute has the following display preferences Displaying text in attribute symbolsWhen selected To modify the display preferences Building an Object-Oriented Model Identifier properties Defining identifiersAn identifier has the following properties You can create an identifier from a class Creating an identifierTo create an identifier You can add attributes to an identifier Adding attributes to an identifierTo add attributes to an identifier Modifying identifier properties from its property sheet Modifying identifier propertiesTo modify identifier properties from its property sheet Modifying identifier properties from the list of identifiers Operation properties Defining operationsAn operation has the following properties Creating an operation from the Browser Analyzing operation propertiesCreating an operation To create an operation from the Browser To create an operation by inserting it in the list Accessing the list of operationsCreating an operation from the list of operations Select Model Operations. The list of operations appears Creating an operation from a class in a diagram To create an operation from a class in a diagram Modifying operation properties from its property sheet Modifying operation propertiesTo modify operation properties from its property sheet To modify operation properties from the list of operations Modifying operation properties from the list of operationsOperation property sheet opens to the General Select Model Operations Adding constructors and destructors to a class Adding a Default constructor and destructor to a class To add a Default constructor and destructor to a class Building an Object-Oriented Model Adding a Copy constructor to a class To add a Copy constructor to a class Adding a duplicate operation to a class Adding operations to a classTo add a duplicate operation to a class Adding an operation from a parent class To add an inherited operation to a class Adding Getter and Setter operations to a class Operation Defining operations Creating an implementation operation To create an implementation operation Modifying the code of an implementation operation To modify the code of an implementation operation Copying an operation to another class To copy an operation to another class Displaying text in operation symbols An operation has the following display preferences To modify the display preferences Modify the operation display preferences Click OK Parameter properties Defining parametersDirection Creating a parameter To create a parameter Parameter property sheet opens to the General Generalization properties Defining generalizationsGeneralization has the following properties Creating a generalization Analyzing generalization propertiesTo create a generalization Link appears between the two objects Dragging a generalization to a different class Modifying generalization properties from its property sheet Modifying generalization propertiesTo modify generalization properties from its property sheet Displaying text in generalization symbols Generalization has the following display preferences To modify the display preferences Association Ends Omitted when end names are usedDefining associations Class plays as viewed by the opposite class Association properties An association has the following properties Creating an association Creating an association outside of a diagramTo create an association in a diagram Dragging an association to a different class Association property sheet opens to the General Analyzing cardinality properties100 101 Association role propertiesOrdering Indicates To change an association into an associative class Changing an association into an associative classAggregation/composition of an Association Right-click an association To modify association properties from its property sheet Modifying association propertiesModifying association properties from its property sheet 103 Double-click the association in the model Modifying cardinality propertiesTo modify association cardinality properties 104 105 To modify the association display preferences Displaying text in association symbols106 107 Dependency has the following properties Defining dependenciesDependency properties 108 To create a dependency Creating a dependency109 Dragging a dependency to a different class 110 To modify dependency properties from its property sheet Modifying dependency propertiesModifying dependency properties from its property sheet 111 Dependency has the following display preferences Displaying text in dependency symbols112 113 Realization has the following properties Defining realizationsRealization properties 114 Dragging a realization to a different class Creating a realizationTo create a realization 115 Modifying a realization from its property sheet Modifying realization properties116 To modify realization properties from its property sheet 117 Realization has the following display preferences Displaying text in realization symbolsModifying a realization from the list of realizations 118 119 Each domain definition includes the following properties Defining domainsDomain properties 120 You create a domain from the list of domains Accessing the List of DomainsCreating a domain To create a domain Precision Indicating data type, length, and precisionLength 122 To select a data type for a domain from the list Selecting a data type for a domainSelecting a data type for a domain from the list 123 To select a data type for a domain from its property sheet Selecting a data type for a domain from its property sheetUndefined data type Selecting a data type from a list of standard data types Change of data type appears in the list of domains Selecting a data type from a list of standard data types125 Character data types Numeric data types126 To select a data type from a list of standard data types Time data typesOther data types Selecting from the Data Type dropdown listbox 128 To modify domain properties Accessing a property sheet from the BrowserModifying domain properties 129 Defining check parameters Setting standard check parameters for objects130 131 Defining additional check parameters for objectsTo set standard parameters Variable To define additional check parameters Using a validation rule in check parameters132 Validation rule expressions To use a validation rule in check parameters133 134 Managing Object-Oriented Models 135 Object parameters verified by Check model Checking an OOM136 137 Indicating error severityOOM check options Message Description Checking a OOM Objects selected in the diagramObject selection in the Check Model To check a OOM 139 Selecting all or clearing all checkboxes 140 Dockable result window Symbol OptionMaking corrections based on OOM check results 141 Making automatic corrections to the OOM Making manual corrections to an OOM 143 Merging two OOM 144 Opening a Rose model in an OOM To open a Rose model in PowerDesigner145 Generalization Association Objects importedAll objects Class 146 Interface Objects not importedPackage Class Attribute Dependency OperationGeneralization 148 Reverse Engineering 149 Parsing What is reverse engineering?150 Inner classes Reverse engineering JavaTogether classes that logically belong together Outer class Comments Reverse engineering Java optionsJava code To define Java reverse engineering options To load a JDK library model Loading a JDK library model in the workspace153 Select the .java radio button Reverse engineering Java source files without code bodyTo reverse java without code body 154 155 To reverse engineer .java files Reverse engineering Java source filesSelect the Ignore operation body checkbox Click OK 156 Reversing without the body of the code 157 Multi-selection To reverse engineer compiled Java files to a diagramReverse engineering compiled Java files 158 159 160 To reverse engineer Java files from a source directory Reverse engineering Java files from a source directory161 162 Reverse engineering archived .jar or .zip files To reverse engineer .jar or .zip files to a diagram163 164 165 Reverse engineering PowerBuilder options Reverse engineering PowerBuilder166 To define PowerBuilder reverse engineering options 167 To load a PowerBuilder library model Loading a PowerBuilder library model in the workspace168 Reverse engineering objects from a PowerBuilder application 169 170 Reverse engineering objects from SRU files To reverse engineer PowerBuilder objects from SRU files171 172 173 Reverse engineering XML options XML SchemaReverse engineering XML XML Data XML files can be reversed into an OOM Reverse engineering XML filesTo define XML reverse engineering options 175 To reverse engineer an XML file 176 To reverse engineer object language files into a new OOM Reverse engineering into a new OOM177 This product includes XML4C 3.0.1 software developed by 178 About this chapter This chapter describes how to generate objects from an OOM179 Selecting objects to include in the generation Generating objects180 Select tools Graphically selected objectsSelecting objects Selection tips Check model Generating Java source filesDefining Java generation options Visibility sort To define Java generation options 183 To generate .java files Generating Java class definition files184 Select Tools Select the classes that you want to generate from the list185 Navigating between pages Creating Java BeanInfo classes186 To create Java BeanInfo classes 187 188 Pbl application Generating objects for PowerBuilderDefining PowerBuilder generation options Sru files To define PowerBuilder generation options 190 Click Apply Click Cancel Generating objects for a PowerBuilder application191 192 To generate PowerBuilder user objects in sru files Generating PowerBuilder objects in sru files193 194 To define XML generation options Generating for XMLDefining XML generation options 195 Generating XML objects 196 To generate XML files 197 198 Customizing scripts 199 200 201 202 Generating OOM objects to a CDMTranslating OOM objects into CDM objects OOM object 203 Translating OOM data types for a CDMTranslating Java data types for a CDM Java data type Generating and updating a CDM Generating a CDM from an OOM204 Clearing the Preserve Modifications checkbox Update existingCDM generation options You can set the following general generation options Objects selected in the model Object selection parametersCheck model before generation 206 To generate to a new CDM from an OOM Generating a new CDM207 208 Generating a CDM from a package 209 210 To update an existing CDM by generating from an OOMUpdating an existing CDM Preserve Modifications Preserve modifications 211 212 Merging models 213 214 215 Generating from Generating OOM objects to a PDMTranslating OOM objects into PDM objects Associations 217 Translating OOM data types for a PDMTranslating Java data types for a PDM Translation example for SQL Anywhere Generate new Physical Data Generating a PDM from an OOMGenerating and updating a PDM 218 Physical Data 219 You select objects for PDM generation from the Selection Defining PDM generation options220 Select Tools Generate Physical Data Model Generating a new PDMTo generate to a new PDM from an OOM 221 222 Generating a PDM from a package 223 Updating an existing PDM To update an existing PDM by generating from an OOM224 225 226 227 228 Using Object Languages 229 230 Object languagesTypes of object language Object language type To modify a value of a current object language Accessing object language propertiesModifying the current object language Open an OOM Select Language Edit Current Object Language 232 To modify the parameters of a linked object language Modifying linked object language properties233 234 To change the object language of an OOM Changing the object language of an OOMCreating a new object language To create a new object language 236 237 238 Fields Using the object language editorCategories Values Editor edit menu Modifying values in the object language editorObject language Following editing options appear UML category Object language editor categoriesGeneral category Stereotypes Class stereotypes Class has the following default stereotypes242 Operation stereotypes An operation has the following default stereotypeGeneralization has the following default stereotype Generalization stereotypes Dependency stereotypes Dependency has the following default stereotypes244 Package stereotypes Package has the following default stereotypesScript category 245 Object scripts Default constantsFollowing constant values are defined by default 246 247 SpecificationExample You can modify the following basic data types Default data typesXML Mapping 248 Event Extended Attributes categoryNamings 249 250 Using Business Rules 251 What is a business rule? 252 253 Defining business rules in an OOMTypes of business rule Rule type Business rule definition includes the following properties Business rule propertiesCreating a business rule 254 To create a business rule 255 To apply a business rule to an object Applying business rules to objectsApplying a business rule to an object 256 Attaching an expression to a business rule 257 258 Glossary 259 Glossary 260 261 262 Stereotype Transient object Visibility Index 263 264 OOM 265 266 Class 267 268 269 270 JDK 271 Model 272 273 Open 274 275 Role 276 277 278