RE: sqlrpgle & copy book

[Joel Cochran <jrc@xxxxxxxxxx>]

On Fri, 2005-02-11 at 14:08, Rick.Chevalier@xxxxxxxxxxxxxxx wrote:
> Also make sure the sub fields are defined in your copybook.  I have not been 
> able to use externally defined data structures as result sets for embedded 
> SQL.  The compiler always complains they aren't defined or usable.

I use externally defined DS all the time for SQL:

d slotDS        e ds                  extname( hearslots )

c/exec SQL
c+   Select *
c+    into :slotDS
c+    from HEARSLOTS
c/end-exec

Code is running at V5R1.  Could it be that this doesn't function well
inside a /copy?  Maybe try /include instead?

Joel Cochran
http://www.rpgnext.com


> I vaguely remember someone posting to this list that they got embedded SQL to 
> work using an externally described DS as the result set but I may be 
> mistaken.  Check the archives, this has been discussed several times before.
> 
> Rick
> 
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of
> SRamanujan@xxxxxxxxxxxxxxxxxx
> Sent: Thursday, February 10, 2005 4:32 PM
> To: rpg400-l@xxxxxxxxxxxx
> Subject: sqlrpgle & copy book
> 
> 
> Hi all,
> When I have a copy book that has the data structure, and fetch into the
> ds, I get a sql pre-compiler error SQL0312 'The DSNAME is not define or
> not usable' Is there anyway to avoid this?
> Thanks,
> Sudha
> 
> Sudha Ramanujan
> SunGard Futures Systems
> sramanujan@xxxxxxxxxxxxxxxxxx
> (312) 577 6179
> (312) 577 6101 - Fax
> 
> 
> Privileged and Confidential.  This e-mail, and any attachments there to, is 
> intended only for use by the addressee(s) named herein and may contain 
> legally privileged or confidential information.  If you have received this 
> e-mail in error, please notify me immediately by a return e-mail and delete 
> this e-mail.  You are hereby notified that any dissemination, distribution or 
> copying of this e-mail and/or any attachments thereto, is strictly prohibited.