• Subject: RE: SQL Stored Procedure
  • From: Buck Calabro <mcalabro@xxxxxxxxxxxx>
  • Date: Tue, 19 Oct 1999 11:40:36 -0400

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 
declare workinput char(10);                               
set workinput = substr(input,1,10);                       

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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.