|
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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.