-
Junior Member
Group level data item in WHERE clause
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
-
Junior Member
Re: Group level data item in WHERE clause
-
Junior Member
Re: Group level data item in WHERE clause
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.
-
Junior Member
Re: Group level data item in WHERE clause
Yes.You can use it. Just confirmed too :-)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules