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

Not that I disagree in part with what Ballmer has said, it is amazing that 
Microsoft seems to constantly attack others; they did it with Linux for 
years.....are they afraid that IBM is going to come up with something that 
is better than their starship ?

On Mon, 11 Jul 2005 07:58:42 -0400, Gregory A. Garner   GDS, Inc wrote
> Plus, you can use the long field name in Cobol as well.  Started 
> doing that around 87 on the 38.
> 
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Geeky400
> Sent: Monday, July 11, 2005 6:30 AM
> To: Midrange Systems Technical Discussion
> Subject: Re: SQL -- Steve Ballmer says IBM is not innovating lately --
> 
> Not sure you have to rename your fields to use your SQL table in 
> RPG... What about that:
> 
> 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) );
> 
> You can use either the long field name or the short one. In 
> interactive SQL
> (STRSQL), you can use the F19 function key when prompting the fields 
> in order to toggle from Long to Short field name.
> 
> 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
> >
> >  
> >
> 
> --
> 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.
> 
> -- 
> 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.


If you bought, it was hauled by a truck - somewhere, sometime.