Re: DFSORT/ICETOOL pondering

2014-10-23 Thread Thomas Berg
-Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Elardus Engelbrecht Sent: Wednesday, October 22, 2014 3:52 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: DFSORT/ICETOOL pondering Thomas Berg wrote: Sometimes I have a need to do

Re: DFSORT/ICETOOL pondering

2014-10-23 Thread Norbert Friemel
On Thu, 23 Oct 2014 15:43:44 +0200, Thomas Berg wrote: I want to copy position 31 to 40 of all records but from record 8 and 9 I want to copy also (concatenate) position 71 to 80 and from record 6 to 8 I also (concatenate in front) want to copy position 1 to 3. //*

Re: DFSORT/ICETOOL pondering

2014-10-23 Thread Thomas Berg
Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Sri h Kolusu Sent: Wednesday, October 22, 2014 6:12 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: DFSORT/ICETOOL pondering Thomas, I do think it is possible to reformat the selective data using symbols from various positions

Re: DFSORT/ICETOOL pondering

2014-10-23 Thread Thomas Berg
22, 2014 8:45 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: DFSORT/ICETOOL pondering Thomas, In the example that you stated, 1. are the records apart of a set of records 2. does each record have a unique identifier and sequence key. If so, the you could extract records 8 and perform

Re: DFSORT/ICETOOL pondering

2014-10-23 Thread Elardus Engelbrecht
Thomas Berg wrote: An hypotethical example (monospace font recommended): Input: +1+2+3+4+5+6+7+8 001aaa01cc01

Re: DFSORT/ICETOOL pondering

2014-10-23 Thread Thomas Berg
-Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Norbert Friemel Sent: Thursday, October 23, 2014 3:58 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: DFSORT/ICETOOL pondering On Thu, 23 Oct 2014 15:43:44 +0200, Thomas Berg wrote

Re: DFSORT/ICETOOL pondering

2014-10-23 Thread Norbert Friemel
On Thu, 23 Oct 2014 16:07:41 +0200, Thomas Berg wrote: Thanks for the example. Although the numeric sequence numbers were there just to clarify the operation, rather than be an indication of the assumed format of an actual case. Do you have an example where you can’t rely on a

Re: DFSORT/ICETOOL pondering

2014-10-23 Thread Elardus Engelbrecht
Thomas Berg wrote: Thanks for the example. Thanks Norbert Friemel for your example showing IFTHEN and BUILD. Although the numeric sequence numbers were there just to clarify the operation, rather than be an indication of the assumed format of an actual case. Do you have an example where

Re: DFSORT/ICETOOL pondering

2014-10-23 Thread Thomas Berg
-Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Elardus Engelbrecht Sent: Thursday, October 23, 2014 4:06 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: DFSORT/ICETOOL pondering Thomas Berg wrote: An hypotethical example

Re: DFSORT/ICETOOL pondering

2014-10-23 Thread Thomas Berg
-Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Norbert Friemel Sent: Thursday, October 23, 2014 4:13 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: DFSORT/ICETOOL pondering On Thu, 23 Oct 2014 16:07:41 +0200, Thomas Berg wrote

Re: DFSORT/ICETOOL pondering

2014-10-23 Thread Thomas Berg
-Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Norbert Friemel Sent: Thursday, October 23, 2014 3:58 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: DFSORT/ICETOOL pondering //STEP1 EXEC PGM=SORT //SYSOUTDD SYSOUT

Re: DFSORT/ICETOOL pondering

2014-10-23 Thread Norbert Friemel
On Thu, 23 Oct 2014 16:36:04 +0200, Thomas Berg wrote: When looking at this a second time, it seems very promising and more customizable than SUBSET + other options. One question: you placed the BI-field at the end. If it was very long records, would it from a performance view be better

Re: DFSORT/ICETOOL pondering

2014-10-23 Thread Sri h Kolusu
: DFSORT/ICETOOL pondering Sent by: IBM Mainframe Discussion List IBM-MAIN@LISTSERV.UA.EDU -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Elardus Engelbrecht Sent: Wednesday, October 22, 2014 3:52 PM To: IBM-MAIN

Re: DFSORT/ICETOOL pondering

2014-10-23 Thread Sri h Kolusu
Thanks, Kolusu DFSORT Development IBM Mainframe Discussion List IBM-MAIN@LISTSERV.UA.EDU wrote on 10/23/2014 07:14:38 AM: From: Elardus Engelbrecht elardus.engelbre...@sita.co.za To: IBM-MAIN@LISTSERV.UA.EDU Date: 10/23/2014 07:15 AM Subject: Re: DFSORT/ICETOOL pondering Sent by: IBM Mainframe

Re: DFSORT/ICETOOL pondering

2014-10-23 Thread Thomas Berg
@LISTSERV.UA.EDU Subject: Re: DFSORT/ICETOOL pondering Thomas, As others have explained it is quite simple to get the desired results. I am showing examples for both FB and VB files using symbols. With symbols you have the flexibility of changing it and then not worry about changing the control

Re: DFSORT/ICETOOL pondering

2014-10-23 Thread Steve Comstock
To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: DFSORT/ICETOOL pondering Thomas, As others have explained it is quite simple to get the desired results. I am showing examples for both FB and VB files using symbols. With symbols you have the flexibility of changing it and then not worry about changing

Re: DFSORT/ICETOOL pondering

2014-10-22 Thread Elardus Engelbrecht
Thomas Berg wrote: Sometimes I have a need to do a selective copy of a dataset where the selection is both record sequence and record position/part dependent. And by that I mean the record part/position is varying depending on which record it's about. An example (yes, it looks silly): Who

Re: DFSORT/ICETOOL pondering

2014-10-22 Thread Sri h Kolusu
Date: 10/21/2014 10:56 PM Subject: DFSORT/ICETOOL pondering Sent by: IBM Mainframe Discussion List IBM-MAIN@LISTSERV.UA.EDU Sometimes I have a need to do a selective copy of a dataset where the selection is both record sequence and record position/part dependent. And by that I mean

Re: DFSORT/ICETOOL pondering

2014-10-22 Thread Alfred Cole
Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Sri h Kolusu Sent: Wednesday, October 22, 2014 11:12 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: DFSORT/ICETOOL pondering Thomas, I do think it is possible to reformat the selective data using symbols

DFSORT/ICETOOL pondering

2014-10-21 Thread Thomas Berg
Sometimes I have a need to do a selective copy of a dataset where the selection is both record sequence and record position/part dependent. And by that I mean the record part/position is varying depending on which record it's about. An example (yes, it looks silly): I want to copy position