Re: Embedded SQL in Free-Format RPG

["Danforth, Ken" <kdanforth@xxxxxxxxxx>]

Thanks for the response, Jerry.
I didn't lose the D specs.  They are still there; it's just that the fields 
defined with the LIKE keyword don't seem to be resolved for the SQL 
pre-compiler.

Ken Danforth
Amscan, Inc.
80 Grasslands Rd
Elmsford, NY  10523
Voice:  914.784.4161
Fax:  914.784.8819
 

-----Original Message-----

date: Thu, 27 Oct 2005 11:58:58 -0500
from: Jerry Adams <jerry@xxxxxxxxxxxxxxx>
subject: Re: Embedded SQL in Free-Format RPG

Ken,

I haven't done any embedded SQL yet, but this confuses me.  I.e., the 
part about the variables being defined in the D-specs in fixed format, 
but after using WDSc to convert to free-format they are not.  Now, 
converting fixed to free I've done many times, and never lost a D-spec 
yet. 

The LIKE(field) has to be defined somewhere in the database or program, 
as you know.  I cannot think of any reason why it would just "go away".  
Maybe some before and after snips of the pertinent code would help my 
aged mind.

Thanks.


        * Jerry C. Adams
*iSeries/i5 Programmer/Analyst
B&W Wholesale Distributors, Inc.* *
voice
        615.893.8633x152
fax
        615.995.1201
email
        jerry@xxxxxxxxxxxxxxx <mailto:jerry@xxxxxxxxxxxxxxx>