RE: java Stored procedure on AS400

Use SET in your stored procedure.

SET variable1, variable2 = SELECT COLUMN1, COLUMN8 FROM QGPL.TABLE1
WHERE COLUMN1 LIKE 'FILE%';

The resultset must be only one record. With this query you'd want to
declare a cursor and loop around the SET statement.

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Ashish Kulkarni
Sent: Thursday, July 29, 2010 4:01 PM
To: Java Programming on and around the iSeries / AS400
Subject: Re: java Stored procedure on AS400

Hi
Thanks, i was also looking to create SQL stored procedure, i am trying
this from iseries navigator and getting error

SELECT COLUMN1, COLUMN8 INTO :variable1, :variable2 FROM QGPL.TABLE1
WHERE
COLUMN1 LIKE 'FILE%';

I am getting error as below, any ideas


Token : was not valid. Valid tokens: <IDENTIFIER>.

Message ID: SQL0104

Cause . . . . . : A syntax error was detected at token :. Token : is
not
a valid token. A partial list of valid tokens is <IDENTIFIER>. This
list assumes that the statement is correct up to the token. The error
may be earlier in the statement, but the syntax of the statement appears
to be valid up to this point.
On Thu, Jul 29, 2010 at 4:47 PM, Mike Cunningham
<mike.cunningham@xxxxxxx>wrote:

http://www.redbooks.ibm.com/redbooks/SG246503/wwhelp/wwhimpl/js/html/w
whelp.htm



-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:
java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike Cunningham
Sent: Thursday, July 29, 2010 4:42 PM
To: Java Programming on and around the iSeries / AS400
Subject: RE: java Stored procedure on AS400

I think you can but indirectly. You need to specify a high-level
language for the procedure (RPG or COBOL or CL?) and that HLL could
call a java routine. I have not done this but I think there was a
thread about this some time ago.

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:
java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Ashish Kulkarni
Sent: Thursday, July 29, 2010 4:26 PM
To: Java Programming on and around the iSeries / AS400
Subject: java Stored procedure on AS400

Hi
Is it possible to create stored procedure in java on AS400, we have
been creating stored procedure in RPGLE, is there any documentation
available to show how to do this

--
Ashish
www.ayurwellness.com
www.mysoftwareneeds.com
--
This is the Java Programming on and around the iSeries / AS400
(JAVA400-L) mailing list To post a message email:
JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list
options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a

moment to review the archives at
http://archive.midrange.com/java400-l.

--
This is the Java Programming on and around the iSeries / AS400
(JAVA400-L) mailing list To post a message email:
JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list
options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a

moment to review the archives at
http://archive.midrange.com/java400-l.

--
This is the Java Programming on and around the iSeries / AS400
(JAVA400-L) mailing list To post a message email:
JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list
options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a

moment to review the archives at
http://archive.midrange.com/java400-l.

--
Ashish
www.ayurwellness.com
www.mysoftwareneeds.com
--
This is the Java Programming on and around the iSeries / AS400
(JAVA400-L) mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/java400-l.