Re: DFSORT - a quick way to compare two huge files

2018-07-06 Thread Sri h Kolusu
join will return 100,000 records. You can eliminate the dups before the match coding JNF1 and JNF2. So If you let us know the exact requirement then we can show you how to get the desired results. Thanks, Sri Hari Kolusu DFSORT Development IBM Corporation IBM Mainframe Discussion List wrote on 07

Re: DFSORT - a quick way to compare two huge files

2018-07-06 Thread Elardus Engelbrecht
Radoslaw, I forgot to ask these questions: Do you want a line by line comparision (same output as with ISPF compare)? Could you be kind to post a sample input and output? Also show how you want the differences to be handled. This is to enable IBM-MAIN members to select the best solution for

Re: DFSORT - a quick way to compare two huge files

2018-07-06 Thread Elardus Engelbrecht
Radoslaw Skorupka wrote: >We have two output files, rather huge ones (rather gigabytes than MB's) with >LRECL~1500, FB. >The goal is to compare them and find different records. >While I have some ideas how to do it (even ISPF Compare or ICETOOL) I don't >think it would effective. >Any clues? S

DFSORT - a quick way to compare two huge files

2018-07-06 Thread R.S.
We have two output files, rather huge ones (rather gigabytes than MB's) with LRECL~1500, FB. The goal is to compare them and find different records. While I have some ideas how to do it (even ISPF Compare or ICETOOL) I don't think it would effective. Any clues? -- Radoslaw Skorupka Lodz, Pola

Re: Syncsort to DFSort Migration

2018-05-17 Thread zos reader
Thanks all for your valuable response On Friday, May 18, 2018, Edward Gould wrote: > > On May 17, 2018, at 3:05 PM, Brian France wrote: > > > > On 05/17/2018 01:25 PM, Edward Gould wrote: > __snip-- > > > excellent and

Re: Syncsort to DFSort Migration

2018-05-17 Thread Edward Gould
> On May 17, 2018, at 3:05 PM, Brian France wrote: > > On 05/17/2018 01:25 PM, Edward Gould wrote: __snip-- > excellent and no one ever questioned me, after it was Hmmm… > And just how many stubbed toes have they had?

Re: Syncsort to DFSort Migration

2018-05-17 Thread Brian France
On 05/17/2018 01:25 PM, Edward Gould wrote: >> On May 17, 2018, at 11:21 AM, Sri h Kolusu wrote: >> >>>> in IBM sort you have to specify equals this seemed to be the hardest >> Edward, >> >> You can set EQUALS as default at the installation level for

Re: Syncsort to DFSort Migration

2018-05-17 Thread Edward Gould
> On May 17, 2018, at 11:21 AM, Sri h Kolusu wrote: > >>> in IBM sort you have to specify equals this seemed to be the hardest > > Edward, > > You can set EQUALS as default at the installation level for DFSORT. There > is a slight overhead with EQUALS option which

Re: Syncsort to DFSort Migration

2018-05-17 Thread Sri h Kolusu
>>in IBM sort you have to specify equals this seemed to be the hardest Edward, You can set EQUALS as default at the installation level for DFSORT. There is a slight overhead with EQUALS option which increases the time needed for comparison of records and for data transfer. DFSORT team pr

Re: Syncsort to DFSort Migration

2018-05-17 Thread Tom Conley
On 5/17/2018 1:19 AM, zos reader wrote: Hello All, We are planning to migrate Syncsort to IBM DFSort, May you share your thoughts on it, some might have done this on their shops, please share your experience Thanks, Samat Samat, Be sure to do your due diligence and run performance tests

Re: Syncsort to DFSort Migration

2018-05-17 Thread Edward Gould
> On May 17, 2018, at 12:20 AM, zos reader wrote: > > Hello All, > > We are planning to migrate Syncsort to IBM DFSort, May you share your > thoughts on it, some might have done this on their shops, please share your > experience > > Thanks, Samat > I have

Syncsort to DFSort Migration

2018-05-16 Thread zos reader
Hello All, We are planning to migrate Syncsort to IBM DFSort, May you share your thoughts on it, some might have done this on their shops, please share your experience Thanks, Samat -- For IBM-MAIN subscribe / signoff / archive

Re: DFSORT help

2018-05-07 Thread Massimo Biancucci
Sent: Tuesday, May 1, 2018 1:31 PM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: DFSORT help > > This might help. On the DFSORT web site there's a file that includes > examples for using ICETOOL to analyze DFHSM, DFSMSrmm and DCOLLECT. > > http://www-01.ibm.com/support/docview

Re: DFSORT help

2018-05-01 Thread Gadi Ben-Avi
Subject: Re: DFSORT help This might help. On the DFSORT web site there's a file that includes examples for using ICETOOL to analyze DFHSM, DFSMSrmm and DCOLLECT. http://www-01.ibm.com/support/docview.wss?rs=114&uid=isg3T797#ex Have a nice day, Dave Betten z/OS Performance Specialist

Re: DFSORT help

2018-05-01 Thread David Betten
This might help. On the DFSORT web site there's a file that includes examples for using ICETOOL to analyze DFHSM, DFSMSrmm and DCOLLECT. http://www-01.ibm.com/support/docview.wss?rs=114&uid=isg3T797#ex Have a nice day, Dave Betten z/OS Performance Specialist Cloud and Systems Pe

DFSORT help

2018-05-01 Thread Gadi Ben-Avi
I use the free version of Spam Reader to get rid of spam. The Professional version doesn't have this disclaimer in outgoing emails. Try Spam Reader for free now! Hi, I am new to DFSORT. I would like to create an OUTREC statement that will take the output from DCOLLCT type D records and gi

Re: DFSORT for HTTP logs - RECFM and BLKSiZE?

2018-01-17 Thread Peter Hunkeler
>I do believe that I should be able to point DFSORT at any file (Unix or not) >where performing the functions of DFSORT make sense, and not be required to >specify in JCL the physical attributes of LRECL, RECFM and most especially >BLKSIZE. These should all be derivable from

Re: DFSORT for HTTP logs - RECFM and BLKSiZE?

2018-01-16 Thread Edward Gould
> On Jan 16, 2018, at 3:48 PM, Gibney, Dave wrote: > > It may not be the case that it just works, but it should. > > No matter where the dataset was created, it must exist in a way that is > accessible on z/OS, or they wouldn't be trying to process it via DFSORT. >

Re: DFSORT for HTTP logs - RECFM and BLKSiZE?

2018-01-16 Thread Gibney, Dave
> -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] > On Behalf Of Paul Gilmartin > Sent: Tuesday, January 16, 2018 4:21 PM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: DFSORT for HTTP logs - RECFM and BLKSiZE? > > On T

Re: DFSORT for HTTP logs - RECFM and BLKSiZE?

2018-01-16 Thread Paul Gilmartin
On Tue, 16 Jan 2018 23:45:34 +, Gibney, Dave wrote: >I do believe that I should be able to point DFSORT at any file (Unix or not) >where performing the functions of DFSORT make sense, and not be required to >specify in JCL the physical attributes of LRECL, RECFM and most e

Re: DFSORT for HTTP logs - RECFM and BLKSiZE?

2018-01-16 Thread Tim Hare
These are on z/OS in Unix Systems Services, the logs for the IMWHTTPD web server. I tried without DCB but I believe some DCB must be supplied , as someone said the access method will deal with the Unix-to-record stuff. I thought my LRECL was 290, but things did not work until I increased it.

Re: DFSORT for HTTP logs - RECFM and BLKSiZE?

2018-01-16 Thread Gibney, Dave
I do believe that I should be able to point DFSORT at any file (Unix or not) where performing the functions of DFSORT make sense, and not be required to specify in JCL the physical attributes of LRECL, RECFM and most especially BLKSIZE. These should all be derivable from the physical dataset

Re: DFSORT for HTTP logs - RECFM and BLKSiZE?

2018-01-16 Thread Paul Gilmartin
On Tue, 16 Jan 2018 21:48:14 +, Gibney, Dave wrote: >It may not be the case that it just works, but it should. > >No matter where the dataset was created, it must exist in a way that is >accessible on z/OS, or they wouldn't be trying to process it via DFSORT. > &g

Re: DFSORT for HTTP logs - RECFM and BLKSiZE?

2018-01-16 Thread Gibney, Dave
It may not be the case that it just works, but it should. No matter where the dataset was created, it must exist in a way that is accessible on z/OS, or they wouldn't be trying to process it via DFSORT. And, by existing, all required attributes to successfully process it should be derivab

Re: DFSORT for HTTP logs - RECFM and BLKSiZE?

2018-01-16 Thread Sri h Kolusu
.UA.EDU Date: 01/16/2018 02:29 PM Subject: Re: DFSORT for HTTP logs - RECFM and BLKSiZE? Sent by:IBM Mainframe Discussion List On Tue, 16 Jan 2018 14:18:06 -0700, Sri h Kolusu wrote: >>>>None of these should need JCL specification to read an existing >dataset. >

Re: DFSORT for HTTP logs - RECFM and BLKSiZE?

2018-01-16 Thread Paul Gilmartin
On Tue, 16 Jan 2018 14:18:06 -0700, Sri h Kolusu wrote: None of these should need JCL specification to read an existing >dataset. > >Probably OP's input file is NOT created on z/OS. So he needs to supply the >DCB parameters to read the dataset. > Likewise if the data set is a UNIX file crea

Re: DFSORT for HTTP logs - RECFM and BLKSiZE?

2018-01-16 Thread Sri h Kolusu
>>>None of these should need JCL specification to read an existing dataset. Probably OP's input file is NOT created on z/OS. So he needs to supply the DCB parameters to read the dataset. Thanks, Kolusu DFSORT Development IBM Corporation From: "Gibney, Dave

Re: DFSORT for HTTP logs - RECFM and BLKSiZE?

2018-01-16 Thread Gibney, Dave
None of these should need JCL specification to read an existing dataset. > -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] > On Behalf Of Sri h Kolusu > Sent: Tuesday, January 16, 2018 8:36 AM > To: IBM-MAIN@LISTSERV.UA.EDU > S

