Group level data item in WHERE clause

[kulkarte]

Can I use a group level data item in the where clause of a DB2 query in cobol? e.g:Select * from tablenamewhere bill_id in (:bil-id-list);bill-id-list is declared as: 01 bill-id-list. 05 bill-id-1 05 bill-id-2

[savithaN]

yes you can use it

[rengupta83]

Yes, we can use it . For example if you are comparing the birthdate column for an employee which is splitted into month, date , year . So, instead of comparing month, date and year as separate data, you may use group data to compare.

[Jinoop]

Yes.You can use it. Just confirmed too :-)