Hp Neoview Release 2.5 Software Uživatelský manuál Strana 168
- Strana / 284
- Tabulka s obsahem
- KNIHY
Hodnocené. / 5. Na základě hodnocení zákazníků
ActionControl or FieldGroup Box
Controls the maximum number of result sets the procedure can return. This
control is enabled only if the method signature contains a java.sql.ResultSet[]
object. If the method contains a result set object, the valid range is 1 to 255.
This value is automatically set to zero if the selected Java method does not
have a java.sql.ResultSet[] object.
Number of dynamic
result sets
Attributes
If selected, the procedure performs SQL operations. If cleared, the procedure
does not perform SQL operations.
NOTE: Neoview SQL returns an error if this attribute is cleared and the
procedure performs SQL operations.
Accesses Database
Related Topics
“Create a Procedure” (page 165)
Use a Method in a Procedure
To be used in a procedure, a Java method must:
• Be qualified as public static void.
• Have a java.sql.ResultSet[] parameter at the end of the method signature if the method uses
result sets.
NOTE: There can be more than one java.sql.ResultSet[] parameter, but they must all be at
the end of the method signature.
• Have these parameter types:
Type
Parameter Type
or Class
“java.lang.String”character
“java.lang.String[]”
“java.lang.Integer”numeric
“java.lang.Integer[]”
“java.lang.Long”
“java.lang.Long[]”
“java.lang.Float”
“java.lang.Float[]”
“java.lang.Double”
“java.lang.Double[]”
“java.math.BigDecimal”
“java.math.BigDecimal[]”
“java.sql.Date”date/timestamp
“java.sql.Date[]”
“java.sql.Time”
“java.sql.Time[]”
“java.sql.Timestamp”
“java.sql.Timestamp[]”
168 Manage Procedures
- HP Part Number: 613120-001 1
- Published: July 2010 1
- Table of Contents 3
- 4 Table of Contents 4
- Table of Contents 5 5
- 6 Table of Contents 6
- Table of Contents 7 7
- 8 Table of Contents 8
- Table of Contents 9 9
- Table of Contents 11 11
- About This Guide 13
- Intended Audience 14
- Related Documentation 15
- • Connectivity 16
- • Reference 16
- Resources on the Web 17
- Send Feedback to HP 17
- 1 About HPDM 19
- 20 About HPDM 20
- 2 Install and Start HPDM 23
- Exit the HP Database Manager 24
- 3 Connect and Disconnect 25
- Password Considerations 27
- Disconnect From a System 27
- Log On and Off 28
- Use the Systems Tool 28
- Add a System 29
- Use the Add System Dialog Box 30
- Edit a System 32
- Add a System Like 33
- Remove a System 33
- Test a System 33
- Set the Connection Timeout 34
- 4 Navigate HPDM 35
- Use the Navigation Tree Pane 37
- Use the Right Pane 39
- Use the My Favorites Pane 40
- See the HPDM Banner 41
- Use Menu Bar Commands 42
- Use the Tools Menu Options 43
- Use the Windows Menu Options 43
- Use the Help Menu Options 43
- Use the HPDM Toolbar 44
- Manage Multiple Open Windows 45
- Clone Tabs 46
- Expand and Collapse Panes 46
- Sort and Move Data Columns 47
- Work With Data Grids 48
- Work With Data Grids 49 49
- Copy Data-Grid Information 50
- Work With Data Grids 51 51
- Customize the Data Grid 52
- Search the Data Grid 52
- Export Data 53
- Use the System Message Tab 54
- Create a System Message 54
- Clone the System Message Tab 55
- View Event Messages 56
- 6 Display Database Objects 63
- Attributes Tab 64
- Tables Tab 64
- Materialized Views Tab 64
- Materialized View Groups Tab 64
- Views Tab 65
- Procedures Tab 65
- Synonyms Tab 65
- Privileges Tab 66
- Schema Size 66
- Columns Tab 67
- Primary Key Tab 68
- Hash Key Tab 68
- Unique Constraints Tab 68
- Foreign Keys Tab 69
- Partitions Tab 69
- Usage Tab 69
- Statistics Tab 70
- Tables Summary 71
- Table Indexes Summary 73
- 76 Display Database Objects 76
- Materialized Views Summary 80
- Members Tab 84
- Parameters Tab 86
- Show DDL 92
- Viewing Sampled Statistics 94
- 7 Manage Roles 95
- 96 Manage Roles 96
- Add a Role 97
- Delete a Role 98
- Grant a Role to a User 98
- Use the Grant Role Dialog Box 99
- Revoke a Role From a User 99
- 8 Manage Users and Passwords 103
- Add a Database User 104
- Related Topics 105
- Add Multiple Database Users 106
- Copy a Database User 107
- Use the Edit User Dialog Box 109
- Platform Users 111
- Add a Platform User 112
- Copy a Platform User 112
- Edit a Platform User 114
- Passwords for Users 115
- 9 Manage Security Policies 117
- 118 Manage Security Policies 118
- 10 Manage Certificates 125
- Use the Generate CSR Tab 128
- 11 Manage Directory Servers 131
- • LDAP directory server 136
- Example: LDAP Server 137
- Edit a Directory Server 139
- Delete a Directory Server 140
- 12 Manage Data Sources 141
- Create a Data Source 142
- Use the DEFINEs and SETs Tab 147
- FunctionButton 148
- 148 Manage Data Sources 148
- Use the Controlled Tables Tab 149
- Copy a Data Source 150
- Start a Data Source 151
- Stop a Data Source 151
- Update a Data Source 152
- Delete a Data Source 152
- Delete a Data Source 153 153
- 13 Manage Connectivity 155
- Stop an NDCS Server 157
- Display NDCS Services 157
- Start an NDCS Service 158
- Stop an NDCS Service 159
- Start and Stop Server Traces 160
- Learn About Server Traces 160
- 14 Manage NDCS Privileges 161
- Revoke NDCS Privileges 162
- 15 Manage Procedures 163
- Download a JAR File 164
- Rename a JAR File 164
- Delete a JAR File 165
- Create a Procedure 165
- 166 Manage Procedures 166
- Use a Method in a Procedure 168
- Drop a Procedure 169
- 16 Use the System Monitor 171
- About the Timeline Tab 173
- About the Hybrid Tab 174
- 176 Use the System Monitor 176
- Change a Color Option 179
- 17 Respond to Alerts 181
- Understand Alerts 182
- Get Information About Alerts 183
- Control the Refresh of Alerts 187
- Update an Alert 189
- Update Multiple Alerts 190
- Make Notes About an Alert 190
- About the Console Tab 191
- About System Offender 193
- For example: 195
- Get Pstate Information 197
- DescriptionField or Option 198
- Query Information 202
- Compiler Statistics 203
- Runtime Statistics 205
- 19 Use the SQL Whiteboard 211
- 212 Use the SQL Whiteboard 212
- Understand Parameter Prompts 214
- Understand Page Mode 214
- Execute Highlighted Text 215
- Reuse a Connection 216
- Highlight SQL Syntax 217
- Manage the Layout of Panes 217
- 20 Use Metric Miner 219
- Launch Metric Miner 220
- See the Parts of Metric Miner 220
- Use the Metric Miner Toolbar 222
- Create Report Folders 224
- Run Statements 225
- Add Parameters to Statements 226
- Resolve Out-of-Memory Errors 228
- Export Metric Miner Data 228
- Run Statements 229 229
- Create and Manage Reports 230
- Configuration dialog box 231
- Modify a Saved Report 232
- Close a Report 233
- Delete a Report 233
- Copy a Report 233
- Import Neoview Reports 234
- Link and Drill Down 235
- Link and Drill Down 237 237
- Learn About NCI 239
- Locate the NCI Program 239
- Launch NCI 239
- Set Auto Logon Options 240
- 22 Manage Disk Space 241
- 242 Manage Disk Space 242
- 244 Manage Disk Space 244
- About the Monitoring Tab 246
- View the System Overall 248
- View the System Detail 249
- 250 Manage Disk Space 250
- View SQL Objects 252
- View the SQL Objects Detail 253
- 254 Manage Disk Space 254
- View Table Growth 257
- By Table Tab 258
- 260 Manage Disk Space 260
- About the Configuration Tab 261
- About the General Tab 262
- Space Reference Settings 263
- About the Advanced Tab 264
- Inventory Options 265
- Update Space Reference Tables 265
- System Registry Table Tab 266
- Glossary 267
- 268 Glossary 268
- 270 Glossary 270
- 272 Index 272
- 274 Index 274
- 276 Index 276
- 278 Index 278
- 280 Index 280
- 282 Index 282
Související produkty a manuály pro Software Hp Neoview Release 2.5 Software
Software Hp Insight Management Agents Uživatelský manuál
(157 stránky)
(157 stránky)
Software Hp Access Control Uživatelský manuál
(22 stránky)
(22 stránky)
Software Hp Insight Management Agents Uživatelský manuál
(165 stránky)
(165 stránky)
Software Hp SmartStart-Software Uživatelský manuál
(59 stránky)
(59 stránky)
(37 stránky)
(120 stránky)© 2020, manymanuals.cz. Všechna práva vyhrazena. | 0.035 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Komentáře k této Příručce