Re: DFSORT for HTTP logs - RECFM and BLKSiZE?

2018-01-16 Thread Sri h Kolusu
Gil, OP mentioned his LRECL is 290, so with SDB the optimal blocksize is 27998 for an lrecl of 290 Thanks, Kolusu From: Paul Gilmartin <000433f07816-dmarc-requ...@listserv.ua.edu> To: IBM-MAIN@LISTSERV.UA.EDU Date: 01/16/2018 11:30 AM Subject: Re: DFSORT for HTT

Re: DFSORT for HTTP logs - RECFM and BLKSiZE?

2018-01-16 Thread Tim Hare
Maybe I had LRECL too small? LRECL=512,BLKSIZE=32760 worked -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: DFSORT for HTTP logs - RECFM and BLKSiZE?

2018-01-16 Thread Tim Hare
I tried this, and ended with S001-1 abend //SORTEXEC PGM=SORT //SYSOUT DD SYSOUT=* //SORTWK01 DD UNIT=DASD,SPACE=(CYL,(500,500)) //SORTIN DD PATHOPTS=ORDONLY,

Re: DFSORT for HTTP logs - RECFM and BLKSiZE?

2018-01-16 Thread Paul Gilmartin
On Tue, 16 Jan 2018 10:26:50 -0700, Sri h Kolusu wrote: > >If the RECFM is V then you can LRECL+4 as the blocksize , or you can even >code BLKSIZE=27998 > Likewise, you can use longest line + 4 (for RDW) as LRECL. But be generous: tomorrow's log may contain a longer line. Is there any reason no

