Re: easier SQL statements in CL

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

Yep, one part of the use of %SST is moved to DCLs - but it's even better 
- you can define any data type at a certain location - *INT, *DEC - 
whatever - no more need for %BIN most of the time now.

Now if only SUBRs could return something other than an integer - would 
be lovely to get subprocedure-like behavior in CL - we got RPG-style 
subroutines - gotta keep movin' on!!

Of course, SUBRs would prolly still have to return the value in a 
parameter, not usable to insert in an expression directly.

I was thinking for the "quoting" question in building SQL statements - a 
SUBR could work - put the code for surrounding a value with &QT there, 
as well as doubling up embedded apostrophes in the value itself.

Vern

On 5/14/2012 11:10 AM, DrFranken wrote:
> Exactly!  When I do my 'What's new in CL" Presentation that's how I
> pitch *BASED fields. They are flat awesome for working with APIs. You
> can get a DOFOR loop that's only three lines long to roll through all
> the data you get back. Try THAT with %SST :-)
>
>       - Larry
>
> On 5/14/2012 10:56 AM, rob@xxxxxxxxx wrote:
> > Interesting idea Larry.  Sort of like a data structure.
> >
> >
> > Rob Berendt