Re: DFSORT job to convert FBM to FBA

2021-12-06 Thread Steve Smith
Well, as most machine-CC operates after the line is printed, and ASA-CC operates before, I'd think it would be more complicated than that. sas On Mon, Dec 6, 2021 at 2:58 PM Sri h Kolusu wrote: > > DFSORT job to convert FBM to FBA? -- > > Michael, > > Try this. > >

Re: DFSORT job to convert FBM to FBA

2021-12-06 Thread Sri h Kolusu
> DFSORT job to convert FBM to FBA? -- Michael, Try this. /STEP0100 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //SORTIN DD DISP=SHR,DSN=your.FBM.file //SORTOUT DD DSN=Your.FBA.File, //DISP=(NEW,CATLG,DELETE), //SPACE=(CYL,(X,Y),RLSE) //SYSINDD * OPTION COPY IN

DFSORT job to convert FBM to FBA

2021-12-06 Thread Michael Babcock
I don’t want to reinvent the wheel so I’m asking this list. Anyone have a DFSORT job to convert FBM to FBA? -- Michael Babcock OneMain Financial z/OS Systems Programmer, Lead -- For IBM-MAIN subscribe / signoff / archive

Re: DFSORT- SORT OUT FILE Sequence is not in order

2021-11-11 Thread Sri h Kolusu
he duplicates, he needs another pass on the data, to put the data back in the original order. Thanks, Kolusu DFSORT Development IBM Corporation -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to l

Re: DFSORT- SORT OUT FILE Sequence is not in order

2021-11-11 Thread Hobart Spitz
Really How is your solution a single instruction? Here are single instruction solutions. "pipe < ddname=sortin | sort unique | > ddname=sortout" or "pipe < your.data | sort unique | > your.output or // EXEC PGM=PIPE,PARM='< your.data | sort unique | > your.output' People really need to

Re: DFSORT- SORT OUT FILE Sequence is not in order

2021-11-11 Thread Ron Thomas
Thanks a lot Massimo. It worked like a charm :) Thanks, 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- SORT OUT FILE Sequence is not in order

2021-11-11 Thread Massimo Biancucci
Ron, if I well understood, the task was to remove duplicate records maintaning the initial order. Maybe it could be done with a single instruction, anyway the following should work: //ST010EXEC PGM=ICETOOL //TOOLMSG DD SYSOUT=* //DFSMSG DD SYSOUT=* //TEMP DD

DFSORT- SORT OUT FILE Sequence is not in order

2021-11-11 Thread Ron Thomas
Hi - We have a Input file of LRECL =80 as below 105_1_10893_1_28 1_10893_1_28 FAMILY SHARE CRISPS 1_10893_1_28 10893_1_28 SHARING CRISPS 10893_1_28 1_28 SHARING CRISPS 1_28 28

Re: DFSORT and "IF exist"

2021-09-09 Thread Sri h Kolusu
torage than a regular DFSORT application. You may need to use REGION=0M for some JOINKEYS applications. https://www.ibm.com/docs/en/zos/2.4.0?topic=files-joinkeys-application-notes > Now it's time for learning - while I can use some statements I do not > necessarily know what can I

Re: DFSORT and "IF exist"

2021-09-09 Thread Radoslaw Skorupka
-joinkeys-application-examples Thanks, Kolusu DFSORT Development IBM Corporation -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: DFSORT and "IF exist"

2021-09-07 Thread Sri h Kolusu
here https://www.ibm.com/docs/en/zos/2.4.0?topic=files-joinkeys-application-examples Thanks, Kolusu DFSORT Development IBM Corporation -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@lis

Re: DFSORT and "IF exist"

2021-09-07 Thread Radoslaw Skorupka
to compare two records using JOINKEYS feature of DFSORT. Here is a JCL which will give you the desired results. //STEP0100 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //INA DD DISP=SHR,DSN=Your Input VB file //INB DD DISP=SHR,DSN=Your Same Input VB file //SORTOUT DD SYSOUT=* //SYSINDD

Re: DFSORT and "IF exist"

2021-09-07 Thread Sri h Kolusu
> The goal is to get list of NAMEs from ABC record, but only if exist SUM > record with same NAME value. Radoslaw, It is quite simple to compare two records using JOINKEYS feature of DFSORT. Here is a JCL which will give you the desired results. //STEP0100 EXEC PGM=SORT //SYSOUT DD