Re: DFSORT for HTTP logs - RECFM and BLKSiZE?

2018-01-16 Thread Paul Gilmartin
IX files, code any RECFM, LRECL, and BLKSIZE acceptable to DFSORT. The access method will reformat to match those attributes (adding RDWs or padding with blanks), reporting an I/O error if any line exceeds LRECL. (If the data lack newline characters (unlikely for a UNIX log file), you may need t

Re: DFSORT for HTTP logs - RECFM and BLKSiZE?

2018-01-16 Thread Sri h Kolusu
Tim, If the RECFM is V then you can LRECL+4 as the blocksize , or you can even code BLKSIZE=27998 Thanks, Kolusu DFSORT Development IBM Corporation From: Tim Hare To: IBM-MAIN@LISTSERV.UA.EDU Date: 01/16/2018 10:09 AM Subject:Re: DFSORT for HTTP logs - RECFM and BLKSiZE

Re: DFSORT for HTTP logs - RECFM and BLKSiZE?

2018-01-16 Thread Tim Hare
it appears to be 'V' but I don't see where I could get BLKSIZE from -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: DFSORT for HTTP logs - RECFM and BLKSiZE?

2018-01-16 Thread Sri h Kolusu
Tim, You follow the same rules for JCL. Something like this //SORTIN DD PATH='your http log file', // RECFM=??,LRECL=290,BLKSIZE=?, //FILEDATA=TEXT,PATHOPTS=ORDONLY Thanks, Kolusu DFSORT Development IBM Corporation From: Tim Hare To:

Re: DFSORT for HTTP logs - RECFM and BLKSiZE?

2018-01-16 Thread Martin Packer
ksbF6Q8SQ4oOvA From: Tim Hare To: IBM-MAIN@LISTSERV.UA.EDU Date: 16/01/2018 16:09 Subject:DFSORT for HTTP logs - RECFM and BLKSiZE? Sent by:IBM Mainframe Discussion List I want to do some simple reporting on my HTTP logs (httpd-log.MMMdd). I'm coding PARSE= to

DFSORT for HTTP logs - RECFM and BLKSiZE?

2018-01-16 Thread Tim Hare
I want to do some simple reporting on my HTTP logs (httpd-log.MMMdd). I'm coding PARSE= to get the information I want, and I think I understand that part, but when I run my job SORT complains about RECFM, LRECL, or BLKSIZE. Viewing the logs, it looks like the record length is 290 (that's

Re: DFSORT: RACFICE query - how to extract all commands containing some text value

2017-12-15 Thread Bruce Hewson
*** //* create the consolidated report for an user based on the ** //* Event type using DFSORT. The username can be dynamically ** //* passed. Look at the SET statment up above for the username ** //* The following Event Types are reported

Re: DFSORT: RACFICE query - how to extract all commands containing some text value

2017-12-15 Thread Sri h Kolusu
Elardus, Thank you for your kind words Kolusu From: Elardus Engelbrecht To: IBM-MAIN@LISTSERV.UA.EDU Date: 12/15/2017 01:02 AM Subject:Re: DFSORT: RACFICE query - how to extract all commands containing some text value Sent by:IBM Mainframe Discussion List Sri h

Re: DFSORT: RACFICE query - how to extract all commands containing some text value

2017-12-15 Thread Elardus Engelbrecht
Sri h Kolusu wrote: >>>Elardus : Careful, Sri will SORT you out... ;-D >Nooo. I am not a RACF expert, So I have to agree with Robert. Hahaha, and I am not a SORT expert. ;-) >You can try the JCL that I sent offline and see if that works Amazing example. ONE pass with SS statement and various

