Re: SQL Error SQLCOD = -000000303 SQLSTT = '42806'

Depends on your select.  For a nice single file select you could do 
something like:

D MyDS   EDS                                            extname(myfile)
c/exec sql
c+ Select field1, field2 into :field1, :field2 from MyFile
c+ where keyfield=:SomeVar
c/end-exec

or even
c/exec sql
c+ select * into :MyDS from MyFile
c+ where keyfield=:SomeVar
c/end-exec


Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





Pete Helgren <Pete@xxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
04/08/2005 01:51 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
Midrange Mailing List <MIDRANGE-L@xxxxxxxxxxxx>
cc

Subject
SQL Error SQLCOD = -000000303 SQLSTT = '42806'






Using embedded SQL in RPG IV.  V5R2M0.....

I get an SQLCOD = -000000303 with SQLSTT = '42806' which is telling me I 
have a host variable that is incompatible ("A value cannot be assigned 
to a host variable, because the data types are not compatible.")

OK...that doesn't surprise me, I have some numeric data coming in and I 
guess that I defined the host variable incorrectly.

So, two questions arise:

1.How can I tell which, of the 11 fields in my select statement, is 
causing the error? and...

2. Is there an "easy" way to define host variables (or some 'trick' I 
can use) so that my selected fields from the tables match the host 
variables I select them into?

Am I making this too hard?  In Java I can "point" my results to a result 
set (rs) and then access them using rs.field1, rs.field2, rs.field3, 
etc.  Mapping the select statement into host variables is a drag in 
RPG.  Perhaps there is an easier way? I am all ears....

Thanks,

Pete Helgren


-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.