×
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.
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 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.
midrange.com