Re: DFSORT: RACFICE query - how to extract all commands containing some text value

2017-12-14 Thread Sri h Kolusu
I have to agree with Robert. You can try the JCL that I sent offline and see if that works Thanks, Kolusu DFSORT Development IBM Corporation IBM Mainframe Discussion List wrote on 12/13/2017 10:53:45 PM: > From: Bruce Hewson > To: IBM-MAIN@LISTSERV.UA.EDU > Date: 12/13/2017 10:54

Re: DFSORT: RACFICE query - how to extract all commands containing some text value

2017-12-14 Thread Elardus Engelbrecht
,chars,CH) BTITLE('???') in ICETOOL statements. AFAIK, that is not possible with RACFRW. I am now wondering, can RACFRW report on RACDCERT commands and usage of Custom Fields for userids? >Our presentation on DFSORT and ICETOOL and its use with RACF might be of help. >Y

Re: DFSORT: RACFICE query - how to extract all commands containing some text value

2017-12-14 Thread Robert S. Hansel (RSH)
Kolusu, I would not recommend the use of RACFRW. It was stabilized in 1992 and won't report on the use of newer command operands such as NOEXPIRE. Bruce is better off using ICETOOL. Bruce, Our presentation on DFSORT and ICETOOL and its use with RACF might be of help. You'll find

Re: DFSORT: RACFICE query - how to extract all commands containing some text value

2017-12-13 Thread Martin Packer
This, I think, could use some Symbols love. Cheers, Martin Martin Packer > On 14 Dec 2017, at 05:54, Bruce Hewson wrote: > > Thanks all, especially to Kolusu & Elardus. > > My final JCL:- > > //*** > //EXTRACT EXEC PGM=ICETOOL >

Re: DFSORT: RACFICE query - how to extract all commands containing some text value

2017-12-13 Thread Bruce Hewson
Thanks all, especially to Kolusu & Elardus. My final JCL:- //*** //EXTRACT EXEC PGM=ICETOOL //IRRADU00 DD DISP=OLD,DSN=XYZZY.RACFICE.IRRADU00.ALL //EXTRACT DD DISP=OLD,DSN=X

Re: DFSORT: RACFICE query - how to extract all commands containing some text value

2017-12-13 Thread Sri h Kolusu
Bruce, You extract the SMF80 records and process it thru DFSORT. You can also use RACFRW to report https://www.ibm.com/support/knowledgecenter/en/SSLTBW_2.1.0/com.ibm.zos.v2r1.icha800/racfrw.htm Example : This file produces a report of failed logons for user Smith. RACFRW TITLE('R

Re: DFSORT: RACFICE query - how to extract all commands containing some text value

2017-12-13 Thread Lizette Koehler
Two suggestions The RACF List might be helpful with this question. To join, if you have not done so, use this URL RACFhttp://www.listserv.uga.edu/archives/racf-l.html Next, there is a DFSORT HOTLINE from IBM who can always help with DFSORT coding. Send an email to dfs...@us.ibm.com

Re: DFSORT: RACFICE query - how to extract all commands containing some text value

2017-12-13 Thread Ron hawkins
To: IBM-MAIN@LISTSERV.UA.EDU Subject: [IBM-MAIN] DFSORT: RACFICE query - how to extract all commands containing some text value A query for the ICETOOL/RACFICE experts, I have been asked to extract all RACF commands issued relating to a specific USERID. I am not knowledgable enough with ICETOOLS

Re: DFSORT: RACFICE query - how to extract all commands containing some text value

