RE: SQL EXECUTE failing after upgrade to V6R1

[Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx]

sorry with parameters you would have to use PREPARE.  my bad...


Thanks,
Tommy Holden



From:   David FOXWELL <David.FOXWELL@xxxxxxxxx>
To:     Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date:   05/05/2010 07:34 AM
Subject:        RE: SQL EXECUTE failing after upgrade to V6R1
Sent by:        midrange-l-bounces@xxxxxxxxxxxx



> -----Message d'origine-----
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de 
> Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx
>
> just for grins and giggles, did you try replacing the PREPARE 
> and EXECUTE with a simple EXECUTE IMMEDIATE and see if you 
> got different results?

No, I'd like to try but haven't used that before. What happens to the 
USING bit?