RE: Strange SQL

Eric,

Cusno is not in file b. the statement is executing, however there is code
that the precompiler inserts that will not allow the results to be placed
in my host variables. I can see the value that I need using debug. It is
one of those SQL_000XX variables. Maybe I can just move that data to my
host variables further down in the module. What d'ya think?


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



                    "DeLong, Eric"
                    <EDeLong@Sallybea        To:     "'rpg400-l@midrange.com'" 
<rpg400-l@midrange.com>
                    uty.com>                 cc:
                    Sent by:                 Subject:     RE: Strange SQL
                    rpg400-l-admin@mi
                    drange.com


                    09/12/01 03:28 PM
                    Please respond to
                    rpg400-l






Is cusno by any chance in file B? You didn't specify in your WHERE clause.

Eric DeLong
Sally Beauty Company
MIS-Sr. Programmer/Analyst
940-898-7863 or ext. 1863



-----Original Message-----
From: MWalter@hanoverwire.com [mailto:MWalter@hanoverwire.com]
Sent: Wednesday, September 12, 2001 12: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.


_______________________________________________
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.