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

[Geeky400 <Geeky400@xxxxxxxxxxx>]

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
>
>