Database	Proc	Application	Created	Links
sybsystemprocs	sp_passthru		31 Aug 14	Defects Dependencies

1     
2     /* Sccsid = "%Z% generic/sproc/src/%M% %I% %G%" */
3     
4     /*
5     ** Omni only
6     */
7     create procedure sp_passthru
8         @server varchar(255), /* name of remote server */
9         @query varchar(255), /* language buffer to be executed remotely */
10        @errcode int output, /* error number generated by query */
11        @errmsg varchar(1024) output, /* error message generated by query */
12        @rowcount int output /* number of rows read by the query */
13    
14    /*
15    ** The caller may supply up to 250 additional output arguments of the
16    ** appropriate datatypes to receive the values of successive columns 
17    ** returned from the query.
18    */
19    
20    as
21    /*
22    ** All of the processing, including setting of the return status, is
23    ** handled by the internal OmniSQL Server function "passthru()".
24    **
25    ** A status of 1 is returned if an error is detected during, either
26    ** the remote execution of the language buffer or during the processing
27    ** of the results.  A status of 0 indicates a successful completion.
28    */
29    

exec sp_procxmode 'sp_passthru', 'AnyMode'
go

Grant Execute on sp_passthru to public
go

DEFECTS
VUWR 4 Variable is an output param and is not written to @errcode	10
VUWR 4 Variable is an output param and is not written to @errmsg	11
VUWR 4 Variable is an output param and is not written to @rowcount	12
MGTP 3 Grant to public sybsystemprocs..sp_passthru
VUNU 3 Variable is not used @server	8
VUNU 3 Variable is not used @query	9
VUNU 3 Variable is not used @errcode	10
VUNU 3 Variable is not used @errmsg	11
VUNU 3 Variable is not used @rowcount	12
MTR1 2 Metrics: Comments Ratio Comments: 80%	7
MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 1 = 0dec - 1exi + 2	7
MTR3 2 Metrics: Query Complexity Complexity: 1	7