Re: Can DFSORT assign custom Return Code values?

t;From what I have read this is not possible, but I decided to throw it out >there to see if something is possible. > >I have a block of JCL with a bunch f steps. >I have symbolic parameters assigned. (JP1/JP2 SYSPLEX Symbolics for DFSORT) > >I was looking for a Utility that

Re: Can DFSORT assign custom Return Code values?

signed. (JP1/JP2 SYSPLEX Symbolics for DFSORT) > > I was looking for a Utility that would examine the value of a Symbolic and > assign a User Return Coe value. RC1 = Development; RC2 = Pre-Production; > RC3 = Production? > I need a Return Code value to be able to conditionally execu

Re: Can DFSORT assign custom Return Code values?

need since I could write a tiny program for this. Cameron, DFSORT has limited ability to set a return code but not the way you want. However, I think we can solve your issue quite easily by validating the symbol and only generating the steps that needs to run for that Symbolic. Remember

Can DFSORT assign custom Return Code values?

Hello everyone, From what I have read this is not possible, but I decided to throw it out there to see if something is possible. I have a block of JCL with a bunch of steps. I have symbolic parameters assigned. (JP1/JP2 SYSPLEX Symbolics for DFSORT) I was looking for a Utility that would

Re: DFSORT JOINKEYS problem

>> I am really interested in your job that generates the DFSORT symbols for all >> IRRADU00 & IRRDBU00 record types Regards Jack Jack, I have sent an offline email with the PDS that contains the JCL in XMIT format to your personal id (gmail).

Re: DFSORT JOINKEYS problem

ally interested in your job that generates the DFSORT symbols for all IRRADU00 & IRRDBU00 record types Regards Jack On Thu, 15 Feb 2024 at 16:23, Sri h Kolusu wrote: > Jack, > > Since I don't have the joblog, I cannot verify that the input files are VB > or FB as your symbols xtyp

Re: DFSORT JOINKEYS problem

evenhave to filter the type records before as the job below reads the output of IRRDBU00 directly) PS: I have a job that generates the DFSORT symbols for all IRRADU00 & IRRDBU00 record types. Let me know if you are interested. //SET#HLQS SET HLQS= //* //SORT001 EXEC PGM=SORT //SYSOUT DD SY

Re: DFSORT JOINKEYS problem

Jack, I don't know the exact format of the two files. Did you check (I mean by eyes) the field position are ok ? Is the first SKIP correct ? Best regard. Max Il giorno gio 15 feb 2024 alle ore 16:35 Jack Zukt < 059cd493dd41-dmarc-requ...@listserv.ua.edu> ha scritto: > Hi all, > > I have

DFSORT JOINKEYS problem

Hi all, I have two files created using IRRDBU00. One has type 220 records, TSO segments, the other one has type 200 records, base userid information. For the userids on the 220 type records, I want to get from the 200 type records the userid, user name; last logon date; default group left four

Re: Help on DFSORT SUM FIELDS

llect. I will send an offline email with the updated symbols. 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: Help on DFSORT SUM FIELDS

: > >> DFSORT is a magnificent product but I still am in an very early user > stage. > > Jack, > > Thank you very much. > > >> You are so right about that. I was waiting for having this right before > I would attempt that step. I have to do this in sma

Re: Help on DFSORT SUM FIELDS

>> DFSORT is a magnificent product but I still am in an very early user stage. Jack, Thank you very much. >> You are so right about that. I was waiting for having this right before I >> would attempt that step. I have to do this in small steps. It is quite simple to add it i

Re: Help on DFSORT SUM FIELDS

Kolusu, You are so right about that. I was waiting for having this right before I would attempt that step. DFSORT is a magnificent product but I still am in an very early user stage. I have to do this in small steps. Thank you once again for your help Best wishes Jack On Thu, 7 Sept 2023 at 16:33

Re: Help on DFSORT SUM FIELDS

