Re: RPG constants in SQLRPGLE statement

I have the following constants defined in my SQLRPGLE program.

d Active C CONST('Active')
d Pending C CONST('Pending-Active')
d Deactive C CONST('De-Active')
d Final C CONST('DeActive Final')

and I have the following Exec Sql statement in the program

Exec Sql Select Acr6Sern,
Case(AcrStat)
When 'A' Then :Active
When 'P' Then :Pending
When 'D' Then :Deactive
When 'F' Then :Final
End
Into :Serial3C, :Status3C
From ACR0006F
Where Acr6Cusn = :Cusno

This won't compile as the host variables aren't variables but constants. I
also understand that if I changed the constants to variables and
initialized
them it would then work.

What I'd like to know is if there is a way to access RPG constants within
SQL statements.

Thanks,

Rob
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.