Re: DFSORT and "IF exist"

2021-09-07 Thread Radoslaw Skorupka
 01:15, Bernd Oppolzer pisze: Thanks, this looks very good; the header on page 14 describes exactly what I had in mind: Join fields from two files on a key In this section, we show some tricks for joining fields from two files in different ways using the JOINKEYS function of DFSORT Radoslaw

Re: DFSORT and "IF exist"

2021-09-06 Thread Bernd Oppolzer
Thanks, this looks very good; the header on page 14 describes exactly what I had in mind: Join fields from two files on a key In this section, we show some tricks for joining fields from two files in different ways using the JOINKEYS function of DFSORT Radoslaw will sure be able to do

Re: DFSORT and "IF exist"

2021-09-06 Thread Joe Monk
I would suggest using DFSORT with JOINKEYS. See the example on page 15 here: https://www.ibm.com/support/pages/system/files/inline-files/$FILE/sorttrck.pdf Joe On Mon, Sep 6, 2021 at 4:24 PM Bernd Oppolzer wrote: > Hi Radoslaw, > > I am not a DFSORT wizard, but: > >

Re: DFSORT and "IF exist"

2021-09-06 Thread Bernd Oppolzer
Hi Radoslaw, I am not a DFSORT wizard, but: this is similar to a INNER JOIN SQL query; if I had a DB2 system at hand, I would load the SUM and ABC records into two different DB2 tables and do a SELECT statement involving an inner join, this would give the desired result. Maybe the same can

DFSORT and "IF exist"

2021-09-06 Thread Radoslaw Skorupka
I have the following task to do: PS file, VB records, different types. Two types are in scope of interest: SUMeeeNAME123456eee... ABCeNAME123456e SUM and ABC are record identifiers. NAME123456 is 10-char field I need to analyze e is irrelevant content. The

Re: DCOLLECT & DFSORT

2021-08-03 Thread Leon Trafalski
, as I always use symbol files, and ICETOOL DISPLAY for this sort of thing. sas On Tue, Aug 3, 2021 at 8:27 AM Jack Zukt wrote: Hello All, I am trying to build a report of inactive datasets using DCOLLECT for input and DFSORT to create the files for each last year referenced. For the output

Re: DCOLLECT & DFSORT

2021-08-03 Thread Jack Zukt
kt wrote: > >> > >> Hello All, > >> I am trying to build a report of inactive datasets using DCOLLECT for > input > >> and DFSORT to create the files for each last year referenced. > >> For the output files I only want the dataset name; last used

Re: DCOLLECT & DFSORT

2021-08-03 Thread Cameron Conacher
> sas > >> On Tue, Aug 3, 2021 at 8:27 AM Jack Zukt wrote: >> >> Hello All, >> I am trying to build a report of inactive datasets using DCOLLECT for input >> and DFSORT to create the files for each last year referenced. >> For the output files I only wan

Re: DCOLLECT & DFSORT

2021-08-03 Thread Sri h Kolusu
On the DCOLLECT > input records the date is in the 'dddF' format and the space fields are > 4 byte long signed. I am pretty sure that there is a way to tell DFSORT to > make that translation but I am having no luck with the manual. > Any suggestions? Jack, That is a standar

Re: DCOLLECT & DFSORT

2021-08-03 Thread Steve Smith
build a report of inactive datasets using DCOLLECT for input > and DFSORT to create the files for each last year referenced. > For the output files I only want the dataset name; last used date; > allocated space; used space; storage group name. Now for the tricky part: I > want the dat

DCOLLECT & DFSORT

2021-08-03 Thread Jack Zukt
Hello All, I am trying to build a report of inactive datasets using DCOLLECT for input and DFSORT to create the files for each last year referenced. For the output files I only want the dataset name; last used date; allocated space; used space; storage group name. Now for the tricky part: I want

Re: DFSORT - AND/OR mystery

2021-07-31 Thread Bernd Oppolzer
AND is first. However parenthesis should change it and it is allow to use as many parenthesis as needed. 2. DFSORT should recognize the law (Rozdzielność działań in Polish) 3. I found another mystery, which seems to be APARable: The following statement gives several test records as expected

Re: DFSORT - AND/OR mystery

