RE: Help W/SQL

[Mark Walter <mwalter@xxxxxxxxxx>]

Sorry about the previous message. The copies of the screen shots didn't 
make it to the email.

The SQL Statement is:
C/Exec SQL
C+ Insert into HWOEIY/OEHHST
C+  Select * from HWOEI/OEHHST where ordno = :ordno
C/End-Exec

The error I receive is:
SQL0206  Column Ordno is not in specified tables

The column does exist in the specified tables.
Also, it only fails on the last of 7 statements similar statements. If  I 
remove one of the statements, it still fails on only the last one with the 
same error.

Thank You,

Mark Walter

-----Original Message-----
From:   Mark Walter [SMTP:mwalter@netrax.net]
Sent:   Monday, April 24, 2000 11:01 AM
To:     List RPG400 (E-mail)
Subject:        Help W/SQL


I am trying to embed SQL into an ILE RPG IV program. There are a number of 
SQL statements just like this one:


When I try to compile it, the compile fails on the last statement with the 
following error:


Any help would be appreciated.

Thanks in advance,

Mark Walter
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---