Re: SQL0312

[rob@xxxxxxxxx]

DSPMSGD RANGE(SQL0312) MSGF(QSQLMSG)

One of two things:
1 - Does WCUSNR show up as a valid RPG variable in your dump?
2 - Youre using a prepare statement.  translation:  You are using dynamic 
sql.  Using a host variable in dynamic sql is forbidden according to 
SQL0312.  Therefore you have to do something like
MySql = 'Select c.*, i.* From NXCHNBIL C Left Outer Join NXITMMST I On 
c.ITNBR = i.ITNBR Where c.ACREC = '''A''' and i.NFDCD = 1 and ((c.CUSNR = 
'
+ ''' + char(wcusnr) + ... (you get the rest of it, right?)
Then do your prepare statement.  Basically your converting the host 
variable into a literal and appending that into your sql statement in 
MySql.  Understand?

Rob Berendt