RE: SQL database object names longer than 10 characters and mixed case?

I don't want to get embroiled in this religious war. I use both RLA from RPG and SQL in a variety of forms. I use whichever is suited to the application I happen to be working.

But, I'd like to know what you advocates of RLA think RLA can do that can't be done with an SQL cursor, or that is significantly slower in SQL than RLA. Joe even offers in his BOMP example that it could be done with multiple cursors. I think multiple cursors might actually be faster than a bunch of recursive SETLL/READE's. It would surely be easier to read.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Nathan Andelin
Sent: Monday, November 01, 2010 11:12 AM
To: Midrange Systems Technical Discussion
Subject: Re: SQL database object names longer than 10 characters and mixed case?

From: "joepluta"
I could have been more politic about it. But I get a little cranky
hearing that perfectly good tools are bad because they don't meet a
preconceived notion of what's current and correct. I've had to fight
that battle for way too many years.

I hear you. I agree with you. I'd actually go further and suggest that if you're limiting yourself only to SQL you're going to end up with mediocre products. Actually, if you're limiting yourself only to RLA, you're going to end up with mediocre products too. Both have a place. I find it hard to understand that SQL only proponents familiar with IBM i don't see that.

I considered posting some new RPG procedures that I'm working on right now to calculate grades for students for a school term, given a significant breadth of grading options. SQL is not the correct tool for the job. Most SQL only developers would probably carp against the business requirements, and push for a watered down versions.

-Nathan




--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.