RE: sqlrpgle & copy book

[<Rick.Chevalier@xxxxxxxxxxxxxxx>]

I thought someone did this, I just couldn't remember who.  I haven't tried in a 
while so it was probably something I did wrong at the time.

Thanks for correcting that.

Rick

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Joel Cochran
Sent: Friday, February 11, 2005 4:43 AM
To: RPG programming on the AS400 / iSeries
Subject: RE: sqlrpgle & copy book


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


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.