Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
Group level data item in WHERE clause
This is a discussion on Group level data item in WHERE clause within the DB2 forums, part of the Databases category; 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. ...
|
|||||||
09-11-2007
|
|||
|
|||
|
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
|
| Sponsored Links |
|
10-02-2008
|
|||
|
|||
|
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.
|
 |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Join two tables and apply group by clause | Geek_Guest | SQL | 3 | 06-18-2009 02:53 PM |
| Is it possible to group data in internal table | Geek_Guest | SAP R/3 | 0 | 07-14-2007 12:05 AM |
| 2 high level and 2 low level design techniques | Geek_Guest | Testing Issues | 0 | 06-25-2007 05:52 AM |
| shift data with a REDEFINES clause | Geek_Guest | MainFrame | 1 | 04-11-2007 10:44 AM |
| Output port and Group by clause in SQ | JobHelper | Data Warehousing | 1 | 01-04-2007 12:17 PM |
All times are GMT -4. The time now is 01:30 PM.
