Re: Quick SQL expression evaluation

Dennis,

AFAIK, that can't be done BUT, I wonder if you could do a PREPARE/EXECUTE
combo against, say SYSIBM/SYSDUMMY1?. I little convoluted, I know (and I'm
sure not very efficient), but *maybe* that would answer your question...

Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries


On Tue, May 25, 2010 at 8:00 AM, Dennis Lovelady <iseries@xxxxxxxxxxxx>wrote:

I am trying to write a procedure I thought would be extremely simple: a
short SQL evaluation program that would simply take an expression and
return
the result of SQL operating on that expression. For a silly example:

Exec sql set :myResult = 2 + 2 ;



To minimize complexity, I am passing the '2 + 2' part as a string, so that
the meat of this very short procedure is:

Exec sql setl :myResult = :myExpression ;



But (and, yes, I know I should have expected this) SQL is seeing it as the
string "2 + 2" rather than a pair of values with an operator between them.
Is there an SQL verb/clause that informs the SQL processor that the
following is an expression rather than a string (such as with unix' "expr"
command)? Or is this just a pipe dream, not worth the effort?



Dennis E. Lovelady
AIM/Skype: delovelady MSN: fastcounter@xxxxxxxxxxxx
<http://www.linkedin.com/in/dennislovelady>
www.linkedin.com/in/dennislovelady --
You can't have everything. Where would you put it?



--
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.