Re: easier SQL statements in CL

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