Search found 13 matches
- 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...
- 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:...
- Thu Feb 11, 2016 12:27 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Extract
- Replies: 2
- Views: 3736
- 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...
- 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...
- 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...
- Wed Oct 01, 2014 11:57 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Sum Fields
- Replies: 4
- Views: 6235
- Wed Oct 01, 2014 11:43 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Sum Fields
- Replies: 4
- Views: 6235
- 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 ...
- 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...
- 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...
- 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...
- 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)...