Re: Trying to get my arms around this subject-

["Wilt, Charles" <WiltC@xxxxxxxxxx>]

Oh yeah,

Forgot to mention, DB2 considerers every program on the i5 a stored procedure.

So if you have an RPG/CL/COBOL program that does what is needed, your Java applet can call it the same
way it could a stored procedure written in SQL.

RPG/CL/COBOL program called via the SQL Stored Procedure calling mechanism, are known as EXTERNAL
stored procedures.  While you can call them without doing anything, it is usually recommended that you
defined an SQL definition for them.

The redbook I provided a link to in my first post covers using both SQL Stored Procedures and External
Stored Procedures.

Lastly, note that this thread would be more appropriate to MIDRANGE-L as WDSCi has nothing to do with
it.

HTH,
Charles


> -----Original Message-----
> From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx]
> On Behalf Of Wilt, Charles
> Sent: Tuesday, January 08, 2008 5:06 PM
> To: Websphere Development Studio Client for iSeries
> Subject: Re: [WDSCI-L] Trying to get my arms around this subject-
>
> There really isn't such a thing as an "independent SQL program".  In other
> words, you won't ever find
> an object type *PGM, attribute SQL.
>
> You can create an SQL Stored Procedure, which is I think what you're
> really asking about.  But the
> fact is, the SQL is compiled into a ILE C program.
>
> While you could technically call the compiled ILE C program directly, it
> is not recommended.  Instead,
> simply embed an SQL CALL operation into your SQLRPGLE program like so:
>
>  /exec SQL
>     CALL MY_SQL_PROCEDURE
>  /end-exec
>
> As far as a manual to learn how to create SQL Stored Procedures (and
> Triggers and User Defined
> Functions) try the "Stored Procedures, Triggers, and User-Defined
> Functions on DB2 Universal Database
> for iSeries" REDBOOK
>
> http://www.redbooks.ibm.com/abstracts/sg246503.html?Open
>
> HTH,
> Charles
>
> > -----Original Message-----
> > From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx]
> > On Behalf Of Douglas Bidwell
> > Sent: Tuesday, January 08, 2008 4:54 PM
> > To: wdsci-l@xxxxxxxxxxxx
> > Subject: [WDSCI-L] Trying to get my arms around this subject-
> >
> > Using WDSC V7:
> >
> >
> >
> > How do you create an independent SQL program on the System i that can be
> > used by a Java applet on a client PC to retrieve and update data on the
> > System i?
> >
> >
> >
> > Can this SQL program interact with other ILE environment programs like
> > RPGLE
> > and what if any are the restrictions?
> >
> >
> >
> > Are there any Redbooks, Knowledge Based Articles, Example Code or any
> > other
> > information available on the internet related to this?
> >
> >
> >
> >
> >
> > Thank you!
> >
> >
> >
> > Douglas L. Bidwell
> > Systems Engineering Manager
> > DLB Associates, Inc.
> >  <http://b4.mail.yahoo.com/ym/dlbassoc.com/tuner@xxxxxxxxxxxx>
> > tuner@xxxxxxxxxxxx
> > Ofc: 661-284-1242
> > Cel: 661-904-0762
> >
> >
> >
> > --
> > This is the Websphere Development Studio Client for 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.
>
>
>
> This e-mail transmission contains information that is intended to be
> confidential and privileged.  If you receive this e-mail and you are not a
> named addressee you are hereby notified that you are not authorized to
> read, print, retain, copy or disseminate this communication without the
> consent of the sender and that doing so is prohibited and may be unlawful.
> Please reply to the message immediately by informing the sender that the
> message was misdirected.  After replying, please delete and otherwise
> erase it and any attachments from your computer system.  Your assistance
> in correcting this error is appreciated.
> --
> This is the Websphere Development Studio Client for 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.



This e-mail transmission contains information that is intended to be confidential and privileged.  If you receive this e-mail and you are not a named addressee you are hereby notified that you are not authorized to read, print, retain, copy or disseminate this communication without the consent of the sender and that doing so is prohibited and may be unlawful.  Please reply to the message immediately by informing the sender that the message was misdirected.  After replying, please delete and otherwise erase it and any attachments from your computer system.  Your assistance in correcting this error is appreciated.