RE: Strange SQL

["DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>]

Are you doing a FETCH into a user defined data structure?  Make sure your
data structure sub fields match up correctly to your field list in the
SELECT. "Indicator variable required" sounds like it wants to return boolean
values.  Can you post your FETCH statement?

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 3:38 PM
To: rpg400-l@midrange.com
Subject: 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