× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Good catch Rob,

I was thinking the OP was doing an external stored procedure in RPGLE.
Primarily because I always forget SQL has an IF statement. <grin>

If the original poster is really using SQL, then he needs:

IF Field1 = 2 THEN
  BEGIN;
     Statement1;
     Statement2;        
     Statement3;
  END;
Endif;

IF Field1 = 3 THEN
  BEGIN;
     Statement4;
     Statement5;        
     Statement6;
  END;
Endif;

But Rob's also correct, a question about stored procedures written in
SQL should be in MIDRANGE-L not RPG-L



Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  

> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx 
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
> Sent: Tuesday, December 20, 2005 3:15 PM
> To: RPG programming on the AS400 / iSeries
> Subject: Re: SQL Stored Procedure
> 
> I'm slightly confused, since this is the RPG list are you 
> taking a rpg 
> program and doing the create procedure on that or is the 
> whole procedure 
> in one big CREATE PROCEDURE statement with no RPG involved?  
> The reason I 
> am asking is not to play list cop.  It's because the IF 
> constructs are 
> different.
> 
> Rob Berendt
> -- 
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com


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-2024 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.