Re: calling sql procedure from interactive SQL session

What's your definition of an interactive SQL session? STRSQL? iNav's run
sql scripts? Embedded RPG?


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: "Hockchai Lim" <lim.hock-chai@xxxxxxxxxxxxxxx>
To: midrange-l@xxxxxxxxxxxx,
Date: 11/28/2012 03:30 PM
Subject: calling sql procedure from interactive SQL session
Sent by: midrange-l-bounces@xxxxxxxxxxxx



Anybody know if it is possible to call the stored procedure below from
interactive SQL session?

lrResetLoginProcessRequestSP(
in piUserId Varchar(256),
in piRequestID Varchar(256),
in piChgPwdAlso Char(1),
in pinewEncPwd Binary(256),
in pinewEncPwdLn int,
in pinewEncPwdVc Binary(16),
in pinewASCEBC Char(1),
in piForcePwd char(1),
inout piErrFlag char(1),
inout piErrID char(7),
inout piErrMsg char(255)
)

--
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.