63BIT ALLOCATED SPACE IN DCDALLSX Similarly you need to check for record types "B" and "M" Thanks, Kolusu DFSORT Development IBM Corporation -- For IBM-MAIN subscribe / signoff / archive access instructio

Re: Help on DFSORT SUM FIELDS

ting the right > results. If you are still getting incorrect results, then please terse the > DCOLLECT file and send it as an attachment to my email offline and I will > see if I can find something. > > Thanks, > Kolusu > DFSORT Development > IBM Corporation > > > >

Re: Help on DFSORT SUM FIELDS

ts. If you are still getting incorrect results, then please terse the DCOLLECT file and send it as an attachment to my email offline and I will see if I can find something. Thanks, Kolusu DFSORT Development IBM Corporation --

Re: Help on DFSORT SUM FIELDS

SP2:UMALLSP)),* MIGRATED SPACE >> >> IFTHEN=(WHEN=NONE, >> OVERLAY=(TMP-UBALLSP2:UBALLSP)) * BACKUP SPACE >> >> SORT FIELDS=(FMT-HLQ,A) * SORT BY DATASET HLQ >> >> OUTFIL INCLUDE=(FMT-HLQ,EQ,C'JACKZUKT') >

Re: Help on DFSORT SUM FIELDS

OVERLAY=(TMP-UMALLSP2:UMALLSP)),* MIGRATED SPACE > > IFTHEN=(WHEN=NONE, > OVERLAY=(TMP-UBALLSP2:UBALLSP)) * BACKUP SPACE > > SORT FIELDS=(FMT-HLQ,A) * SORT BY DATASET HLQ > > OUTFIL INCLUDE=(FMT-HLQ,EQ,C'JAC

Re: Help on DFSORT SUM FIELDS

tput for the field values of all the space fields that you added. Thanks, Kolusu DFSORT Development IBM Corporation -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the

Re: Help on DFSORT SUM FIELDS

ALLOC SPACE > > IFTHEN=(WHEN=(DCURCTYP,EQ,UKTMIGR), > OVERLAY=(TMP-UMALLSP2:UMALLSP)),* MIGRATED SPACE > > IFTHEN=(WHEN=NONE, > OVERLAY=(TMP-UBALLSP2:UBALLSP)) * BACKUP SPACE > > > > Thanks, > Kolusu > DFSORT

Re: Help on DFSORT SUM FIELDS

), OVERLAY=(TMP-UMALLSP2:UMALLSP)),* MIGRATED SPACE IFTHEN=(WHEN=NONE, OVERLAY=(TMP-UBALLSP2:UBALLSP)) * BACKUP SPACE Thanks, Kolusu DFSORT Development IBM Corporation -Original Message- From: IBM Mainframe Discussion List On Behalf Of Sri h Kolusu Sent

Re: Help on DFSORT SUM FIELDS

earlier had a similar issue. https://www.mail-archive.com/ibm-main@listserv.ua.edu/msg124452.html Thanks, Kolusu DFSORT Development IBM Corporation -- For IBM-MAIN subscribe / signoff / archive access instructions, send em

Help on DFSORT SUM FIELDS

Hi all, I am trying to process DCOLLECT type "D"; "B"; "M"; records in order to get one record by HLQ with the allocated space by active files, migrated files and backup files, and I am doing something wrong because I am getting one output record for each input record, instead of the few hundreds

Re: Syncsort > DFsort migration

@LISTSERV.UA.EDU Subject: Re: Syncsort > DFsort migration >> It was the thread in January 12th 2023, with subject "DFSORT maximum input >> records". The message that kicked it off was: Thanks Michael. It is good to know the other products limits. DFSORT has raised the li

Re: Syncsort > DFsort migration

>> It was the thread in January 12th 2023, with subject "DFSORT maximum input >> records". The message that kicked it off was: Thanks Michael. It is good to know the other products limits. DFSORT has raised the limit with Sort accelerator to 65,536 times than the

Re: Syncsort > DFsort migration

