For details, see Opening an Object Editor. They let you specify basic properties, parameter and return value details for methods. The Add Method and Edit Method wizards let you work with the methods of a structured type. Adding or editing structured type methods For details, see Previewing and Submitting Object Editor Changes. When finished, you can submit your changes. Lets you view and modify the CREATE METHOD statement generated with your choices on the Methods tab.įor details on using this tab, see Viewing the SQL/DDL for an Object.ģ. After specifying options, click Create Body to work with the CREATE METHOD statement you generated on the editor’s Body tab. This setting is available for methods specified with a Language of SQL. Inherit isolation level with lock request - specifies whether the INHERIT clause is specified as INHERIT ISOLATION LEVEL WITHOUT LOCK REQUEST or INHERIT ISOLATION LEVEL WITH LOCK REQUEST. Otherwise, the external named provided will appear within quotes in the CREATE METHOD statement on the Body tab. When this check box is checked, the method body is created with the external name as provided. As identifier - This setting is available for methods specified with a Language of C. This setting is available for methods specified with a Language of C, JAVA, or OLE. Transform group - lets you specify the transform group used when invoking the method. They lets you prepopulate the method body definition: External name - lets you provide a ‘string” or SQL identifier for a method specified with a Language of C, JAVA, or OLE. The Create Body and associated controls are available for selected methods for which no method body has yet been defined. Select a method specification and click Drop to delete that method specification from the structured type. For more information, see Adding or editing structured type methods. Similarly, select a method and click Edit to modify the method specification. Optionally, take one of the following actions:Ĭlick Add to begin the process of adding a new method specification. On opening, this tab lists all method specifications associated with the structured type and for each method, includes name and language details. This tab lets you initiate creation of method specifications and prepopulate associated method bodies. Select an attribute and click Drop to delete the attribute. For details on option availability, see Structured Types Wizard (DB2 LUW).Īdd an attribute by clicking the New button and typing a name for the attribute. Depending on the datatype you choose you can also provide additional datatype options. Select an attribute and change the Datatype in the Property/Value list. Optionally, take one of the following actions: For details on these properties, see Structured Types Wizard (DB2 LUW).ĭisplays the currently defined attributes for the structured type.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |