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

On 10/31/2010 07:33 PM, Joe Pluta wrote:

Nonsense. In the first place, you shouldn't be making regular changes
to your database; ALTER TABLE is no substitute for good database
design.

Now who's in their own little world? Real life, change happens. It's not bad design that causes changes, it's reaction, and even action, to external influences. For me, it's not a matter of saying "here's your database" and walking away. I've watched change (both good and bad) happen to good and bad databases, SQL and non-SQL for more than 30 years.

As for the "old and outdated" bullpuckey, I assume you're telling
everyone to dump RPG as a development language as well, since it's old
and outdated. I haven't seen you advocating that Bruce, am I wrong?

Not my argument... perception of those above...

Boss: "We gotta add a field for _blah_ to the customer master file."
iManager: "Ok, we gotta recompile 8000 programs. What's happening this weekend?"
MySQLDBA: "Hey, we're done."
Boss: "Why does it take so long to get changes done on the i?"

And no, I don't tell people to stop using RPG IV, just RPG III and II.

More blah blah. Use logicals. Change the physical using CHGPF.
Everybody's happy. I can't believe it's 2010 and we're still having
this argument.

Really? Now you want to use CHGPF, just a moment ago you said that using ALTER TABLE is bad. Do you know what CHGPF is? And relying upon the existence of logical files, complete with their record format level indicators, does not relieve you of the binding to the physical structure of the data.

Yeah, okay, a second valid point. But you see, unlike you I recommend
taking advantage of the incredible strengths and versatility of the IBM
i and use each technique as appropriate. I use SQL all the time, and I
also use RLA.

Just because you like the big shiny hammer of SQL doesn't make every
programming problem a nail, Bruce.

RPG RLA is the hammer. SQL is the Swiss Army knife to database.

Joe

P.S. Dieter? *That's* a flame. You didn't even get a warm breeze...
<smile>

No argument there, but we've all seen your posts before. You don't want anybody hearing an opposing view, unless it's yours.

Bye bye now.