2021-07-31 Thread Radoslaw Skorupka
W dniu 30.07.2021 o 19:35, Sri h Kolusu pisze: 3. I found another mystery, which seems to be APARable: But this statement gives zero records. Note, I added "OR" conditions, so it cannot narrow the output. Radoslaw, I would respectfully disagree with that statement. I explained the quirks

Re: DFSORT - AND/OR mystery

2021-07-30 Thread Sri h Kolusu
ord lengths have on the comparison tests. Use the control cards that I showed and if you are still NOT getting the right results, then please open a case with IBM support. IMHO you wouldn't need that, but just in case ! Thanks, Kolusu DFSORT Development

Re: DFSORT - AND/OR mystery

2021-07-30 Thread Sri h Kolusu
https://www.ibm.com/docs/en/zos/2.3.0?topic=statement-relational-condition > Are you just rewriting Radoslaw's expression according to the Distributive Law? > Does DFSORTT not recognize the Distributive Law? There is NO need to code the statements the way that Mike has coded as DFSORT recong

Re: DFSORT - AND/OR mystery

2021-07-30 Thread Radoslaw Skorupka
rewriting Radoslaw's expression according to the Distributive Law? Does DFSORTT not recognize the Distributive Law? 1. Operator precedence. According to documentation AND is first. However parenthesis should change it and it is allow to use as many parenthesis as needed. 2. DFSORT should

Re: DFSORT - AND/OR mystery

