Re: sqlrpgle & copy book -- RPG400-L

Considering you have FIELDDS (two Ds) as your DS name and the variable name
in the SQL statement is FIELDS (one D) that could be a problem.  FIELDS
isn't defined (the error message you're getting) but FIELDDS is.

Pay attention to your error messages.

BTW, this is another example of a single character typo in a field name.
This happens too often in RPG code with 6 & 10 character variable names.

Paul

-- 
Paul Morgan
Senior Programmer Analyst - Retail
J. Jill Group
100 Birch Pond Drive, PO Box 2009
Tilton, NH 03276-2009
Phone: (603) 266-2117
Fax:   (603) 266-2333
<SRamanujan@xxxxxxxxxxxxxxxxxx> wrote in
message news:FAC2A70D63CFF249BFE0291EE9001E52034636E3@xxxxxxxxxxxxxxxxxx
> Ok I checked the Archives and found to use /include instead of /copy but
> I still get the error SQL0312 'Fields is not defined or not usable'.
> What am I doing wrong. My code looks now as:
>
> Rpgle.myds
> dfieldDs ds
> d field1 5a
> d field2      15p 2
> d field3      30a
>
> sqlrpgle  :
>  /include rpgle,myds
> *
> d myDsNullI     ds
> d                                   based(myDsNullAd)
> d  myNullAry                   5i 0 dim(21)
>
> c/exec sql declare c cursor for select * from filea for read only
> c/end-exec
> c/exec sql open c
> c/end-exec
> c/exec sql fetch next from c into :fields :myNullAry
> c/end-exec
> c/exec sql close c
> c/end-exec
>
>
> Sudha Ramanujan
> SunGard Futures Systems
> sramanujan@xxxxxxxxxxxxxxxxxx
> (312) 577 6179
> (312) 577 6101 - Fax
>
>
> -----Original Message-----
> From: Rick.Chevalier@xxxxxxxxxxxxxxx
> [mailto:Rick.Chevalier@xxxxxxxxxxxxxxx]
> Sent: Friday, February 11, 2005 8:08 AM
> To: rpg400-l@xxxxxxxxxxxx
> Subject: RE: sqlrpgle & copy book
>
>
> 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 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.
>
> -- 
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
> list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>
> -- 
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>