 |
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 4 matches |
| Author | Message |
|---|---|
 Topic: Sort and copy |
|
| deep81this Replies: 2 Views: 2818 |
 Forum: Utilities Posted: Wed Mar 30, 2016 10:07 am Subject: Sort and copy |
| output file shud be like:
Result file: ********************************* Top of Data ****************** ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+- 0216CDH333670 ... |
|
| Topic: Sort and copy |
|
| deep81this Replies: 2 Views: 2818 |
Forum: Utilities Posted: Wed Mar 30, 2016 9:59 am Subject: Sort and copy |
| I have a requirement in which
File-1 pos 1-13 is the sort key for all records other than starting with '8 44' or '8 40' ; col 14 can have 2,3,4 etc which denotes transaction type. If there is a 4 ... |
|
| Topic: Getting Second Sunday of March and First Sunday of November |
|
| deep81this Replies: 3 Views: 4926 |
Forum: Application Programming Posted: Mon Jun 04, 2012 12:59 am Subject: Getting Second Sunday of March and First Sunday of November |
| thanku Kolusu, it worked for ur sql as
SELECT DATE(NEXT_DAY(LAST_DAY('2013-02-01'),'SUN') + 7 DAYS) ,DATE(NEXT_DAY(DATE('2013-10-31'),'SUN'& ... |
|
| Topic: Getting Second Sunday of March and First Sunday of November |
|
| deep81this Replies: 3 Views: 4926 |
Forum: Application Programming Posted: Thu May 10, 2012 4:04 am Subject: Getting Second Sunday of March and First Sunday of November |
| Hi,
Could any one help me. My requirement is to get the Second Sunday (date) of March and first Sunday of November of any year using SQL query alone. DB2 version is 9.0. Thanks in advance, Deep ... |
|
All times are GMT - 5 Hours |