RE: Strange SQL

["Phil" <sublime78ska@xxxxxxxxx>]

Are any of the fields null capable?

Phil

> -----Original Message-----
> From: rpg400-l-admin@midrange.com [mailto:rpg400-l-admin@midrange.com]On
> Behalf Of MWalter@hanoverwire.com
> Sent: Wednesday, September 12, 2001 1:35 PM
> To: rpg400-l@midrange.com; rpgiv@yahoogroups.com
> Subject: RE: Strange SQL
>
>
> OK, I thought I had it working. Now a new problem. When I issue the
> statement:
>
> SELECT a.itnbr,b.itdsc,a.edate,a.itcls,b.lstum,a.price,b.unmsr,
> b.itcls FROM Prcmst a LEFT OUTER JOIN Itemasa b ON a.itnbr
>  = b.itnbr WHERE cusno =   206800 ORDER BY a.itnbr
>
> out of my RPG program, I can't receive the data from the primary file if
> there is no matching secondary record. I look in debug and the data is
> being returned from the query but not moved into the host variables. The
> SQLCOD following the FETCH statement is -305 (Indicator variable
> required).
>
> What am I missing?
>
>
> Thanks,
>
> Mark
>
>
> Mark Walter
> Sr. Programmer/Analyst
> Hanover Wire Cloth a div of CCX, Inc.
> mwalter@hanoverwire.com
> http://www.hanoverwire.com
> 717.637.3795 Ext.3040
>
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com