Re: SQLRPG

On 01/10/2008, at 5:55 PM, David FOXWELL wrote:

I find it strange that I can't find an example that shows the RPG code that SQL is supposed to be embedded into!

Then you're not looking hard enough.

Information Centre ->Database->Programming->Embedded SQL Programming- >Coding SQL Statements in RPG/400 Applications.

Quite logical when you think about it. Examples are found in the links at the bottom of the first page.

I'm getting the compile error QRG5175 that states positions 7 and 8 are incorrect for a subroutine specification. In SEU, no error is highlighted whilst editing. Maybe the compiler is missing something. We don't have any SQLRPG programs but no problems with SQLRPGLE.

That message says you have invalid characters in positions 7 and 8. Since the C must be in position 6 the compiler must be complaining about the /E or the + . Since those are valid characters in those positions for SQLRPG are you running the correct compiler?

Regards,
Simon Coulter.
--------------------------------------------------------------------
FlyByNight Software OS/400, i5/OS Technical Specialists

http://www.flybynight.com.au/
Phone: +61 2 6657 8251 Mobile: +61 0411 091 400 /"\
Fax: +61 2 6657 8251 \ /
X
ASCII Ribbon campaign against HTML E-Mail / \
--------------------------------------------------------------------