 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 3 matches |
| Author | Message |
|---|---|
 Topic: Selecting rows based on DB2 DATE & TIME ranges |
|
| Jose Replies: 8 Views: 3662 |
 Forum: Database Posted: Mon Oct 20, 2008 11:30 am Subject: Selecting rows based on DB2 DATE & TIME ranges |
| bauer, The exisiting DB2 table is not indexed by these columns, D_ACT & T_ACT. That's one of my concerns for performance issue. I will try CraigG's suggestion as well. Thanks. | |
| Topic: Selecting rows based on DB2 DATE & TIME ranges |
|
| Jose Replies: 8 Views: 3662 |
Forum: Database Posted: Mon Oct 20, 2008 11:17 am Subject: Selecting rows based on DB2 DATE & TIME ranges |
| danm, your query is much simpler than mine. Thanks to you and to all who provided solutions & suggestions.
I tested my own query afew times and it looks like it is working (not 100% sure) but you ... |
|
| Topic: Selecting rows based on DB2 DATE & TIME ranges |
|
| Jose Replies: 8 Views: 3662 |
Forum: Database Posted: Mon Oct 20, 2008 9:06 am Subject: Selecting rows based on DB2 DATE & TIME ranges |
| Could anyone help me in writing a query for the below requirements?
I have a DB2 table with columns: D_ACT defined as DATE (format CCYY-MM-DD) T_ACT defined as TIME (format HH.MM.SS) I want to ... |
|
All times are GMT - 5 Hours |