RE: Embedded SQL - fetching a date

["Kurt Anderson" <kjanderson@xxxxxxxxxxxxx>]

Checked that before I sent out the email.
Thanks for the brainstorming.

Kurt Anderson
Application Developer
Highsmith Inc

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Wilt, Charles
Sent: Friday, July 15, 2005 2:54 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: Embedded SQL - fetching a date

That usually means that the field name is not unique within the source.

Charles Wilt
--
iSeries Systems Administrator / Developer Mitsubishi Electric Automotive
America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Kurt Anderson
> Sent: Friday, July 15, 2005 3:39 PM
> To: RPG programming on the AS400 / iSeries
> Subject: RE: Embedded SQL - fetching a date
> 
> 
> MSG ID  SEV  RECORD  TEXT
> 
> SQL5011  30     136  Position 45 Host structure array FILEADS not
> defined or
>                      not usable.
> 
> 
> And it is defined when I look at the listing.
> 
> Kurt Anderson
> Application Developer
> Highsmith Inc
> 
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Tyler, Matt
> Sent: Friday, July 15, 2005 2:21 PM
> To: 'RPG programming on the AS400 / iSeries'
> Subject: RE: Embedded SQL - fetching a date
> 
> Kurt, what error messages are you receiving (if any)?  (i.e., CPF*, 
> SQLSTT,
> SQLCOD)
> 
> Thank you,
> Matt Tyler
> WinCo Foods, LLC
> mattt@xxxxxxxxxxxxxx
> 
> 
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
> On Behalf Of Kurt Anderson
> Sent: Friday, July 15, 2005 1:18 PM
> To: RPG programming on the AS400 / iSeries
> Subject: RE: Embedded SQL - fetching a date
> 
> Sorry, sent an incorrect file layout.  Corrected: 
> 
> Data on FILEA:
> A            OHNUM          7P 0
> A            OHBILL         9P 0
> A            OHKEYDATE       L 
> 
> Kurt Anderson
> Application Developer
> Highsmith Inc
> 
> --
> 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.
> 
>