2021-07-30 Thread Sri h Kolusu
OKE (05,4,CH,EQ,C'0102',AND,$ GPMEM_RECORD_TYPE 28,3,CH,NE,C'USE'))$ GPMEM_AUTH /* This should give produce the right results Ideally I would have used DFSORT symbols for all the fields and that way it is easy to follow. Something like this //SYMNOUT

Re: DFSORT - AND/OR mystery

2021-07-30 Thread Radoslaw Skorupka
. DFSORT should recognize the law (Rozdzielność działań in Polish) 3. I found another mystery, which seems to be APARable: The following statement gives several test records as expected: INCLUDE COND=(5,4,CH,EQ,C'0205',AND,(83,3,CH,EQ,C'YES',OR, 88,3,CH,EQ

Re: DFSORT - AND/OR mystery

2021-07-30 Thread Paul Gilmartin
On Fri, 30 Jul 2021 09:54:51 -0500, Mike Schwab wrote: >Try 5 pairs of conditions? >INCLUDE COND=((5,4,CH,EQ,C'0205',AND,83,3,CH,EQ,C'YES'), > OR,(5,4,CH,EQ,C'0205',AND,88,3,CH,EQ,C'YES'), > OR,(5,4,CH,EQ,C'0205',AND,93,3,CH,EQ,C'YES'), >

Re: DFSORT - AND/OR mystery

2021-07-30 Thread Mike Schwab
Try 5 pairs of conditions? INCLUDE COND=((5,4,CH,EQ,C'0205',AND,83,3,CH,EQ,C'YES'), OR,(5,4,CH,EQ,C'0205',AND,88,3,CH,EQ,C'YES'), OR,(5,4,CH,EQ,C'0205',AND,93,3,CH,EQ,C'YES'), OR,(5,4,CH,EQ,C'0205',AND,98,3,CH,EQ,C'YES'),

Re: DFSORT - compare two fields

2021-07-30 Thread Radoslaw Skorupka
ype 0203 - this is about user to group connection. There are fields: groupname and owner. Usually the owner is also the group. I want to list all the record where owner is not groupname. So the goal is to compare two (fixed) fields and include/omit records. Of course it can be done in REXX, but I think DFSORT

DFSORT - AND/OR mystery

2021-07-30 Thread Radoslaw Skorupka
The following statement is syntactically correct: INCLUDE COND=((5,4,CH,EQ,C'0205',AND,(83,3,CH,EQ,C'YES',OR,   88,3,CH,EQ,C'YES',OR,   93,3,CH,EQ,C'YES',OR,   98,3,CH,EQ,C'YES')),    

Re: DFSORT - compare two fields

2021-07-30 Thread S.Karthik Premnath
; I want to list all the record where owner is not groupname. > > So the goal is to compare two (fixed) fields and include/omit records. > Of course it can be done in REXX, but I think DFSORT is more efficient. > Any clue? > >

DFSORT - compare two fields

2021-07-30 Thread Radoslaw Skorupka
records. Of course it can be done in REXX, but I think DFSORT is more efficient. Any clue? -- Radoslaw Skorupka Lodz, Poland -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu

Re: DFSORT and SMF date selection

2021-06-15 Thread Martin Packer
Also DFSORT gives you more record selection flexibility than IFASMFDP / IFASMFDL. Cheers, Martin Martin Packer WW z/OS Performance, Capacity and Architecture, IBM Technology Sales +44-7802-245-584 email: martin_pac...@uk.ibm.com Twitter / Facebook IDs: MartinPacker Blog: https

Re: DFSORT and SMF date selection

2021-06-14 Thread Tim Hare
Thank you, I think this is a better solution for me right now. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: DFSORT and SMF date selection

2021-06-14 Thread Tim Hare
I am not using IFASMFDP I am doing other things in the DFSORT application. I'm trying not to do all of the I/O to select the records with IFASMFDP, then read the selected records a second time into DFSORT to process them

Re: DFSORT and SMF date selection

2021-06-14 Thread Sri h Kolusu
y time he wants to run the job. With DFSORT you don't have to do it as it can automatically perform the Date Arithmetic. Thanks, Kolusu DFSORT Development IBM Corporation -- For IBM-MAIN subscribe / signoff / archive access instru

Re: DFSORT and SMF date selection

2021-06-14 Thread Michael Oujesky
Why not just use IFASMFDP? Michael At 02:32 PM 6/14/2021, Tim Hare wrote: The brain is just not working today I guess. I want to use DFSORT to select some SMF records for a week; I'm getting myself confused in the DFSORT application programming guide Do I want to use INCLUDE COND=(11,4

Re: DFSORT and SMF date selection

2021-06-14 Thread Sri h Kolusu
>>since I am not interested in dates in the 20th century, could I use COND=(12,3,Y2U,GE,) ? Tim, If you are input data is always going to 20th century then you use Y2U format in the form Y'string' . Something like this INCLUDE COND=(12,3,Y2U,GE,Y'DATE3'-7) Thanks, Kolusu DFSORT Devel

Re: DFSORT and SMF date selection

2021-06-14 Thread Tim Hare
Thanks for the solution. I am wondering, though: since I am not interested in dates in the 20th century, could I use COND=(12,3,Y2U,GE,) ? The rightmost 3 bytes of the SMF date would seem to satisfy Y2U and as long as my offset of -7 doesn't take me to a previous century I should be OK,

Re: DFSORT and SMF date selection

2021-06-14 Thread Sri h Kolusu
value of PICKDATE Further if you have any questions please let me know Thanks, Kolusu DFSORT Development IBM Corporation -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu

DFSORT and SMF date selection

2021-06-14 Thread Tim Hare
The brain is just not working today I guess. I want to use DFSORT to select some SMF records for a week; I'm getting myself confused in the DFSORT application programming guide Do I want to use INCLUDE COND=(11,4,PD,GE,) or INCLUDE COND=(11,4,Y4U,GE,) or have I missed something

Re: SORTWK allocations for DFSORT vs Syncsort

2021-04-01 Thread Sri h Kolusu
Robert, DFSORT has the ability of recovering from B37 abends. Please send the complete joblog to my id and it will be helpful to diagnose the problem. Thanks, Kolusu DFSORT Development IBM Corporation IBM Mainframe Discussion List wrote on 04/01/2021 01:49:29 PM: > From: Robert Ha

SORTWK allocations for DFSORT vs Syncsort

2021-04-01 Thread Robert Hahne
Greetings , I recently noticed the way syncsort handles dynamic allocation for SORTWK datasets and they appear to be avoiding B37 abends better than DFSORT and I am assuming thats because syncsort allocates SORTWK datasets on "as needed" basis where as DFSORT tries to allocate a

Re: DFSORT and SAS

2021-01-25 Thread Gibney, Dave
5, 2021 2:45 PM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: DFSORT and SAS > > It appears that you are managing the //TREND PDB as a SAS sequential- > format (indicated with RECFM=U, and as you mention with prior TMM- > deployment - also getting zEDC benefit, hopefully

Re: DFSORT and SAS

2021-01-25 Thread Scott Barry
I understand this, it is just a sort or merge of the newly updated TREND >with the previous week into a new generation. >I don't know why SAS is not informing DFSORT of the data volume. It should >know the new record count precisely. And should be able to see the raw size of >t

Re: DFSORT and SAS

2021-01-25 Thread Sri h Kolusu
> But, all datasets are on disk. Dave, If the files are on DISK , DFSORT should be able to get the stats. Can you please send me the COMPLETE joblog to my email offline? I want to check allocation messages for the ddname SASSIN. > My Tape management is CA-7 I guess you meant CA-

Re: DFSORT and SAS

2021-01-25 Thread Gibney, Dave
of the newly updated TREND with the previous week into a new generation. I don't know why SAS is not informing DFSORT of the data volume. It should know the new record count precisely. And should be able to see the raw size of the previous generation.. The main dataset is a SAS dataset: Data Set Name

Re: DFSORT and SAS

2021-01-25 Thread Sri h Kolusu
CE118I message (4th line in the Sortdiag file) Thanks, Kolusu DFSORT Development IBM Corporation -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: DFSORT and SAS

2021-01-25 Thread Gibney, Dave
I let this week's run fail and have attached the results with //SORTDIAG DD DUMMY and a SAS PROC OPTIONS; I am not sure I'll open an issue with SAS. My site is working towards shutting down later this year or so, and I have a working solution with the DFSORT option on this job. This job

Re: DFSORT and SAS

2021-01-19 Thread Scott Barry
see evidence in SORT diagnostic output messages where the SAS/DFSORT request is invoked where you really should see the SORT statement and any preceding OPTION statement which is where you would see the file-size (estimated) directive. So, if the OP codes a //SORTDIAG DD DUMMY statement

Re: DFSORT and SAS

2021-01-19 Thread Gibney, Dave
y 19, 2021 1:09 PM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: DFSORT and SAS > > I'd ask over on MXG-L if there are methods for SAS to pass the record > count and average record length estimate to DFSORT. > > Cheers, Martin > > Martin Packer > > Systems I

Re: DFSORT and SAS

2021-01-19 Thread Martin Packer
I'd ask over on MXG-L if there are methods for SAS to pass the record count and average record length estimate to DFSORT. Cheers, Martin Martin Packer Systems Investigator & Performance Troubleshooter, IBM +44-7802-245-584 email: martin_pac...@uk.ibm.com Twitter / Facebook IDs: MartinPa

Re: DFSORT and SAS

2021-01-19 Thread Sri h Kolusu
> Thank you. Adding the suggested parm allowed my job to succeed. Dave, Glad to hear that the job is successful. > Ultimately, there where 15,890,801 records. May be you should pass 18 million as estimated filesize to account for future growth. Thanks, Kolusu DFSORT Developme

Re: DFSORT and SAS

2021-01-19 Thread Gibney, Dave
. > -Original Message- > From: IBM Mainframe Discussion List On > Behalf Of Sri h Kolusu > Sent: Tuesday, January 19, 2021 11:37 AM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: DFSORT and SAS > > > ICE752I 0 FSZ=0 RE IGN=0 C AVG=188 0 WSP=0 E DYN=2313 16352

Re: DFSORT and SAS

2021-01-19 Thread Sri h Kolusu
> ICE752I 0 FSZ=0 RE IGN=0 C AVG=188 0 WSP=0 E DYN=2313 16352 Dave, When DFSORT is invoked via program, it needs to know how many records it is sorting so that it can optimally allocate resources needed to sort that data. Since the program is feeding the records DFSORT does not have a c

DFSORT and SAS

2021-01-19 Thread Gibney, Dave
I recently switched to DFSORT. Hopefully this is the last glitch. My weekly MXG (SAS) job failed in the TRNDDSNS step. I am not yet familiar with DFSORT messages. The step has REGION=0M and I have no special memory exits. The SAS SORT options are: DYNALLOC SORTDEV=3390 SORTBLKMODE SORTDEVWARN

Re: Bug in DFSORT? [WAS: Merging multiple records using DFSORT]

2021-01-15 Thread Sri h Kolusu
> And that's the way IBM nowadays treats it's customers? Customer? If you are a customer you would have gone thru proper channels of opening a PMR and Level 2 would answer your questions. Please do that. >Too bad I don't have the > email address of Arvind Krishna, I would have loved to CC: this

Re: Bug in DFSORT? [WAS: Merging multiple records using DFSORT]

2021-01-15 Thread Seymour J Metz
obert Prins [rob...@prino.org] Sent: Friday, January 15, 2021 2:57 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Bug in DFSORT? [WAS: Merging multiple records using DFSORT] On 2021-01-15 16:22, Sri h Kolusu wrote: >> >> Please don't patronise me with high "coding standards&qu

Re: Bug in DFSORT? [WAS: Merging multiple records using DFSORT]

2021-01-15 Thread Robert Prins
On 2021-01-15 16:22, Sri h Kolusu wrote: Please don't patronise me with high "coding standards", you banned me from your forum when I commented on the fact that you suggested using UNSPEC() to look at the internal representation of z/OS HEX FLOAT values in order top print them in a PL/I

Re: Bug in DFSORT? [WAS: Merging multiple records using DFSORT]

2021-01-15 Thread Sri h Kolusu
product. Thanks, Kolusu IBM Mainframe Discussion List wrote on 01/15/2021 10:53:50 AM: > From: Robert Prins > To: IBM-MAIN@LISTSERV.UA.EDU > Date: 01/15/2021 08:54 AM > Subject: [EXTERNAL] Re: Bug in DFSORT? [WAS: Merging multiple > records using DFSORT] > Sent by: IBM Mainframe Dis

Re: Bug in DFSORT? [WAS: Merging multiple records using DFSORT]

2021-01-15 Thread Robert Prins
ipping the first set of data Now issue the same command but changing the position to 80 F '+' 80 ALL Also make a note of how many number of times the character is found (9 times) Hint : It is found on the FIRST/SECOND/THIRD line of the boxed data starting with the first set of data. DFSORT is merely

Re: Bug in DFSORT? [WAS: Merging multiple records using DFSORT]

2021-01-15 Thread Sri h Kolusu
te of how many number of times the character is found (9 times) Hint : It is found on the FIRST/SECOND/THIRD line of the boxed data starting with the first set of data. DFSORT is merely doing what you wanted it to do. So I am not sure comparing a 5 time found data with 9 times found data is correct.

Bug in DFSORT? [WAS: Merging multiple records using DFSORT]

2021-01-14 Thread Robert Prins
On 2021-01-12 16:12, Robert Prins wrote: I'm currently using this... I've posted the question to , and someone came up with a really very elegant way of performing this task, but his solution, unlike the one I posted in the start of this

Merging multiple records using DFSORT

2021-01-12 Thread Robert Prins
I'm currently using this * Merge the LW file * * These sort commands can handle both the old, it's left unchanged, as * well as the new, records are merged, LW output file. *** OPTION COPY INREC

Re: DFSORT Header + Detail count match

2020-12-14 Thread Ron Thomas
Thanks a lot Kolusu. It worked great . 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 Header + Detail count match

2020-12-11 Thread Sri h Kolusu
> I coded the below DFSORT job , but it is not working . Could some > one please let me know where the issue is ? There are couple of issues with your job. 1. COUNT-n field is limited to 15 digits and you are creating a 17 byte field which would have 2 spaces to the left of the count

DFSORT Header + Detail count match

2020-12-11 Thread Ron Thomas
2020-12-09 980012589|04937|03448 980010506|04937|02698 980001772|04937|03288 000276258|04937|03788 980012589|04936|03448 980010506|04936|02698 980001772|04936|03288 I coded the below DFSORT job , but it is not working . Could some one please

Re: SFTP Sortcard creating using DFSORT

2020-12-09 Thread Ron Thomas
Thanks a lot Kolusu .. Regards Ron -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: SFTP Sortcard creating using DFSORT

2020-12-09 Thread Sri h Kolusu
'), and then we parsed the store number with %01 and then used Justify (JFY) to the parsed store number to add _ at the beginning using LEAD and the .CSV at the end using TRAIL keywords. If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: G

Re: SFTP Sortcard creating using DFSORT

2020-12-09 Thread Ron Thomas
Thanks a lot Kolusu.. it worked like a charm ! Could you please help me to understand the below card as to how it is picking the store_nbr and create NREC PARSE=(%=(REPEAT=2,ENDAT=C'}'), %01=(ENDBEFR=C'{', ENDBEFR=C' ', FIXLEN=8)),

Re: SFTP Sortcard creating using DFSORT

2020-12-08 Thread Sri h Kolusu
> but the issue is the store_nbrs are of different length, the .csv is > not getting created correctly . Could some one let me know how we > can append the .csv also when the store is of variable length > Ron, Try this DFSORT JCL //STEP0100 EXEC PGM=SORT //SYSOUT DD SYSOUT=* /

SFTP Sortcard creating using DFSORT

2020-12-08 Thread Ron Thomas
Hello- I am creating a dynamic SFTP sortcard using DFSORT, here in the Input file the Store_nbr is at position 40. I need the file to created as SPUT 'K01.BB.RST.PTEM.FUTR.RTLDTA.REPT01' FUTRETAIL_2020-12-07_33.csv but the issue is the store_nbrs are of different length, the .csv

Re: How to get CEEDUMP with DFSORT?

2020-11-18 Thread Gibney, Dave
I have hat set per the instructions. I really am now leaning towards my programmers wouldn't have got the CEEDUMP in this case, has they still been using the other sort product. But, since DFSORT is new, it is a viable culprit. And, really, the program's diagnostic messages should have been

Re: How to get CEEDUMP with DFSORT?

2020-11-18 Thread Sri h Kolusu
> In the case my programmers found, there was a call for a user abend > with value of 36. As I think on this, I have no idea for sure that > behavior from Syncsort would have been different. Dave, I believe I sent out the migration documents which lists the equivalent parms f

Re: How to get CEEDUMP with DFSORT?

2020-11-18 Thread Gibney, Dave
Thank you and understood about the different environments. > -Original Message- > From: IBM Mainframe Discussion List On > Behalf Of Sri h Kolusu > Sent: Wednesday, November 18, 2020 3:56 PM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: How to get CEEDUMP with DFSORT? &

Re: How to get CEEDUMP with DFSORT?

2020-11-18 Thread Gibney, Dave
. As Seymour points out, this wasn't a program check. > -Original Message- > From: IBM Mainframe Discussion List On > Behalf Of Seymour J Metz > Sent: Wednesday, November 18, 2020 4:34 PM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: How to get CEEDUMP with DFSORT? >

Re: How to get CEEDUMP with DFSORT?

2020-11-18 Thread Clark Morris
[Default] On 18 Nov 2020 15:56:00 -0800, in bit.listserv.ibm-main skol...@us.ibm.com (Sri h Kolusu) wrote: >> Thank you, I had read this. I expect that doing this will return me >> to the CEEDUMP behavior I had the other sort product. I was hoping >> for an option where the

Re: How to get CEEDUMP with DFSORT?

2020-11-18 Thread Seymour J Metz
: Wednesday, November 18, 2020 6:55 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: How to get CEEDUMP with DFSORT? > Thank you, I had read this. I expect that doing this will return me > to the CEEDUMP behavior I had the other sort product. I was hoping > for an option where the DFSORT te

Re: How to get CEEDUMP with DFSORT?

2020-11-18 Thread Sri h Kolusu
> Thank you, I had read this. I expect that doing this will return me > to the CEEDUMP behavior I had the other sort product. I was hoping > for an option where the DFSORT termination would continue on to the > LE termination. That was my specific question. Will, or can I get the CE

Re: How to get CEEDUMP with DFSORT?

2020-11-18 Thread Gibney, Dave
Thank you, I had read this. I expect that doing this will return me to the CEEDUMP behavior I had the other sort product. I was hoping for an option where the DFSORT termination would continue on to the LE termination. That was my specific question. Will, or can I get the CEEDUMP? I still

Re: How to get CEEDUMP with DFSORT?

2020-11-18 Thread Sri h Kolusu
>Would setting DFSORT ESTAE=NO let the CEEDUMP happen. I see the > odds of having an application data error to be much larger that an > actual problem with DFSORT Dave, You can use NOESTAE to turn off DFSORT ESTAE processing. //DFSPARM DD * DEBUG NOABEND,NOESTAE /* Check this l

How to get CEEDUMP with DFSORT?

2020-11-18 Thread Gibney, Dave
My programmers have gotten pretty good with CEEDUMPs for their COBOL errors. And, when our COBOL invokes Syncsort with RC16= ABE and IOERR = NOABE we do get a CEEDUMP. I have TERMTHDACT(DUMP,CESE,256) for my LE parms Would setting DFSORT ESTAE=NO let the CEEDUMP happen. I see

Re: Another DFSORT Question

2020-10-30 Thread Sri h Kolusu
Cameron. I sent you an offline email with a generic solution which covers all the issues that I raised. Let me know if you have any questions. Thanks Kolusu DFSORT Development IBM Corporation -- For IBM-MAIN subscribe

Re: Another DFSORT Question

2020-10-30 Thread Cameron Conacher
SYSIN can be a PDS with member name. So the maximum length > of PDS+Member = 54 bytes ( 44 Dsn name+ 8 byte member name + 2 byte for > opening and closing parenthesis). However your control cards don't seem to > be h

Re: Syncsort to DFSORT - my time has come.

2020-10-29 Thread Gibney, Dave
, October 29, 2020 8:58 AM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: Syncsort to DFSORT - my time has come. > > >>For compatibility and migration purposes, is there a way for DFSORT to > accept this specification? > > Unfortunately NO. The other product had to i

Re: Another DFSORT Question

2020-10-29 Thread Sri h Kolusu
e above questions and I will show you the optimized control cards. Thanks, Kolusu DFSORT Development IBM Corporation -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the

Another DFSORT Question

2020-10-29 Thread Cameron Conacher
Hello , I have put together this set of SORT control statements to scan through an IEBPTPCH dump of a JCL or PROC PDS. The DFSORT statements will look for any JOB Steps that execute program DMBATCH (this is an NDM Program). The statements will gather up some DD Statement information related

Re: Syncsort to DFSORT - my time has come.

2020-10-29 Thread Sri h Kolusu
>>For compatibility and migration purposes, is there a way for DFSORT to accept this specification? Unfortunately NO. The other product had to introduce the formats for compensating the rich functionality of JNF1CNTL and JNF2CNTL in DFSORT. DFSORT gives you the entire INREC formatting wit

Re: Syncsort to DFSORT - my time has come.

2020-10-29 Thread Gibney, Dave
Thank you. Mos of our "fancy" sort stuff is mine, so I can make these changes. But, and this is just asking, not really expecting. For compatibility and migration purposes, is there a way for DFSORT to accept this specification? I have 4 LPARs. This job runs in 3 of them. 2 still ru

Re: DFSORT wizard help

2020-10-29 Thread Ray Pearce
ave this as an exercise for the reader. Ray -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Ituriel do Neto Sent: 29 October 2020 11:06 To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: DFSORT wizard help Gentlemen, The logical record i want sta

Re: DFSORT wizard help

2020-10-29 Thread Ituriel do Neto
Gentlemen, The logical record i want starts with a "{" and ends with "}" Thanks Ituriel Em quarta-feira, 28 de outubro de 2020 19:13:58 BRT, Paul Gilmartin <000433f07816-dmarc-requ...@listserv.ua.edu> escreveu: On Wed, 28 Oct 2020 20:40:54 +, Ituriel do Neto wrote: >Hi, >I have

Re: Syncsort to DFSORT - my time has come.

2020-10-29 Thread Sri h Kolusu
Dave, DFSORT Joinkeys does not require the FORMAT of the key field as a binary match is done implicitly. So change your control cards to the following(Just removed the CH on the Fields statement) JOINKEYS FILE=F1,FIELDS=(1,9,A),TYPE=F JOINKEYS FILE=F2,FIELDS=(6,9,A), INCLUDE=(6,9,CH,EQ

Re: Syncsort to DFSORT - my time has come.

2020-10-28 Thread Gibney, Dave
$ ICE007A 1 SYNTAX ERROR ICE751I 0 C5-I58435 C6-BASE C7-I58435 C8-I58435 E7-I58377 ICE052I 3 END OF DFSORT > -Original Message- > From: IBM Mainframe Discussion List On &g

Re: DFSORT wizard help

2020-10-28 Thread Sri h Kolusu
2,"IH":43,"X":306} {"date":"20200616-0900","MMSU":11403,"IH":51,"X":307} {"date":"20200616-1000","MMSU":11459,"IH":56,"X":308} {"date":"

Re: DFSORT wizard help

2020-10-28 Thread Paul Gilmartin
On Wed, 28 Oct 2020 20:40:54 +, Ituriel do Neto wrote: >Hi, >I have an omvs file and would like to separate the fields into multiple >lines.The input file has the following format: > What's your criterion for separating fields into lines? Your example is insufficiently informative. >

<    1   2   3   4   5   6   7   8   9   10   >