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

On 7/11/05, Geeky400 <Geeky400@xxxxxxxxxxx> wrote:
> 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,

it does.  thank you.

-Steve