RE: SQL Stored Procedure

[Buck Calabro <mcalabro@xxxxxxxxxxxx>]

Erik,
Assuming that the stored procedure is being written in SQL as opposed to
another HLL, you could do something like this:

create procedure bucksql (in input char(50)) language sql 
begin                                                     
declare workinput char(10);                               
set workinput = substr(input,1,10);                       
...
end                                                       

Buck Calabro

> -----Original Message-----
> From: Luther Ananda Miller 
> Sent: Tuesday, October 19, 1999 4:43 AM
> To:   JAVA400-L@midrange.com
> Subject:      Re: SQL Stored Procedure
> 
> I'm not sure what you want to do with the string variable you are passing
> in-- could you be more specific? You can of course use the
> String.substring() method ... but somehow I don't think that is what you
> meant.
> 
> Luther
> 
> -----Original Message-----
> From: enord@ORIENTAL.COM <enord@ORIENTAL.COM>
> To: JAVA400-L@midrange.com <JAVA400-L@midrange.com>
> Date: Tuesday, 19 October 1999 12:02
> Subject: SQL Stored Procedure
> 
> >I am working on a Stored Procedure on the AS/400 that is called from a
> Java
> >Application.  I was wondering if anyone knew of a way to substring a
> Sting
> >variable that is passed into the procedure.
> >
> >Thank you for any help
> >Erik Nord
> 
+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---