DatabaseProcApplicationCreatedLinks
sybsystemprocssp_jdbc_getclientinfoprops  14 déc. 14Defects Propagation Dependencies

1     
2     /*
3     **  End of sp_jdbc_columns
4     */
5     
6     
7     /*
8     ** sp_jdbc_getclientinfoprops
9     */
10    
11    create or replace procedure sp_jdbc_getclientinfoprops
12    as
13        select 'ApplicationName' as Name, 30 as MAX_LEN, '' as DEFAULT_VALUE,
14            'The name of the application currently utilizing the connection. It appears in the sysprocesses table under column clientapplname.'
15            as DESCRIPTION
16        union
17        select 'ClientHostname' as Name, 30 as MAX_LEN, '' as DEFAULT_VALUE,
18            'The hostname of the computer the application using the connection is running on. It appears in the sysprocesses table under column clienthostname.'
19            as DESCRIPTION
20        union
21        select 'ClientUser' as Name, 30 as MAX_LEN, '' as DEFAULT_VALUE,
22            'The name of the user that the application using the connection is performing work for. It appears in the sysprocesses table under column clientname.'
23            as DESCRIPTION
24    


exec sp_procxmode 'sp_jdbc_getclientinfoprops', 'AnyMode'
go

Grant Execute on sp_jdbc_getclientinfoprops to public
go
RESULT SETS
sp_jdbc_getclientinfoprops_rset_001

DEFECTS
 MEST 4 Empty String will be replaced by Single Space 13
 MEST 4 Empty String will be replaced by Single Space 17
 MEST 4 Empty String will be replaced by Single Space 21
 MGTP 3 Grant to public sybsystemprocs..sp_jdbc_getclientinfoprops  
 QGWO 3 Group by/Distinct/Union without order by 13
 QUNI 3 Check Use of 'union' vs 'union all' 13
 MRST 2 Result Set Marker 13
 MTR1 2 Metrics: Comments Ratio Comments: 6% 11
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 2 = 1dec - 1exi + 2 11
 MTR3 2 Metrics: Query Complexity Complexity: 2 11

DEPENDENCIES
PROCS AND TABLES USED
writes table sybsystemprocs..sp_jdbc_getclientinfoprops_rset_001