It was the thread in January 12th 2023, with subject "DFSORT maximum input records". The message that kicked it off was: From: Charles Hardee Subject: DFSORT maximum input records MIME-Version: 1.0 I am trying to sort roughly 4295217295, records using DFSORT. DFSORT issues a mess

Re: Syncsort > DFsort migration

On Mon, Aug 28, 2023, at 11:59 AM, Tom Brennan wrote: > LOL "a while" > Don't worry, IBM would sell you Capacity-on-Demand while the job ran. Kirk Wolf Dovetailed Technologies http://coztoolkit.com -- For IBM-MAIN subscribe /

Re: Syncsort > DFsort migration

LOL "a while" On 8/28/2023 9:49 AM, Sri h Kolusu wrote: I think it was mentioned in this list previously that EQUALS in DFSORT has a lower limit on maximum number of records than SYNCSORT. Michael, Can you please provide link to that topic that mentions that DFSORT has a lower

Re: [EXTERNAL] Re: Syncsort > DFsort migration

I don't care how fast your computer is, that would take a while to sort! LOL Rex -Original Message- From: IBM Mainframe Discussion List On Behalf Of Sri h Kolusu Sent: Monday, August 28, 2023 11:50 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: [EXTERNAL] Re: Syncsort > DFsort migrat

Re: Syncsort > DFsort migration

>> I think it was mentioned in this list previously that EQUALS in DFSORT has a >> lower limit on maximum number of records than SYNCSORT. Michael, Can you please provide link to that topic that mentions that DFSORT has a lower limit than the other product? We do have limits an

Re: [EXTERNAL] Re: Syncsort > DFsort migration

I think it was mentioned in this list previously that EQUALS in DFSORT has a lower limit on maximum number of records than SYNCSORT. -Original Message- From: IBM Mainframe Discussion List On Behalf Of Pommier, Rex Sent: Monday, August 28, 2023 10:54 AM To: IBM-MAIN@LISTSERV.UA.EDU

Re: Syncsort > DFsort migration

>> Is this the behavior generally known in IT as a "stable" sort? I find no >> mention of stable sort in the DFSORT documentation. Gil, Yes, EQUALS parm which keeps the dup keys in the order and what some call it as "stable" sort. DFSORT documentatio

Re: [EXTERNAL] Re: Syncsort > DFsort migration

Gil, I had to look up "stable sort" as I hadn't heard the term. Yes that is what EQUALS does in both DFSort and Syncsort. FYI, I searched the Syncsort programmer's manual and it doesn't mention "stable sort" either. :-) Rex -Original Message- From: IBM Mainf

Re: Syncsort > DFsort migration

identically >for a sort or a merge should be preserved from input to output. > Is this the behavior generally known in IT as a "stable" sort? I find no mention of stable sort in the DFSORT documentation. -- gil -

Re: Fwd: Syncsort > DFsort migration

>> The only issue I ran into (this was years ago) was that if you use the PARM >> in Syncsort of “EQUAL” expect different output in DFSORT ED, EQUALS is the parm which comes into picture when your input has duplicates on the key, and you want to retain the order of the duplica

Fwd: Syncsort > DFsort migration

