Hp Neoview Release 2.5 Software Manuel d'utilisateur Page 168
- Page / 284
- Table des matières
- MARQUE LIVRES
Noté. / 5. Basé sur avis des utilisateurs
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
Produits connexes et manuels pour Logiciel Hp Neoview Release 2.5 Software
(15 pages)
(37 pages)
(120 pages)© 2020, manymanuals.fr. Tous droits réservés | 0.034 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commentaires sur ces manuels