Search found 13 matches

by pawan.konduru
Fri Feb 22, 2019 9:47 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Split the file into multiple
Replies: 0
Views: 9503

Split the file into multiple

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 11111...
by pawan.konduru
Tue Aug 09, 2016 4:41 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Sequence Number update for the duplicate records
Replies: 0
Views: 5411

Sequence Number update for the duplicate records

Hi, We have a table as below with 3 columns V_NUMBER,D_CREATED and N_PGM EC599980| 10/12/2015 12:00:00 AM | PGM1 EC599980| 10/09/2015 12:00:00 AM | PGM2 EC492925| 10/26/2015 12:00:00 AM | PGM1 EC503933| 11/15/2015 12:00:00 AM | PGM1 EC503933| 11/12/2015 12:00:00 AM | PGM1 EC503933| 11/11/2015 12:00:...
by pawan.konduru
Thu Feb 11, 2016 12:27 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Extract
Replies: 2
Views: 3736

RECL=80, RECFM=FB
by pawan.konduru
Tue Feb 09, 2016 2:31 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Extract
Replies: 2
Views: 3736

Extract

Hi, can someone do the needful, I have a file with the below inforamtion, i need to extract the 4 lines from the file when the Pos: 4 to 6 bytes of line 1 have the value G1151C and a value 000-59929 in Line-3 Pos 1 9 1 xxxG1151C 2 034 3 000-59929 4 9896.00 1 xxx G1151B 2 0565 3 000-58053 4 1235.00 1...
by pawan.konduru
Tue Oct 07, 2014 6:48 pm
Forum: JCL
Topic: Actual execution time of the job
Replies: 3
Views: 14112

Actual execution time of the job

My requirment is, in my project some of the processes are converting into Informatica. so i want to compare the execution time in mainframe vs informatic. here in mainframe whenever i submit the job the Total CPU Time is varying which is depending on the CPU avaliability, so how to know the actual e...
by pawan.konduru
Tue Oct 07, 2014 1:56 am
Forum: JCL
Topic: Actual execution time of the job
Replies: 3
Views: 14112

Actual execution time of the job

Hi, can any one tell me how to get the actual execution time of a job. as per my understanding the execution time will be depend on the CPU utilization, so how to know actual time if the CPU utilization is 100%. For ex. below are the stats for the job STARTED - TIME=16.04.34 ENDED - TIME=16.08.36 TO...
by pawan.konduru
Wed Oct 01, 2014 11:57 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Sum Fields
Replies: 4
Views: 6235

INREC FIELDS=(1:1,30,31:31,17,ZD)
SORT FIELDS=(3,9,CH,A),EQUALS
SUM FIELDS=(31,17,ZD),XSUM
by pawan.konduru
Wed Oct 01, 2014 11:43 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Sum Fields
Replies: 4
Views: 6235

here if i use 00000000400000000+

17 length it is showing "INVALID SUM DATA FIELD "
by pawan.konduru
Wed Oct 01, 2014 10:27 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Sum Fields
Replies: 4
Views: 6235

Sum Fields

Hi, I have a requirment 1 to 10 is the Key and to have sum fields on 30 to 43 position, should consider +,- here is the input file 08CD339913 B020097804USD1 S 00000000400000000+ 08CD339913 B09300BA03USD0 O 00000000200000000- 08CD339913 B093000776USD0PD 00000000200000000+ 08CD340313 B020077087USD1 S ...
by pawan.konduru
Thu Mar 27, 2014 9:10 pm
Forum: JCL
Topic: Compare Two Files
Replies: 2
Views: 4713

Thanks NicC Excluding the Header and Trailer is because we will have Date Field in the Header. in our process we are concatenating 2 generations and if two generations have duplicate we need to send notification to the clients. Also copying the concatenated data in VSAM file for further input to pro...
by pawan.konduru
Thu Mar 27, 2014 11:43 am
Forum: JCL
Topic: Compare Two Files
Replies: 2
Views: 4713

Compare Two Files

i need to compare the Two Flat files excluding Header and Trailer. Both the files is haivng header and trailer. both the files is having same record Length. simply to say i need to compare the current generation to previous generation to check whether received duplicate file. if we recieve any dupli...
by pawan.konduru
Tue Feb 18, 2014 11:02 am
Forum: EASYTRIEVE
Topic: Dynamically passing value to calling program in Easytrieve
Replies: 5
Views: 7712

Hi Collins, here is the code in cobol program which i am using working storage i defined a field 01 WS-PARM-REGION PIC X(04). 88 88-PARM-XXX VALUE 'XXX '. 88 88-PARM-YYYY VALUE 'YYYY'. Linkage Section: LINKAGE SECTION. 01 PARM. 05 LNGTH PIC S9(04) COMP. 05 PARM-REGION PIC X(04). PROCEDURE DIVISION U...
by pawan.konduru
Mon Feb 17, 2014 11:42 am
Forum: EASYTRIEVE
Topic: Dynamically passing value to calling program in Easytrieve
Replies: 5
Views: 7712

Dynamically passing value to calling program in Easytrieve

hi, Please help me if anyone know the code. I have an easytrive which is calling a COBOL program using CALL statement. I want to pass a value to the COBOL Program which is like PARM. below is the code which i tried to pass, but it is not working WS-PARM1 W 4 A VALUE 'XXX ' CALL PGM1 USING (WS-PARM1)...