Database | Proc | Application | Created | Links |
sybsystemprocs | sp_monitor_deadlock_getopts ![]() | ![]() | 31 Aug 14 | Defects Dependencies |
1 2 /* 3 ** sp_monitor_deadlock_getopts 4 ** 5 ** Extract the individual options from a comma-separated print options 6 ** string, and set local output variables to pass back to the caller. 7 ** 8 ** Parameters: 9 ** @output - User-specified output options. 10 ** @opt_verbose_str - Name of verbose option 11 ** @opt_pagediag_str - Name of page diagnostics option 12 ** @opt_verbose - If verbose option was requested. 13 ** @opt_pagediag - If page diagnostics was requested. 14 { 15 */ 16 create procedure sp_monitor_deadlock_getopts( 17 @output varchar(30) 18 , @opt_verbose_str varchar(7) 19 , @opt_pagediag_str varchar(8) 20 , @opt_verbose int = 0 output 21 , @opt_pagediag int = 0 output 22 ) as 23 begin 24 declare @opt_sep char(1) 25 , @sep_index int 26 , @option_item varchar(30) 27 , @option_found int 28 , @valid_options varchar(30) 29 30 if (@output IS NULL) 31 return 0 32 33 -- Extract each comma-separated output option. 34 select @opt_sep = ',' 35 while (1 = 1) 36 begin 37 exec @option_found = sp_getopts @output 38 , @opt_sep 39 , @option_item output 40 , @output output 41 if (@option_found = 0) 42 return 0 43 44 -- Decode option specified and set local variable. 45 -- 46 if (@option_item = @opt_verbose_str) 47 select @opt_verbose = 1 48 49 else if (@option_item = @opt_pagediag_str) 50 select @opt_pagediag = 1 51 52 else 53 begin 54 -- Build list of valid print options. 55 select @valid_options = @opt_verbose_str 56 + @opt_sep 57 + @opt_pagediag_str 58 59 raiserror 18640, "print", @option_item, @valid_options 60 return 1 61 end 62 end 63 64 return 0 65 66 end -- } 67 if (@@error != 0) select syb_quit() 68
exec sp_procxmode 'sp_monitor_deadlock_getopts', 'AnyMode' go Grant Execute on sp_monitor_deadlock_getopts to public go
RESULT SETS | |
sp_monitor_deadlock_getopts_rset_001 |
DEFECTS | |
![]() | 67 |
![]() | |
![]() | 16 |
![]() | 23 |
![]() | 30 |
![]() | 35 |
![]() | 41 |
![]() | 46 |
![]() | 49 |
![]() | 67 |
![]() | 67 |
![]() | 67 |
![]() | 25 |
![]() | 67 |
![]() | 16 |
![]() | 16 |
![]() | 16 |
DEPENDENCIES |
PROCS AND TABLES USED calls proc sybsystemprocs..sp_getopts ![]() CALLERS called by proc sybsystemprocs..sp_monitor_deadlock ![]() called by proc sybsystemprocs..sp_monitor ![]() |