Re: SYNCSORT or ICEMAN
Q: are you sure the method will not work with tape datasets? Just curious -- Radoslaw Skorupka Lodz, Poland W dniu 2012-12-20 18:30, George, William@FTB pisze: Thanks. A small detail I, again forgot, is these are TAPE datasets. :( Otherwise this would be a nice method. Bill -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Sri h Kolusu Sent: Thursday, December 20, 2012 9:22 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: SYNCSORT or ICEMAN George , Just to clarify ICEMAN is the program name for DFSORT. You can invoke DFSORT with PGM=ICEMAN. DFSORT's official three character identifier is ICE, so all of the DFSORT modules start with ICE (ICEMAN, ICETOOL, ICEGENER, etc) and all of the DFSORT messages start with ICE (ICExxxs). other sort products(Syncsort, ca-sort) use (SORT,ICEMAN) as an alias. Coming to your requirement, it is quite easy with batch version of Extended Search-For Utility (3.15). The String found indicator is mentioned by a numeric and at the bottom of the listing you will find corresponding dataset name. //SEARCH EXEC PGM=ISRSUPC,PARM=(SRCHCMP,'') //NEWDD DD DSN=Your GDG Base name, // DISP=SHR //OUTDD DD SYSOUT=* //SYSIN DD * SRCHFOR 'your search string' //* Sri Hari Kolusu IBM Mainframe Discussion List IBM-MAIN@listserv.ua.edu wrote on 12/20/2012 09:06:59 AM: From: George, William@FTB william.geo...@ftb.ca.gov To: IBM-MAIN@listserv.ua.edu, Date: 12/20/2012 09:08 AM Subject: Re: SYNCSORT or ICEMAN Sent by: IBM Mainframe Discussion List IBM-MAIN@listserv.ua.edu Sorry for the lack of a more descriptive subject. I did mean to go back and put one in but plain forgot. That seems to be happening a bit more than before. Hmmm. -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of George, William@FTB Sent: Thursday, December 20, 2012 8:57 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: SYNCSORT or ICEMAN I have a need to check 50 datasets (50 gens of a GDG) and extract records that match my criteria. I also would like to know which dataset in the concatenation the record was extracted from by adding an indicator to the output record. Is this possible via Syncsort or ICEMAN? I've made a quick scan of the Syncsort guide but now will dig deeper but thought I'd throw this question out also to hopefully help expedite the answer. -- Tre tej wiadomoci moe zawiera informacje prawnie chronione Banku przeznaczone wycznie do uytku subowego adresata. Odbiorc moe by jedynie jej adresat z wyczeniem dostpu osób trzecich. Jeeli nie jeste adresatem niniejszej wiadomoci lub pracownikiem upowanionym do jej przekazania adresatowi, informujemy, e jej rozpowszechnianie, kopiowanie, rozprowadzanie lub inne dziaanie o podobnym charakterze jest prawnie zabronione i moe by karalne. Jeeli otrzymae t wiadomo omykowo, prosimy niezwocznie zawiadomi nadawc wysyajc odpowied oraz trwale usun t wiadomo wczajc w to wszelkie jej kopie wydrukowane lub zapisane na dysku. This e-mail may contain legally privileged information of the Bank and is intended solely for business use of the addressee. This e-mail may only be received by the addressee and may not be disclosed to any third parties. If you are not the intended addressee of this e-mail or the employee authorised to forward it to the addressee, be advised that any dissemination, copying, distribution or any other similar activity is legally prohibited and may be punishable. If you received this e-mail by mistake please advise the sender immediately by using the reply facility in your e-mail software and delete permanently this e-mail including any copies of it either printed or saved to hard drive. BRE Bank SA, 00-950 Warszawa, ul. Senatorska 18, tel. +48 (22) 829 00 00, fax +48 (22) 829 00 33, www.brebank.pl, e-mail: i...@brebank.pl Sd Rejonowy dla m. st. Warszawy XII Wydzia Gospodarczy Krajowego Rejestru Sdowego, nr rejestru przedsibiorców KRS 025237, NIP: 526-021-50-88. Wedug stanu na dzie 01.01.2012 r. kapita zakadowy BRE Banku SA (w caoci wpacony) wynosi 168.410.984 zotych. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SYNCSORT or ICEMAN
quote I have a need to check 50 datasets (50 gens of a GDG) and extract records that match my criteria. I also would like to know which dataset in the concatenation the record was extracted from by adding an indicator to the output record. Is this possible via Syncsort or ICEMAN? unquote If you have SAS that's pretty easy. Somewhat like data _null_ ; length gdgdsn $44 ; infile gdgddn filename=gdgdsn ; input ; if index(_infile_,'your_search_string_here') ; file outddn ; put gdgdsn $44. +1 _infile_ ; run ; Infile option FILENAME= identifies the respective catenands of your gdg concatentation. The IF statement in this simple form is referred to as 'subsetting if' ie. it works like a filter. Kind regards Robert -- Robert Bardos Ansys AG, Switzerland -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SYNCSORT or ICEMAN
No SAS -Original Message- From: IBM Mainframe Discussion List on behalf of Robert Bardos2 Sent: Fri 12/21/2012 3:56 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: SYNCSORT or ICEMAN quote I have a need to check 50 datasets (50 gens of a GDG) and extract records that match my criteria. I also would like to know which dataset in the concatenation the record was extracted from by adding an indicator to the output record. Is this possible via Syncsort or ICEMAN? unquote If you have SAS that's pretty easy. Somewhat like data _null_ ; length gdgdsn $44 ; infile gdgddn filename=gdgdsn ; input ; if index(_infile_,'your_search_string_here') ; file outddn ; put gdgdsn $44. +1 _infile_ ; run ; Infile option FILENAME= identifies the respective catenands of your gdg concatentation. The IF statement in this simple form is referred to as 'subsetting if' ie. it works like a filter. Kind regards Robert -- Robert Bardos Ansys AG, Switzerland -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN __ CONFIDENTIALITY NOTICE: This email from the State of California is for the sole use of the intended recipient and may contain confidential and privileged information. Any unauthorized review or use, including disclosure or distribution, is prohibited. If you are not the intended recipient, please contact the sender and destroy all copies of this email. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
SYNCSORT or ICEMAN
I have a need to check 50 datasets (50 gens of a GDG) and extract records that match my criteria. I also would like to know which dataset in the concatenation the record was extracted from by adding an indicator to the output record. Is this possible via Syncsort or ICEMAN? I've made a quick scan of the Syncsort guide but now will dig deeper but thought I'd throw this question out also to hopefully help expedite the answer. Thanks Bill __ CONFIDENTIALITY NOTICE: This email from the State of California is for the sole use of the intended recipient and may contain confidential and privileged information. Any unauthorized review or use, including disclosure or distribution, is prohibited. If you are not the intended recipient, please contact the sender and destroy all copies of this email. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SYNCSORT or ICEMAN
Sorry for the lack of a more descriptive subject. I did mean to go back and put one in but plain forgot. That seems to be happening a bit more than before. Hmmm. -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of George, William@FTB Sent: Thursday, December 20, 2012 8:57 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: SYNCSORT or ICEMAN I have a need to check 50 datasets (50 gens of a GDG) and extract records that match my criteria. I also would like to know which dataset in the concatenation the record was extracted from by adding an indicator to the output record. Is this possible via Syncsort or ICEMAN? I've made a quick scan of the Syncsort guide but now will dig deeper but thought I'd throw this question out also to hopefully help expedite the answer. Thanks Bill __ CONFIDENTIALITY NOTICE: This email from the State of California is for the sole use of the intended recipient and may contain confidential and privileged information. Any unauthorized review or use, including disclosure or distribution, is prohibited. If you are not the intended recipient, please contact the sender and destroy all copies of this email. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SYNCSORT or ICEMAN
George , Just to clarify ICEMAN is the program name for DFSORT. You can invoke DFSORT with PGM=ICEMAN. DFSORT's official three character identifier is ICE, so all of the DFSORT modules start with ICE (ICEMAN, ICETOOL, ICEGENER, etc) and all of the DFSORT messages start with ICE (ICExxxs). other sort products(Syncsort, ca-sort) use (SORT,ICEMAN) as an alias. Coming to your requirement, it is quite easy with batch version of Extended Search-For Utility (3.15). The String found indicator is mentioned by a numeric and at the bottom of the listing you will find corresponding dataset name. //SEARCH EXEC PGM=ISRSUPC,PARM=(SRCHCMP,'') //NEWDD DD DSN=Your GDG Base name, // DISP=SHR //OUTDD DD SYSOUT=* //SYSIN DD * SRCHFOR 'your search string' //* Sri Hari Kolusu IBM Mainframe Discussion List IBM-MAIN@listserv.ua.edu wrote on 12/20/2012 09:06:59 AM: From: George, William@FTB william.geo...@ftb.ca.gov To: IBM-MAIN@listserv.ua.edu, Date: 12/20/2012 09:08 AM Subject: Re: SYNCSORT or ICEMAN Sent by: IBM Mainframe Discussion List IBM-MAIN@listserv.ua.edu Sorry for the lack of a more descriptive subject. I did mean to go back and put one in but plain forgot. That seems to be happening a bit more than before. Hmmm. -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of George, William@FTB Sent: Thursday, December 20, 2012 8:57 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: SYNCSORT or ICEMAN I have a need to check 50 datasets (50 gens of a GDG) and extract records that match my criteria. I also would like to know which dataset in the concatenation the record was extracted from by adding an indicator to the output record. Is this possible via Syncsort or ICEMAN? I've made a quick scan of the Syncsort guide but now will dig deeper but thought I'd throw this question out also to hopefully help expedite the answer. Thanks Bill __ CONFIDENTIALITY NOTICE: This email from the State of California is for the sole use of the intended recipient and may contain confidential and privileged information. Any unauthorized review or use, including disclosure or distribution, is prohibited. If you are not the intended recipient, please contact the sender and destroy all copies of this email. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SYNCSORT or ICEMAN
Thanks. A small detail I, again forgot, is these are TAPE datasets. :( Otherwise this would be a nice method. Bill -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Sri h Kolusu Sent: Thursday, December 20, 2012 9:22 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: SYNCSORT or ICEMAN George , Just to clarify ICEMAN is the program name for DFSORT. You can invoke DFSORT with PGM=ICEMAN. DFSORT's official three character identifier is ICE, so all of the DFSORT modules start with ICE (ICEMAN, ICETOOL, ICEGENER, etc) and all of the DFSORT messages start with ICE (ICExxxs). other sort products(Syncsort, ca-sort) use (SORT,ICEMAN) as an alias. Coming to your requirement, it is quite easy with batch version of Extended Search-For Utility (3.15). The String found indicator is mentioned by a numeric and at the bottom of the listing you will find corresponding dataset name. //SEARCH EXEC PGM=ISRSUPC,PARM=(SRCHCMP,'') //NEWDD DD DSN=Your GDG Base name, // DISP=SHR //OUTDD DD SYSOUT=* //SYSIN DD * SRCHFOR 'your search string' //* Sri Hari Kolusu IBM Mainframe Discussion List IBM-MAIN@listserv.ua.edu wrote on 12/20/2012 09:06:59 AM: From: George, William@FTB william.geo...@ftb.ca.gov To: IBM-MAIN@listserv.ua.edu, Date: 12/20/2012 09:08 AM Subject: Re: SYNCSORT or ICEMAN Sent by: IBM Mainframe Discussion List IBM-MAIN@listserv.ua.edu Sorry for the lack of a more descriptive subject. I did mean to go back and put one in but plain forgot. That seems to be happening a bit more than before. Hmmm. -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of George, William@FTB Sent: Thursday, December 20, 2012 8:57 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: SYNCSORT or ICEMAN I have a need to check 50 datasets (50 gens of a GDG) and extract records that match my criteria. I also would like to know which dataset in the concatenation the record was extracted from by adding an indicator to the output record. Is this possible via Syncsort or ICEMAN? I've made a quick scan of the Syncsort guide but now will dig deeper but thought I'd throw this question out also to hopefully help expedite the answer. Thanks Bill __ CONFIDENTIALITY NOTICE: This email from the State of California is for the sole use of the intended recipient and may contain confidential and privileged information. Any unauthorized review or use, including disclosure or distribution, is prohibited. If you are not the intended recipient, please contact the sender and destroy all copies of this email. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SYNCSORT or ICEMAN
How about testing with 1 GDG to 1 DSN, keeping the records. Once satisfied, do a change all and submit for the other 49 GDGs. When done, delete the empty datasets and utilize the remainder with records. On Thu, Dec 20, 2012 at 11:30 AM, George, William@FTB william.geo...@ftb.ca.gov wrote: Thanks. A small detail I, again forgot, is these are TAPE datasets. :( Otherwise this would be a nice method. Bill -- Mike A Schwab, Springfield IL USA Where do Forest Rangers go to get away from it all? -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SYNCSORT or ICEMAN
I hope I did fully understand your question. I think you could solve using different steps with quite similar include and outrec cards or something like the following (only for two files and you can extend for the needed using the correct disposition): //ST011 EXEC PGM=ICETOOL //TOOLMSG DD SYSOUT=* //DFSMSG DD SYSOUT=* //SI01 DD * A1234567890 B1234567890 C1234567890 D1234567890 /* //SI02 DD * A1234567890 B1234567890 C1234567890 D1234567890 /* //SO01 DD SYSOUT=* //SO02 DD SYSOUT=* //TOOLIN DD * COPY FROM(SI01) TO(SO01) USING(CTL1) COPY FROM(SI02) TO(SO02) USING(CTL2) /* //CTL1CNTL DD * INCLUDE COND=(1,1,CH,EQ,C'A') OUTREC FIELDS=(C'01',1,80) /* //CTL2CNTL DD * INCLUDE COND=(1,1,CH,EQ,C'A') OUTREC FIELDS=(C'02',1,80) /* If you meant something doing all the job automagically :D, then I don't know. Regards. Max Da: George, William@FTB william.geo...@ftb.ca.gov A: IBM-MAIN@LISTSERV.UA.EDU Inviato: Giovedì 20 Dicembre 2012 17:57 Oggetto: SYNCSORT or ICEMAN I have a need to check 50 datasets (50 gens of a GDG) and extract records that match my criteria. I also would like to know which dataset in the concatenation the record was extracted from by adding an indicator to the output record. Is this possible via Syncsort or ICEMAN? I've made a quick scan of the Syncsort guide but now will dig deeper but thought I'd throw this question out also to hopefully help expedite the answer. Thanks Bill __ CONFIDENTIALITY NOTICE: This email from the State of California is for the sole use of the intended recipient and may contain confidential and privileged information. Any unauthorized review or use, including disclosure or distribution, is prohibited. If you are not the intended recipient, please contact the sender and destroy all copies of this email. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SYNCSORT or ICEMAN
I'm doing something similar. I have one job with 50 steps. The output dataset is the same in all (MOD'ed). Each step has an OUTREC statement that tacks on to the end of the output record the generation is was found in. Just was hoping to be able to do this in one step. Thanks Bill -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Mike Schwab Sent: Thursday, December 20, 2012 9:59 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: SYNCSORT or ICEMAN How about testing with 1 GDG to 1 DSN, keeping the records. Once satisfied, do a change all and submit for the other 49 GDGs. When done, delete the empty datasets and utilize the remainder with records. On Thu, Dec 20, 2012 at 11:30 AM, George, William@FTB william.geo...@ftb.ca.gov wrote: Thanks. A small detail I, again forgot, is these are TAPE datasets. :( Otherwise this would be a nice method. Bill -- Mike A Schwab, Springfield IL USA Where do Forest Rangers go to get away from it all? -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN __ CONFIDENTIALITY NOTICE: This email from the State of California is for the sole use of the intended recipient and may contain confidential and privileged information. Any unauthorized review or use, including disclosure or distribution, is prohibited. If you are not the intended recipient, please contact the sender and destroy all copies of this email. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SYNCSORT or ICEMAN
Not bad. I like it. In my previous post I show I'm doing something somewhat similar by tacking on the indicator of the file it came from BUT... in 50 steps. With the below I probably could do it in one. Bill -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Massimo Biancucci Sent: Thursday, December 20, 2012 10:02 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: SYNCSORT or ICEMAN I hope I did fully understand your question. I think you could solve using different steps with quite similar include and outrec cards or something like the following (only for two files and you can extend for the needed using the correct disposition): //ST011 EXEC PGM=ICETOOL //TOOLMSG DD SYSOUT=* //DFSMSG DD SYSOUT=* //SI01 DD * A1234567890 B1234567890 C1234567890 D1234567890 /* //SI02 DD * A1234567890 B1234567890 C1234567890 D1234567890 /* //SO01 DD SYSOUT=* //SO02 DD SYSOUT=* //TOOLIN DD * COPY FROM(SI01) TO(SO01) USING(CTL1) COPY FROM(SI02) TO(SO02) USING(CTL2) /* //CTL1CNTL DD * INCLUDE COND=(1,1,CH,EQ,C'A') OUTREC FIELDS=(C'01',1,80) /* //CTL2CNTL DD * INCLUDE COND=(1,1,CH,EQ,C'A') OUTREC FIELDS=(C'02',1,80) /* If you meant something doing all the job automagically :D, then I don't know. Regards. Max Da: George, William@FTB william.geo...@ftb.ca.gov A: IBM-MAIN@LISTSERV.UA.EDU Inviato: Giovedì 20 Dicembre 2012 17:57 Oggetto: SYNCSORT or ICEMAN I have a need to check 50 datasets (50 gens of a GDG) and extract records that match my criteria. I also would like to know which dataset in the concatenation the record was extracted from by adding an indicator to the output record. Is this possible via Syncsort or ICEMAN? I've made a quick scan of the Syncsort guide but now will dig deeper but thought I'd throw this question out also to hopefully help expedite the answer. Thanks Bill __ CONFIDENTIALITY NOTICE: This email from the State of California is for the sole use of the intended recipient and may contain confidential and privileged information. Any unauthorized review or use, including disclosure or distribution, is prohibited. If you are not the intended recipient, please contact the sender and destroy all copies of this email. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SYNCSORT or ICEMAN
On Thu, 20 Dec 2012 08:57:16 -0800, George, William@FTB william.geo...@ftb.ca.gov wrote: I have a need to check 50 datasets (50 gens of a GDG) and extract records that match my criteria. I also would like to know which dataset in the concatenation the record was extracted from by adding an indicator to the output record. Is this possible via Syncsort or ICEMAN? I've made a quick scan of the Syncsort guide but now will dig deeper but thought I'd throw this question out also to hopefully help expedite the answer. Thanks Bill Look at using ISPF SRCHFOR (3.14) in batch-mode - a quick test demonstrated that the correct input dataset name is revealed, even with a concatenation, though in a separate message/line. Scott Barry SBBWorks, Inc. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN