Re: Stored procedures

I think it was one of "those" problems with sep. I had already tried refreshing the sep. Then, I recompiled the program and forgot about the debugger. When I called the procedure from strsql, it seemed to lock - it was the rdp debugger taking control! How is that possible? When I refreshed the sep, it didn't catch the call. If I recompile, I should be obliged to refresh the sep! N'est-ce pas!!

-----Message d'origine-----
De : wdsci-l-bounces@xxxxxxxxxxxx
[mailto:wdsci-l-bounces@xxxxxxxxxxxx] De la part de
Rick.Chevalier@xxxxxxxxxxxxxxx
Envoyé : jeudi 2 décembre 2010 14:55
À : wdsci-l@xxxxxxxxxxxx
Objet : Re: [WDSCI-L] Stored procedures

David,

Check the user ID the SEP was set up to use and the user ID
you are running the SQL under. If they don't match I think
the SEP is ignored.

Rick

-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx
[mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of David FOXWELL
Sent: Thursday, December 02, 2010 6:11 AM
To: Rational Developer for IBM i / Websphere Development
Studio Client for System i & iSeries
Subject: [WDSCI-L] Stored procedures

Hi,

I've been playing with stored procedures and I wondered why
the call that I issue in a STRSQL session cannot be
intercepted with SEP on the rpg program that the procedure is
registered as. Also, as I can't use iNav, is there anything
in RDPi that will access a stored procedure?

Thanks
--
This is the Rational Developer for IBM i / Websphere
Development Studio Client for System i & iSeries (WDSCI-L)
mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/wdsci-l.


Privileged and Confidential. This e-mail, and any
attachments there to, is intended only for use by the
addressee(s) named herein and may contain privileged or
confidential information. If you have received this e-mail
in error, please notify me immediately by a return e-mail and
delete this e-mail. You are hereby notified that any
dissemination, distribution or copying of this e-mail and/or
any attachments thereto, is strictly prohibited.
--
This is the Rational Developer for IBM i / Websphere
Development Studio Client for System i & iSeries (WDSCI-L)
mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/wdsci-l.