2017-12-13 Thread Martin Packer
I don't think he'll mind me mentioning it but Mark Nelson was the originator of RACFICE - but that was LONG ago. He might well have a view. And the advice to learn some DFSORT is good. Cheers, Martin Martin Packer zChampion, Systems Investigator & Performance Troubleshooter,

Re: DFSORT: RACFICE query - how to extract all commands containing some text value

2017-12-13 Thread Elardus Engelbrecht
Radoslaw Skorupka wrote: >Use SS. Of course I don't mean bad guys from WWII times, this is SubString. ;-) >You can filter (INCLUDE/OMIT) any record containing given string (userid) >wherever in the record or some field of the record. Yes, I forgot about that advanced helpful command SS! It is a

Re: DFSORT: RACFICE query - how to extract all commands containing some text value

2017-12-13 Thread R.S.
Use SS. Of course I don't mean bad guys from WWII times, this is SubString. ;-) You can filter (INCLUDE/OMIT) any record containing given string (userid) wherever in the record or some field of the record. -- Radoslaw Skorupka Lodz, Poland W dniu 2017-12-13 o 10:48, Bruce Hewson pisze:

Re: DFSORT: RACFICE query - how to extract all commands containing some text value

2017-12-13 Thread Elardus Engelbrecht
F-L. Perhaps someone from DFSORT support chimes in here. This is a two step thing. You first use RACF SMF Unload and then you use the ICETOOL job. This process is hungry hungry HUNGRY on disk space, because the compressed SMF records are expanded. Bit fields are expanded in a full 4 bytes per bi

DFSORT: RACFICE query - how to extract all commands containing some text value

2017-12-13 Thread Bruce Hewson
A query for the ICETOOL/RACFICE experts, I have been asked to extract all RACF commands issued relating to a specific USERID. I am not knowledgable enough with ICETOOLS to code this myself quickly. The current RACFICE examples do not provide a sample for this. example. Extract and report all

Re: DFSORT to deal with IMS Date/Time

2017-06-29 Thread Sri h Kolusu
Dirceu Bimonti Ivo, I sent you the JCL which meets your requirements along with time arithmetic and handle dates to subtract a day if the time - offset results in a negative number. Please let me know if you have any more questions. Thanks, Kolusu DFSORT Development IBM Corporation IBM

Re: DFSORT to deal with IMS Date/Time

2017-06-29 Thread Sri h Kolusu
Dirceu Bimonti Ivo, DFSORT can convert the SMF date and time formats and even perform time arithmetic. Is IMSLOG data similar to SMF data? Can you send me a sample input data may be 10 records (to my personal email id) which would save the recreation of input data. Also show a sample of

DFSORT to deal with IMS Date/Time

2017-06-29 Thread Dirceu Bimonti Ivo
Hi, Could use some inputs from DFSORT experts. I have this job to sort IMS Log Records using an specific criteria, does what it should, I just can't get the date/time to display correctly. This is an example of what it looks

Re: DFSORT Error message

2017-06-02 Thread Ron Thomas
Ok both the statements are working , as i have put the continuation character wrongly . Regards Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: IN

Re: DFSORT Error message

2017-06-02 Thread Elardus Engelbrecht
Sri h Kolusu wrote: >Not really. DFSORT does NOT care about the sequence of the keywords. You can >have them in any order. That is good, I was just reading those 'train tracks' schematics and a$$umed the keyword sequence could be a problem. Many thanks. Groete / G

Re: DFSORT Error message

2017-06-02 Thread Sri h Kolusu
>>After RTFM, I see you have the sequence incorrect. Elardus, Not really. DFSORT does NOT care about the sequence of the keywords. You can have them in any order. OP's original statement is just missing a continuation character which Dave betten( thanks Dave) pointed out. By

Re: DFSORT Error message

2017-06-02 Thread Ron Thomas
Thanks a lot . it worked ! Regards Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: DFSORT Error message

2017-06-02 Thread Elardus Engelbrecht
Ron Thomas wrote: After RTFM, I see you have the sequence incorrect. Change > SELECT FROM(SORTIN) TO(SORTF1) ON(16,50,CH) DISCARD(SORTF2) FIRST > USING(CTL1) to SELECT FROM(SORTIN) TO(SORTF1) DISCARD(SORTF2) ON(16,50,CH) FIRST - USING(CTL1) Let us know if this works or not? Groete / Gre

Re: DFSORT Error message

2017-06-02 Thread Elardus Engelbrecht
Ron Thomas wrote: >I have given as below, but still the issue is there >SELECT FROM(SORTIN) TO(SORTF1) ON(16,50,CH) DISCARD(SORTF2) FIRST - >USING(CTL1) Please post the message(s). What version of DFSORT and z/OS are you using? I think your statement is now finally correct, but I am

