AW: SQL0312 variable non defined or not usable

Hi,

1. remove the blank between the column (:) sign and the constant.
2. Instead of defining a constant, you need to define an (initialized) stand
alone field.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im
Auftrag von David FOXWELL
Gesendet: Thursday, 16. April 2009 12:47
An: RPG programming on the IBM i / System i
Betreff: SQL0312 variable non defined or not usable

Hi,

I wanted to code a constant in some embedded SQL.

Instead of something like :

WHERE condition = 'A'

I did

WHERE condition = : myConstant.

myConstant is in the main procedure as is the SQL code.
I think I read something about problems with the scope of host variables
before V6.1. I've tried putting everything in a subprocedure but no luck.

Any ideas?




David FOXWELL
Service Informatique
Tél : 03 90 23 91 63
david.foxwell@xxxxxxxxx<mailto:david.foxwe@xxxxxxxxx>

P Pensez à l'environnement avant d'imprimer ce message