http://www.cobolscripting.com Best Regards, Matt Dean Statistics: Posted by deskware — Wed Feb 01, 2023 3:21 am ..read more

Hi, I have a requirement where I need to build a sort card dynamically for group of records. I have coded the below to build the sort conditions dynamically, it works fine but I am unable to do so for group of records. Input is as below: Input.png The group is identified when value changes in position (41,3) in input file My job: //SORT3 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //SYSPRINT DD SYSOUT=* //SORTIN DD DSN=TTYA.EMANIP.MERCHANT.IN,DISP=SHR //SORTOUT DD DSN=TTYA.EMANIP.MERCHANT.OUT, // DISP=(OLD,CATLG,DELETE),RECFM=FB, // LRECL=80,SPACE=(CYL,(30,20),RLSE) //SYSIN DD * OPTION COPY OUTFIL R ..read more

Hi, Does anybody knows whats' the reason of this error: MSG2103JE,PEDIBEVK,1,DCPROD *M NNNNNNNNNNNN ,MEMBER IS NOT JCL, NOT PROCESSED Thanks any help, Cesar Altamirano Statistics: Posted by cesaralt — Fri Nov 27, 2020 7:11 pm ..read more

Hi All, I have an input like this <Request RequestID="5803727242796658404053" <BillTo> <CustomerID/> </BillTo> <Events> <Event> <Event>Stop Payment</Event> <EventDate>2020-01-31T16:00:00Z</EventDate> </Event> </Events> </Request> <Request RequestID="5809478787336002204087" <BillTo> <CustomerID/> </BillTo> <Events> <Event> </Request> There are two XML's in my input, I need to write only the first set into the output file, I dont want the second set as it doesnt contain Variables ..read more

Hi All, My requirement is to read the xml file and fetch the values stored in XML tag. For which I had used XMLTABLE. I am getting SQL code - 100 during fetch, I tried several things, but, everything returns only SQL - 100 during Fetch. Can someone please look at this and correct the code and help me on this ? Input XML in the form of dataset : <?xml version="1.0" encoding="utf-8"?> <Report Name="PaymentEventDetailReport_Daily_Classic" Type="ProcessorEventsDetail" Version="1.11" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="https://api.source ..read more

Hi, Use Intertest/Expeditor for debugging Statistics: Posted by vikriih — Wed Sep 18, 2019 1:42 pm ..read more

For Sorting you can use SYNCSORT Statistics: Posted by vikriih — Wed Sep 18, 2019 1:36 pm ..read more

I have a variable length record with each field delimited by the '@' character. The first field on the record is 16 bytes in length in packed format. I want to output the record with this field changed to its 32 character hex format. The rest of the record stays the same. Statistics: Posted by may132012 — Mon Jul 29, 2019 1:01 pm ..read more

Hi, It will be great help if I get an help in getting the below requirement using SORT. I have a file with around 27 Million records, with record length of 350 bytes and Rec FM is FB sample is as below 111111111 0011 some other data 111111111 2002 some other data 111111111 2002 some other data 111111111 2012 some other data 111111111 2012 some other data 111111111 9999 some other data 222222222 0011 some other data 222222222 2002 some other data 222222222 9999 some other data 333333333 0011 some other data 333333333 2012 some other data 333333333 9999 some other data here 1 to 9 bytes is t ..read more

Hello team, For copying data in a large number of DB2 tables in one Mainframe region to another, I'm currently working on comparing the table structures (columns and indexes). I have been managing to do this in the past when there were only handful of tables to be compared. Right now, I'm supposed to do this for 100s of tables in short span of time. I have tried accomplishing this by extracting the DDLs through BMC Catalog Manager and by fetching out the COLUMNS and INDEXES from SYSCOLUMNS and SYSINDEXES tables. However, comparing them is posing a great difficulty for me. Please advise and ..read more