Re: DFSORT Error message

2017-06-02 Thread Ron Thomas
I have given as below, but still the issue is there SELECT FROM(SORTIN) TO(SORTF1) ON(16,50,CH) DISCARD(SORTF2) FIRST - USING(CTL1) Thanks, Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to

Re: DFSORT Error message

2017-06-02 Thread David Betten
Betten z/OS Performance Specialist Cloud and Systems Performance IBM Corporation email: bet...@us.ibm.com IBM Mainframe Discussion List wrote on 06/02/2017 08:17:31 AM: > From: Ron Thomas > To: IBM-MAIN@LISTSERV.UA.EDU > Date: 06/02/2017 08:19 AM > Subject: DFSORT Error message &g

DFSORT Error message

2017-06-02 Thread Ron Thomas
Hello . I am trying to extract unique invoice numbers to a file using DFSORT ,ICETOOL and below is my control card.n The o/p i want to reformat it. I am getting the below error messages. could someone let me know where the issue is ? //TOOLINDD * SELECT FROM(SORTIN) TO(SORTF1) ON(16,50

Re: DFSORT with empty outputs

2017-06-01 Thread Sri h Kolusu
>>All of this with ONE single pass to read the input datasets (which are very very large sometimes). Elardus, I just moved your existing SORT operator as a separate step to check for empty input. It is the same job you had. Thanks, Kolusu DFSORT Development IBM Corporation IBM Mai

Re: DFSORT with empty outputs

2017-06-01 Thread Elardus Engelbrecht
Sri h Kolusu wrote: >Here is a JCL which will give you the desired results. I rearrange your >INCLUDE conditions in the order of positions and it is easy to read and >Understand. Many thanks for your kind help. After looking at your job, I see that the output datasets are primed first with '

Re: DFSORT with empty outputs

2017-05-31 Thread Sri h Kolusu
EADER('USER NAME')- ON(100,8,CH) HEADER('DFLT GROUP') - ON(19,10,CH) HEADER('CREATED') - ON(118,10,CH) HEADER('LAST USED') OCCUR FROM(INDD) LIST(PRINT3T) - NOCC - WIDTH(500)

Re: DFSORT TRAN=UTOL and codepages

2017-05-31 Thread Sri h Kolusu
urrent design only allows you to specify each character and it's converted value. You can use FINDREP or ALTSEQ to do that. Thanks, Kolusu DFSORT Development IBM Corporation IBM Mainframe Discussion List wrote on 05/31/2017 06:37:32 AM: > From: "R.S." > To: IBM-MAIN@LISTSER

Re: DFSORT TRAN=UTOL and codepages

2017-05-31 Thread Elardus Engelbrecht
Paul Gilmartin wrote: >>Is this the right translation for Radoslaw? If so, he would be glad. >On Linux, not on z/OS. Ok. Thanks. >>Or you can easily use REXX function TRANSLATE to do the same [1] , but if the >>input is large, then you may have some long overhead. >Does that work for MBCS? Hm

Re: DFSORT TRAN=UTOL and codepages

