Re: Embedded SQL & named constants

[Luis Rodriguez <luisro58@xxxxxxxxx>]

Thanks for the correction. It seems I was wrong with my answer...

Regards,
Luis

Sent from my Moto G phone. Please excuse my brevity.

On Dec 20, 2016 5:51 AM, "Brian Parkins" <goodprophet.bp@xxxxxxxxx> wrote:

> Justin asked:
> Is it possible to use named constants as variables in embedded SQL
> statements?  I've tried but never been able to make it work.
>
> From the ILE RPG section of the Embedded SQL Programming manual (V7R3):
>
> Declaring host variables in ILE RPG applications that use SQL
> ==================================================
> The SQL ILE RPG precompiler only recognizes a subset of valid ILE RPG
> declarations as valid host
> variable declarations.
> Most variables defined in ILE RPG can be used in SQL statements. A partial
> listing of variables that are
> not supported includes the following:
> . . .
> - Named constants
> . . .
>
> Brian.
> --
> This is the RPG programming on the IBM i (AS/400 and iSeries) (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.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD