| Author |
Message |
Topic: Extract a record based on date range |
gps_94
Replies: 4
Views: 4158
|
Forum: Utilities Posted: Mon Feb 04, 2019 7:46 pm Subject: Extract a record based on date range |
Below is the data looks like from position 75.
+----8----+----9----+----0----+----1----+----2----+----3
********************************* Top of Data **********
,TEST,2006-11-06,06:00:00,2006-11- ... |
Topic: Extract a record based on date range |
gps_94
Replies: 4
Views: 4158
|
Forum: Utilities Posted: Mon Feb 04, 2019 7:28 pm Subject: Extract a record based on date range |
Hi,
I have a below requirement:
File Length: 160
Start Date field starts at position 81 (YYYY-MM-DD) and stop date starts at position 101 (YYYY-MM-DD)
I need to extract the records for dat ... |
Topic: Extract record based on Seq No (HEX) & Key 3 using SORT |
gps_94
Replies: 4
Views: 2891
|
Forum: Utilities Posted: Fri Aug 03, 2018 5:16 pm Subject: Extract record based on Seq No (HEX) & Key 3 using SORT |
Thanks a lot Kolusu .
Also, if you can tell me how we can achieve this using DFSORT instead of using SYNCSORT. |
Topic: Extract record based on Seq No (HEX) & Key 3 using SORT |
gps_94
Replies: 4
Views: 2891
|
Forum: Utilities Posted: Fri Aug 03, 2018 3:48 pm Subject: Extract record based on Seq No (HEX) & Key 3 using SORT |
Hi,
I have a below requirement and need a solution for this using DFSORT/any other utility
XXXX ____2018-08-01-13.49.53.655020Y123456 A B
YYYY ____2018-08-01-13.52.31.311231Y123456 C B
YY ... |
| |