Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

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-...

Geeks Talk > Databases > DB2 Group level data item in WHERE clause

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   09-11-2007

kulkarte Junior Member   Join Date: Sep 2007 Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts

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

#2 (permalink)   08-29-2008

savithaN Junior Member   Join Date: Aug 2008 Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts

Re: Group level data item in WHERE clause yes you can use it

#3 (permalink)   1 Week Ago

rengupta83 Junior Member   Join Date: Oct 2008 Location: Delhi Posts: 3 Thanks: 0 Thanked 0 Times in 0 Posts

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.

Geeks Talk > Databases > DB2

« what is the bind process , explain. | - »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Is it possible to group data in internal table	Geek_Guest	SAP R/3	0	07-13-2007 11:05 PM
Join two tables and apply group by clause	Geek_Guest	SQL	1	07-10-2007 02:27 AM
2 high level and 2 low level design techniques	Geek_Guest	Testing Issues	0	06-25-2007 04:52 AM
shift data with a REDEFINES clause	Geek_Guest	MainFrame	1	04-11-2007 09:44 AM
Output port and Group by clause in SQ	JobHelper	Data Warehousing	1	01-04-2007 11:17 AM

All times are GMT -4. The time now is 11:59 PM.