Re: Trying to get my arms around this subject-

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.