2017-05-31 Thread Paul Gilmartin
On Wed, 31 May 2017 09:46:35 -0500, Elardus Engelbrecht wrote: > >>Is it possible to provide codepage information to UTOL or I have to use >>something like >>FINDREP=(INOUT=(C'a',C'A' for every character? > >>With vim on Linux, I tried: (ąćęłńóśżź). >>... then the command: >> >>...

Re: DFSORT TRAN=UTOL and codepages

2017-05-31 Thread Elardus Engelbrecht
slation for Radoslaw? If so, he would be glad. Or you can easily use REXX function TRANSLATE to do the same [1] , but if the input is large, then you may have some long overhead. >BTW, why is the collating sequence for En_US just plain wrong? En_US is not wrong, but Radoslaw needs to use h

Re: DFSORT TRAN=UTOL and codepages

2017-05-31 Thread Paul Gilmartin
On Wed, 31 May 2017 15:37:32 +0200, R.S. wrote: >I use >OUTREC BUILD=(1,80,TRAN=UTOL) >to change uppercase to lowercase characters. >However it does not change the case for polish national characters >(ąćęłńóśżź). I tried to use LOCALE=PL_pl, but with no effect. > >Is it possible to provide codep

DFSORT TRAN=UTOL and codepages

2017-05-31 Thread R.S.
I use OUTREC BUILD=(1,80,TRAN=UTOL) to change uppercase to lowercase characters. However it does not change the case for polish national characters (ąćęłńóśżź). I tried to use LOCALE=PL_pl, but with no effect. Is it possible to provide codepage information to UTOL or I have to use something l

Re: DFSORT with empty outputs

2017-05-31 Thread Elardus Engelbrecht
Sri h Kolusu wrote: >>>Is there a DFSORT or ICETOOL statement where the output contains headers >>>plus a line saying 'No selected records found' if nothing selected is found? >It can be done , however I need a few more details. First thing first, many thanks f

Re: DFSORT with empty outputs

2017-05-30 Thread Sri h Kolusu
>>Is there a DFSORT or ICETOOL statement where the output contains headers plus a line saying 'No selected records found' if nothing selected is found? Elardus, It can be done , however I need a few more details. 1. How are you selecting the data? (using INCLUDE/OMIT COND or

DFSORT with empty outputs

2017-05-30 Thread Elardus Engelbrecht
Good day to all DFSORT gurus Is there a DFSORT or ICETOOL statement where the output contains headers plus a line saying 'No selected records found' if nothing selected is found? Something like this: User id User Name Dflt Group Created

Re: DFSORT Sample JCL

2017-05-08 Thread Sri h Kolusu
>>>I have SMF type 16, would like to see who is using DFSORT Salah Balboul, You mean the Jobnames ? Here is a sample JCL which will extract the jobname, date and times. //STEP0100 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //SORTIN DD DISP=SHR,DSN=Your.SMF.File //SORTOUT DD SYSOUT=

Re: DFSORT Sample JCL

2017-05-08 Thread Lizette Koehler
An easy Internet search DFSORT SMF JCL Will get you this link (watch the wrap) https://www.ibm.com/support/knowledgecenter/SSLTBW_2.2.0/com.ibm.zos.v2r2.icha800/icetool.htm ICETOOL comes with DFSORT and can do what you want. You did not say how you wanted the output presented. So just

DFSORT Sample JCL

2017-05-08 Thread Salah Balboul
Hi list, I have SMF type 16, would like to see who is using DFSORT Wondering if anyone has a sample JCL to extract these records and generate a report. Thx -- For IBM-MAIN subscribe / signoff / archive access instructions

Re: How can I set Non-zero return code in DFSORT when SORTOUT record count is not zero

2017-04-18 Thread Charles Mills
> Does DFSORT in some cases compile its key definitions into executable code? Sorts have "compiled" their key compares into executable code for as long as I can recall. Charles -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Be

Programming langage? (was: ... DFSORT ...)

2017-04-17 Thread Paul Gilmartin
On Mon, 17 Apr 2017 17:53:40 +0900, Minoru Massaki wrote: > >A customer wants to tell auto job scheduling/auto operation system to take >another/additional action by Non-Zero return code if generated record is >non-rezo. >Why we want to use DFSORT instead of small REXX program is fo

Re: How can I set Non-zero return code in DFSORT when SORTOUT record count is not zero

2017-04-17 Thread Paul Gilmartin
On Mon, 17 Apr 2017 17:53:40 +0900, Minoru Massaki wrote: > >A customer wants to tell auto job scheduling/auto operation system to take >another/additional action by Non-Zero return code if generated record is >non-rezo. >Why we want to use DFSORT instead of small REXX program is fo

Re: How can I set Non-zero return code in DFSORT when SORTOUT record count is not zero

2017-04-17 Thread Minoru Massaki
Kolusu-san, Thank you very much for telling me to use COUNT operator of ICETOOL. It is what I'm looking for. A customer wants to tell auto job scheduling/auto operation system to take another/additional action by Non-Zero return code if generated record is non-rezo. Why we want to use D

Re: How can I set Non-zero return code in DFSORT when SORTOUT record count is not zero

2017-04-16 Thread Dale R. Smith
On Sat, 15 Apr 2017 12:35:58 -0700, Sri h Kolusu wrote: Hmm, Sri, did we forget about the NULLOUT Parm/OPTION? :-)> > >Dale, > >NULLOUT is used to set a return code when there are NO records. OP wanted >the opposite. He wants to set a return code when he has at least 1 record, >so that it

Re: AW: Re: How can I set Non-zero return code in DFSORT when SORTOUT record count is not zero

2017-04-16 Thread Paul Gilmartin
On Sun, 16 Apr 2017 09:14:01 +0200, Peter Hunkeler wrote: > > >While I made this up, I have a hard time to imagine it did not happen that >way. How else would can explain the weird logic behind COND= ? > Assembler mentality. It's the CC mask for a BC to branch around the next step. >But then IB

Re: AW: Re: How can I set Non-zero return code in DFSORT when SORTOUT record count is not zero

2017-04-16 Thread Chris Hoelscher
Sounds like a CONd job to me -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Peter Hunkeler Sent: Sunday, April 16, 2017 3:14 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: [IBM-MAIN] AW: Re: How can I set Non-zero return code in DFSORT

AW: Re: How can I set Non-zero return code in DFSORT when SORTOUT record count is not zero

2017-04-16 Thread Peter Hunkeler
> Why not just invert the COND= for the additional processing step? > Instead of COND=(0,EQ,DFSORT), code COND=(0,NE,DFSORT)? Back in the days when the need JCL was designed, people recognized the need for conditional execution of a job step. However, it was already late in the aft

Re: How can I set Non-zero return code in DFSORT when SORTOUT record count is not zero

2017-04-15 Thread Sri h Kolusu
>>>In this case an ideal search would be "NOTEMPTY" or "EMPTY" and "how do I". My apologies. I was missing a NOT in the statement. Please read it as In this case an ideal search would be "NOTEMPTY" or "EMPTY" and NOT "how do I

Re: How can I set Non-zero return code in DFSORT when SORTOUT record count is not zero

2017-04-15 Thread Sri h Kolusu
>>I am guessing the OP framed the original question as "how do I set a specific RC" and that is the sort of thing he searched for. Charles, "How do I" questions cannot be answered in application programming guide. We have Smart DFSORT tricks page which shows you clev

Re: How can I set Non-zero return code in DFSORT when SORTOUT record count is not zero

2017-04-15 Thread Paul Gilmartin
nal question as "how do I set a >specific RC" and that is the sort of thing he searched for. > >I just went to KC -- isn't that how we are supposed to be doing things these >days? :-( -- and searched on DFSORT plus the subject of this thread. I did >not get any hits t

Re: How can I set Non-zero return code in DFSORT when SORTOUT record count is not zero

2017-04-15 Thread Charles Mills
f thing he searched for. I just went to KC -- isn't that how we are supposed to be doing things these days? :-( -- and searched on DFSORT plus the subject of this thread. I did not get any hits that seemed immediately relevant, but drilling down on PARM= I found NULLOUT, which at least sho

Re: How can I set Non-zero return code in DFSORT when SORTOUT record count is not zero

2017-04-15 Thread Sri h Kolusu
ght I respectfully suggest that your documentation could use some work, if neither the OP nor the diligent @Lizette could find the answer to this simple question? Charles, I am not sure what keywords/Phrase was used for search, but a simple search for NOTEMPTY in DFSORT Application programmin

Re: How can I set Non-zero return code in DFSORT when SORTOUT record count is not zero

2017-04-15 Thread Charles Mills
I stand by my statement that it would be easy to write Rexx to do this. I don't pretend to be a DFSORT expert. If DFSORT has this as a native capability too, that's terrific. Might I respectfully suggest that your documentation could use some work, if neither the OP nor the diligen

Re: How can I set Non-zero return code in DFSORT when SORTOUT record count is not zero

2017-04-15 Thread Dale R. Smith
GHER(0) RC4 >//* Hmm, Sri, did we forget about the NULLOUT Parm/OPTION? :-)> NULLOUT= RC0 RC4 RC16 Temporarily overrides the NULLOUT installation option, which specifies the action to be taken by DFSORT when there are no records for the SORTOUT data set,

Re: How can I set Non-zero return code in DFSORT when SORTOUT record count is not zero

2017-04-15 Thread Sri h Kolusu
/en/SSLTBW_2.1.0/com.ibm.zos.v2r1.icea100/ice2ca_COUNT_operator.htm >>I would say, no, you cannot have DFSORT do something like this. I am not seeing anything the DFSORT manuals from IBM to allow the user to force DFSORT to set codes other than it is already doing. Lizette, Sorry to sa

Re: How can I set Non-zero return code in DFSORT when SORTOUT record count is not zero

2017-04-15 Thread Charles Mills
return code in DFSORT when SORTOUT record count is not zero I would say, no, you cannot have DFSORT do something like this.  I am not seeing anything the DFSORT manuals from IBM to allow the user to force DFSORT to set codes other than it is already doing. Better to wrap you process with

Re: How can I set Non-zero return code in DFSORT when SORTOUT record count is not zero

2017-04-15 Thread Lizette Koehler
I would say, no, you cannot have DFSORT do something like this. I am not seeing anything the DFSORT manuals from IBM to allow the user to force DFSORT to set codes other than it is already doing. Better to wrap you process with something that can set the RC you want. I sometimes pass output

Re: How can I set Non-zero return code in DFSORT when SORTOUT record count is not zero

2017-04-15 Thread Minoru Massaki
UA.EDU] On > > Behalf Of Lizette Koehler > > Sent: Saturday, April 15, 2017 8:09 AM > > To: IBM-MAIN@LISTSERV.UA.EDU > > Subject: Re: How can I set Non-zero return code in DFSORT when SORTOUT > record > > count is not zero > > > > What problem are you tryin

<    4   5   6   7   8   9   10   11   12   13   >