The only issue I ran into (this was years ago) was that if you use the PARM in Syncsort of “EQUAL” expect different output in DFSORT.. We did not run into this but a friend did. There are items in Syncsort that are different in DFSORT. Syncsort made the decision that some of the (I do not have

Re: Syncsort > DFsort migration

>>., an application sort execution, such as SAS-invoked PROC SORT under DFSORT >>does not exploit zSORT/SORTL (SAS INSTITUTE responded "not planned >>enhancement, and customers are not asking for it either.") Scott, Program invoked Sorts can exploit zSORT/SORT

Re: Syncsort > DFsort migration

On Sat, 26 Aug 2023 11:52:58 +, Richard McIntosh wrote: >We are starting to do a very rushed syncsort to DFsort migration. >I am assuming most of the sort ports are identical, but I bet not all of them. >Does anyone have a list of parms that need to be looked at? >Or anythin

Re: Syncsort > DFsort migration

>> We are starting to do a very rushed syncsort to DFsort migration. Richard, Thank you for your interest in migrating to DFSORT. I will send you an offline mail with a couple of attachments which describes in detail about the parms and the needed changes. Thanks, Sri Hari Kolusu

Syncsort > DFsort migration

We are starting to do a very rushed syncsort to DFsort migration. I am assuming most of the sort ports are identical, but I bet not all of them. Does anyone have a list of parms that need to be looked at? Or anything thing else that I should be aware of. Thanks in advance for your time

Re: Dfsort Overlay error

Thanks a lot Kolusu. Sorry i didn't articulate what is documented in the user guide in the right way . Anyway thanks again for all the help .. Regards Ron T -- For IBM-MAIN subscribe / signoff / archive access instructions,

Re: Dfsort Overlay error

>> Here is what i am getting . Could you please let me what changes to be made ? Ron, Sigh ! Not sure as to how you invent your own syntax hope and that it would work. You switched back to using 10 bytes despite me showing that the max length is only 8 bytes? and you coded 10 bytes without a

Re: Dfsort Overlay error

Hi Kolusu - Here is what i am getting . Could you please let me what changes to be made ? ICE000I 1 - CONTROL STATEMENTS FOR 5650-ZOS, Z/OS DFSORT V2R4 - 13:36 ON FRI AU OPTION COPY OUTREC IFTHEN=(WHEN=(35,10,CH,EQ,X'

Re: Dfsort Overlay error

T is 8 bytes. But you are using 10 bytes. Is there a reason that you are NOT showing the error messages you got from the control cards you used? The DFSORT error messages will let you know the reason for the failure. Thanks,

Re: Dfsort Overlay error

Thanks Kolusu for sharing the link . still i am not able to figure out the same . Modified as below and still not working OPTION COPY OUTREC IFTHEN=(WHEN=(35,10,CH,EQ,X'', AND,25,10,CH,GT,X''), OVERLAY=(35:25,10,Y4T,ADDDAYS,+120))

Re: Dfsort Overlay error

>> could someone please let me know what the issue is in the control card as it >> is giving error . Ron, Looks like you invented your syntax , which is NOT valid with DFSORT. Search for "Adding or Subtracting Days" in the below link and you will see the right syntax.

Dfsort Overlay error

Hi - I have a file of LRECL 44 and need to overlay a date in Position 35 by adding 120 days to the date at position 25 The overlay to be done based also on condition . Coded as below OPTION COPY OUTREC IFTHEN=(WHEN=(35,10,CH,EQ,X'',

Re: Need DFSORT control statements to extract data from smf15 with storclas blank

On 24/07/2023 11:17 pm, Sri h Kolusu wrote: Was that a typo ? Isn't it supposed to be SMF15SCN ? or you are using SMF14 record layout with SMF15 Interchangeably as they are both have the same layout? The SMF 14 and 15 layouts are the same, so there is one implementation for both. This

Re: Need DFSORT control statements to extract data from smf15 with storclas blank

>>|| r15.smsClassSections().get(0).smf14scn().equals("")) Andrew, Was that a typo ? Isn't it supposed to be SMF15SCN ? or you are using SMF14 record layout with SMF15 Interchangeably as they are both have the same layout? Thanks, Kolusu

Re: Need DFSORT control statements to extract data from smf15 with storclas blank

On 22/07/2023 12:46 am, shivang sharma wrote: Hi , I am not a DFSort expert but we have a requirement to extract datasets which has storclas (SMF15SCN) = blank. Not DFSORT, but this is what it looks like in Java using EasySMF: import java.io.IOException; import

Re: Need DFSORT control statements to extract data from smf15 with storclas blank

anks, 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: Need DFSORT control statements to extract data from smf15 with storclas blank

Hi Sri, So for example, SMF15_HIPER_SIZE will be 20 bytes (if the HiperBatch section exists)? https://www.ibm.com/docs/en/zos/2.4.0?topic=mapping-hiperbatch-section - KB --- Original Message --- On Friday, July 21st, 2023 at 9:48 PM, Sri h Kolusu wrote: > > > I am not

Re: Need DFSORT control statements to extract data from smf15 with storclas blank

Shivang, Well, here is something that I wrote on the fly. It has a COBOL exit that will return the information to DFSORT and then the ICETOOL job will generate a deport of all the datasets that has spaces in the STORCLAS. You will need COBOL 6.xx versions as I am using functions like BIT

Re: Need DFSORT control statements to extract data from smf15 with storclas blank

>> I am not a DFSort expert but we have a requirement to extract datasets which >> has storclas (SMF15SCN) = blank. Shivang Sharma, SMF15SCN is a part of Extended Information Segment which does NOT have a standard offset. You need to dynamically calculate the offset based on

Need DFSORT control statements to extract data from smf15 with storclas blank

Hi , I am not a DFSort expert but we have a requirement to extract datasets which has storclas (SMF15SCN) = blank. If someone has a ICETOOL code to do that please provide. At this shop we do not have tools like SAS/MXG

Re: DFSORT - adding up on a field

Thank you very much Kolusu. That did the trick Best wishes Jack On Thu, 13 Jul 2023 at 17:40, Sri h Kolusu wrote: > Jack, > > If your intention is to count the number of Storage group and DASD Model, > then you can init with a counter of 1 and then sum it up. > > Here are the updated control

Re: DFSORT - adding up on a field

Jack, If your intention is to count the number of Storage group and DASD Model, then you can init with a counter of 1 and then sum it up. Here are the updated control cards. I added a new symbol TMP-STGCNTR and initialized it with 1 using INREC and then sum that field. // DD *

DFSORT - adding up on a field

Hi, I am processing DCOLLECT volume records in order to get the total space allocated by Storage group and DASD model. What I am trying to achieve is this: SCPHSMLG 0001 0002 3390-27 27.192.079 111.778 SCPHSMLG 0002 0001 3390-09 41.572.505

Re: DFSORT and date YYYY/MM/DD

On Fri, 14 Apr 2023 17:10:31 +0100, Jack Zukt wrote: > >I have file produced by FDREPORT with this format: >... >0PRODSN1.ZOS.MLQAAA01.SAAA0001.D230320.T0541 TP0070 PACTD01 2015/07/21 >2025/08/21 57K > ... -- gil

Re: DFSORT and date YYYY/MM/DD

/04/14 (assuming the current date is 2023/04/14). So, any > record less than that date would be included. Is that your intention? > > Here is the modified include condition and changed the relational > condition to EQ. > > INCLUDE COND=(KBTYPE,EQ,C'K',AND, > L

Re: DFSORT and date YYYY/MM/DD

ed the relational condition to EQ. INCLUDE COND=(KBTYPE,EQ,C'K',AND, LRDATE,CH,EQ,DATE1(/)-365) Thanks, Kolusu DFSORT Development IBM Corporation -- For IBM-MAIN subscribe / signoff / archive access instru

DFSORT and date YYYY/MM/DD

Hi, I have file produced by FDREPORT with this format: 1FDR400FDRABR CUSTOM REPORTS - FDREPORT VER 5.4/90P INNOVATION DATA PROCESSINGDATE - 0 DATA SET NAMEVOLSER CREATJOB CRDATE LRDATE FILE SIZE -

Re: DFSORT to count and sum subsets of data

-- Original Message -- From "Sri h Kolusu" To IBM-MAIN@listserv.ua.edu Date 3/28/2023 4:00:27 PM Subject Re: DFSORT to count and sum subsets of data Wow, I did not want this to be so difficult...but given a choice, I would like the second approach Billy, It isn't that

Re: DFSORT to count and sum subsets of data

ete! Just run your existing control cards without any D records and see the output. (You will not have the filename as header, but you will have 1 row for department and total row) Thanks, Kolusu DFSORT Development IBM Corporation ---

Re: DFSORT to count and sum subsets of data

-- Original Message -- From "Sri h Kolusu" To IBM-MAIN@listserv.ua.edu Date 3/28/2023 3:14:21 PM Subject Re: DFSORT to count and sum subsets of data Kolusu, this works well when I have records to work with, but if I have no "D" records (sorry for the fat finger earlier...

Re: DFSORT to count and sum subsets of data

*** :0 ARTICLES, TOTAL ITEMS:0 What is the preferred output ? the First one or the second one? Thanks, Kolusu DFSORT Development IBM Corporation -- For IBM-MAIN subscribe / signoff / archive access in

Re: DFSORT to count and sum subsets of data

ith the 0 Articles and 0 Items. Is this possible? Thank you and best regards, Billy Ashton -- Original Message -- From "Sri h Kolusu" To IBM-MAIN@listserv.ua.edu Date 3/28/2023 12:09:14 PM Subject Re: DFSORT to count and sum subsets of data Kolusu, this works great, and t

Re: DFSORT to count and sum subsets of data

COUNT=(M10,LENGTH=8), ' ARTICLES, TOTAL ITEMS: ', TOT=(102,09,UFF,M10,LENGTH=12))), TRAILER1=('*** TOTAL *** : ', COUNT=(M10,LENGTH=8), ' ARTICLES, TOTAL ITEMS: ', TOT=(102,09,UFF,M10,LENGTH=12)) /* Thanks, Kolusu DFSORT Developme

Re: DFSORT to count and sum subsets of data

- Original Message -- From "Sri h Kolusu" To IBM-MAIN@listserv.ua.edu Date 3/27/2023 12:29:22 PM Subject Re: DFSORT to count and sum subsets of data What I want to do is produce a single line for each Department (cols 1-3), that tells me the number of articles (Count of all rows

Re: DFSORT to count and sum subsets of data

,UFF,M10,LENGTH=12)) /* 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 to count and sum subsets of data

' ARTICLES, TOTAL ITEMS: ', TOT=(102,09,UFF,M10,LENGTH=12)) /* If you intend to have the spaces trimmed in the output, let me know and I will suggest an alternative. Thanks, Kolusu DFSORT Development IBM Corporation -

Re: DFSORT to count and sum subsets of data

Subject: [EXTERNAL] DFSORT to count and sum subsets of data Hey everyone - happy Monday! I am trying to come up with a single SORT step to give me counts and a sum of a field on subsets of data, and using control breaks. Here is a sample of my input with lines shortened for the email: A01DDATE

DFSORT to count and sum subsets of data

Hey everyone - happy Monday! I am trying to come up with a single SORT step to give me counts and a sum of a field on subsets of data, and using control breaks. Here is a sample of my input with lines shortened for the email: A01DDATE 001D<< Cols 23 to 101 MISCELLANEOUS DATA >>

Re: DFSORT TRAN=LTOU and LOCALE

>> I assume UNICODE Services did this. Doesn't DFSORT use UNICODE Services? Paul, DFSORT does indeed use UNICODE services, but it ONLY limited for SORTING Unicode data and NOT for data manipulation (case conversion/ CCSID conversion..) . So far, the request for data manipulation for U

Re: DFSORT TRAN=LTOU and LOCALE

dd a FINDREP for only those characters. OUTREC BUILD=(1,80,TRAN=LTOU) OUTFIL FINDREP=(… Thanks, Kolusu DFSORT Development IBM Corporation -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@lis

Re: DFSORT TRAN=LTOU and LOCALE

ed Content-Transfer-Encoding: 8bit to two different desktop editors, vim and BBEdit. Changing case in each of them gave: ŁUKASZ ŚWIĄTEK I assume UNICODE Services did this. Doesn't DFSORT use UNICODE Services? What CCSID is implied by LOCALE=PL_pl? Does DFSORT sort Polish keys corr

DFSORT TRAN=LTOU and LOCALE

I just wanted to fold text fields to uppercase Example: SORT FIELDS=(1,20,CH,A) OUTREC BUILD=(1,80,TRAN=LTOU) It works as it should, with the exception for national characters. Examples: johh bravo -> JOHN BRAVO łukasz  świątek -? łUKASZ śWIąTEK I used LOCALE=PL_pl in DFSPARM DD, but it is

Re: DFSORT OUTREC conditional formatting

. I appreciate it. I like DFSORT, it is really powerful tool! Regards -- Radoslaw Skorupka Lodz, Poland -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: I

Re: DFSORT OUTREC conditional formatting

C2 CHANGE AAA3 BBB3 DDD3 EEE3 ERROR AAA4 BBB4 CCC4 Further if you have any questions, please let me know Thanks, Kolusu DFSORT Development IBM Corporation -- For IBM-MAIN subscribe

Re: DFSORT OUTREC conditional formatting

W dniu 24.01.2023 o 22:52, Sri h Kolusu pisze: The following scenario: Input file VB. At offset 23 (RDW included) 2-byte field Other relevant fields are 101,8 109,8 181,8 No sort needed. Radoslaw, Use the following control cards which will give you the desired results. I optimized the job

Re: DFSORT OUTREC conditional formatting

TCH=(C'ERROR '), 101,08, 109,08, 181,08) /* Thanks, Kolusu DFSORT Development IBM Corporation -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@lis

Re: DFSORT OUTREC conditional formatting

On Tue, Jan 24, 2023 at 4:08 PM Radoslaw Skorupka < 0471ebeac275-dmarc-requ...@listserv.ua.edu> wrote: > ... > I tried the following ABCDCNTL statement: > RECORD TYPE=V,LENGTH=(,,,50) > OUTREC FIELDS=(1,22,23,1,CHANGE=(8, > X'0001',C'READ' ... > and the above caused ICE111A error. >

Re: DFSORT OUTREC conditional formatting

Update inline W dniu 24.01.2023 o 20:39, Radoslaw Skorupka pisze: The following scenario: Input file VB. At offset 23 (RDW included) 2-byte field Other relevant fields are 101,8  109,8  181,8 No sort needed. ICETOOL TOOLIN: COPY FROM(INPUT) TO(TMP) USING(ABCD) DISPLAY FROM(TMP) LIST(REPORT) -

DFSORT OUTREC conditional formatting

The following scenario: Input file VB. At offset 23 (RDW included) 2-byte field Other relevant fields are 101,8  109,8  181,8 No sort needed. ICETOOL TOOLIN: COPY FROM(INPUT) TO(TMP) USING(ABCD) DISPLAY FROM(TMP) LIST(REPORT) - HEADER('desc1') ON(101,8,CH) - HEADER('desc2') ON(109,8,CH) -

Re: DFSORT APAR

> Thanks, > Kolusu > DFSORT Development > IBM Corporation > > -Original Message- > From: IBM Mainframe Discussion List IBM-MAIN@LISTSERV.UA.EDU On Behalf Of Sri > h Kolusu > > Sent: Saturday, January 21, 2023 7:13 AM > To: IBM-MAIN@LISTSERV.U

Re: DFSORT APAR

KB, As promised, we have restored the info apar and it is available here https://www.ibm.com/support/pages/apar/II13495 Thanks, Kolusu DFSORT Development IBM Corporation -Original Message- From: IBM Mainframe Discussion List On Behalf Of Sri h Kolusu Sent: Saturday, January 21

Re: DFSORT APAR

≫ This what you were looking for?? <https://www.ibm.com/support/pages/apar/II14047>II14047: USE OF DFSORT BY DB2 UTILITIES (ibm.com) Michael, No. Kekronbekron is looking for another info apar which is listed at the end of the first paragraph of the linked apar you sent. " For con

Re: DFSORT APAR

This what you were looking for?? <https://www.ibm.com/support/pages/apar/II14047>II14047: USE OF DFSORT BY DB2 UTILITIES (ibm.com) At 12:19 AM 1/21/2023, kekronbekron wrote: Content-Transfer-Encoding: base64Hello, Does anyone have a copy of this? APAR II13495 - HOW DFSORT TAKES ADV

Re: DFSORT APAR

KB, It is weekend over here; we will check with our web support and get it back restored on Monday. Thanks, Kolusu DFSORT Development IBM Corporation -Original Message- From: IBM Mainframe Discussion List On Behalf Of kekronbekron Sent: Friday, January 20, 2023 11:20 PM To: IBM-MAIN

DFSORT APAR

Hello, Does anyone have a copy of this? APAR II13495 - HOW DFSORT TAKES ADVANTAGE OF 64-BIT REAL ARCHITECTURE I don't know what IBM has against TechDocs and treating their technical employees' work with respect, to not properly organize & archive it.

Re: DFSORT maximum input records

>> UTF-8 is a variable-length encoding. Is the length of a key field specified >> in characters or in octets? Check this link which explains how DFSORT process Unicode data. Search for (UTF-8/16/32) in the link below https://www.ibm.com/docs/en/zos/2.5.0?topic=descriptions

Re: DFSORT maximum input records

On Fri, 13 Jan 2023 16:03:37 +, Sri h Kolusu wrote: > >DFSORT calls LE to process locale and convert the keys and Unicode services >for processing UTF-8/16/32 data. > UTF-8 is a variable-length encoding. Is the length of a key field specified in characters or in octets? >S

Re: DFSORT maximum input records

LOL On 1/13/2023 4:17 AM, Radoslaw Skorupka wrote: W dniu 12.01.2023 o 21:07, Tom Brennan pisze: On 1/12/2023 9:37 AM, Radoslaw Skorupka wrote: Maximum input records for DFSORT is infinity, Good to know!  I'm testing that to be sure, but it's still running... Wrong. You should generate test

Re: DFSORT maximum input records

be included in the total key length. Does DFSORT use strcoll() for such locales? Paul, DFSORT calls LE to process locale and convert the keys and Unicode services for processing UTF-8/16/32 data. >>. The Ref. has a page of usage notes on ZSORT where I don't see LOCALE >>mentioned.

Re: DFSORT maximum input records

W dniu 12.01.2023 o 21:07, Tom Brennan pisze: On 1/12/2023 9:37 AM, Radoslaw Skorupka wrote: Maximum input records for DFSORT is infinity, Good to know!  I'm testing that to be sure, but it's still running... Wrong. You should generate test data first. :-) -- Radoslaw Skorupka Lodz, Poland

Re: DFSORT maximum input records

d in the total key length. Does DFSORT use strcoll() for such locales? DFP keys? >Did you overlook this statement at the end my last post “Btw if you are >running on Z15 and higher you can use sort accelerator(with OPTION ZSORT) >which does NOT have that limit.” > I confess I sho

Re: DFSORT maximum input records

d? > > Yes, it can. Before they go down that elaborate exercise, OP needs to > answer the question “Is EQUALS really needed?” Unless OP cares about the > order of duplicate records , there is NO point of having EQUALS and without > equals th

Re: DFSORT maximum input records

et the need? Yes, it can. Before they go down that elaborate exercise, OP needs to answer the question “Is EQUALS really needed?” Unless OP cares about the order of duplicate records , there is NO point of having EQUALS and without equals there is no limit to what DFSORT can sort. Tha

Re: DFSORT maximum input records

On Thu, 12 Jan 2023 20:45:29 +, Sri h Kolusu wrote: > >As Steve smith pointed out it Is your EQUALS parm that is limiting the number >of records to be sorted. Do you really need EQUALS ( which is retain the >order of duplicates). ? If you don't need it then you can pass NOEQUALS as an

Re: [EXTERNAL] Re: DFSORT maximum input records

Of Sri h Kolusu Sent: Thursday, January 12, 2023 2:45 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: [EXTERNAL] Re: DFSORT maximum input records >> DFSORT issues a message that I have exceeded the sort input record maximum. Chuck, As Steve smith pointed out it Is your EQUALS parm that is li

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