RE: V5R3 CALL stored procedure behavior

Tom,

IFAIK, it has _always_ been that way.


Given the object based nature of the OS and the DB integration into the OS, it 
makes sense that _every_ program is implicitly a DB stored procedure.


Of course, it also is something that can bite you is the a$$ if you are not use 
object level security.


As Vernon mentions, CALL QCMDEXC('DLTLIB MYLIB') is perfectly acceptable from 
the STRSQL screen or the "Run SQL Scripts" application of iSeries Navigator. 



Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Tom Liotta
> Sent: Friday, July 22, 2005 8:18 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: V5R3 CALL stored procedure behavior
> 
> 
> I could've sworn that the last time I looked into this, a 
> program object needed to be defined to DB2 as a stored 
> procedure _only_ if parm values were to be returned. I.e., if 
> all parms were IN only, then you could CALL a program as if 
> it had been declared as a stored procedure.
> 
> But the V5R3 InfoCenter says that:
> 
> "A static CALL statement without a corresponding CREATE 
> PROCEDURE statement is processed with the following rules:
> 
>     * All host variable arguments are treated as INOUT type 
> parameters.
>     * The CALL type is GENERAL (no indicator argument is passed).
>     * The program to call is determined based on the 
> procedure name specified on the CALL, and, if necessary, the 
> naming convention.
>     * The language of the program to call is determined based 
> on information retrieved from the system about the program."
> 
> That's from Database-> Programming-> SQL programming-> 
> Routines-> Stored procedures-> Using embedded CALL statement 
> where no procedure definition exists.
> 
> Ummm... so in V5R3, pretty much every program object is open 
> for a remote (or local only?) SQL CALL assuming authority is 
> appropriate and you treat all parms as INOUT?
> 
> There are some obvious snags, but..... huh??? How long has 
> this been so?
> 
> Tom Liotta
> 
> -- 
> Tom Liotta
> The PowerTech Group, Inc.
> 19426 68th Avenue South
> Kent, WA 98032
> Phone  253-872-7788 x313
> Fax    253-872-7904
> http://www.powertech.com
> 
> 
> __________________________________________________________________
> Switch to Netscape Internet Service.
> As low as $9.95 a month -- Sign up today at 
> http://isp.netscape.com/register
> 
> Netscape. Just the Net You Need.
> 
> New! Netscape Toolbar for Internet Explorer
> Search from anywhere on the Web and block those annoying pop-ups.
> Download now at http://channels.netscape.com/ns/search/install.jsp
> -- 
> This is the Midrange Systems Technical Discussion 
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
>