USING GROUP ITEM IN EMBEDDED SQL

[Baba Rahiman <baba.rahiman@xxxxxxxx>]

Hi,

Can I use a group variable in my embedded SQLCBL as host variable or not?


for ex:-

in Working storage section.

01 GROUP.
     05    XX       PIC  9(5).
     05    YY      PIC  9(2).


IN PROCEDURE DIVISION.

exec-sql
declare my-cursor  cursor for
   select * from my-table where myfield = :GROUP
end-exec.

______
I AM GETTING COMPILATION ERROR THAT VARIABLE "GROUP" IS UNDEFINED OR NOT USABLE.
BABA

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