Re: SQL -- Steve Ballmer says IBM is not innovating lately --

Create Table MyLib/MyFile (
My_Product_Code                 For Column PRDCODE Numeric(5,0),
My_Product_Desc                 For Column PRDDESC Char(25),
Primary Key (My_Product_Code) );

I hope this helps,

G4!



Steve Richter wrote:

On 7/10/05, Rich Duzenbury <rduz-midrange@xxxxxxxxxxxxxxxxxxx> wrote:

On Sun, 2005-07-10 at 10:20 -0400, Steve Richter wrote:

http://channel9.msdn.com/ShowForum.aspx?ForumID=14
I cant disagree with what Ballmer says about IBM. Working on a mega sized
570 lately. It is crazy that we have to crunch our file and program names
down to 8 and 10 characters. With 1.5TB of data and programs, after a while
you run out of characters for the object names!
-Steve

Not very likely.  You might have some trouble with systematic naming
methods, but you will have a very hard time running out of naming space
even for a ten character object name.

Consider if the first character must be a letter, A-Z for 26
combinations, and limit the other nine characters to A-Z and 0-9 for 36
combinations, you can easily get 26 * 36^9 possible combinations, or
2,640,558,873,378,816 possible names.  More if you include some of the
available punctuation characters.  But, you probably knew that already.

Why are you posting this?  Nothing better to do?  Just trying to piss
people off?  I happen to think Steve Ballmer is just the mouth piece of
Microsoft, and _anything_ he has to say has to be taken with a big grain
of salt due to his blue colored glasses.

the system is enabling me to make a living but with the do nothing
crowd at IBM I fear that will not be the case even a year or two from
now.   IBM just got $700 million in whine money from MSFT.  Does
anyone expect them to invest that money and improve OS400?   How much
work could it be to enable long object  and field names on the system?

Where I am at we use SQL a lot.  Model the queries using STRSQL, then
cut and paste from the SQL editor to the CL editor.  The only advance
in the last 20 years is the windows cut and paste feature!  What about
a /bgn-sql and /end-sql block in CL.  That would make my sql code a
lot more readable.

Then you assign column names in an SQL table that is > 8 characters. Use that table in an rpg program and the programmer has to deal with

renaming the fields from the generated 8 character name to the full
SQL column name.

Hoping someone can prove me wrong on all of this.  I only have 1 week
experience programming SQL on the 400. :)

-Steve